From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/76791 Path: news.gmane.org!not-for-mail From: =?utf-8?Q?Peter_M=C3=BCnster?= Newsgroups: gmane.comp.tex.context Subject: feature request for \getspr{} Date: Fri, 08 Jun 2012 09:38:21 +0200 Message-ID: <87ipf2tfrm.fsf@micropit.couberia.bzh> Reply-To: mailing list for ConTeXt users NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Trace: dough.gmane.org 1339141110 23574 80.91.229.3 (8 Jun 2012 07:38:30 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Fri, 8 Jun 2012 07:38:30 +0000 (UTC) To: ConTeXt users Original-X-From: ntg-context-bounces@ntg.nl Fri Jun 08 09:38:29 2012 Return-path: Envelope-to: gctc-ntg-context-518@m.gmane.org Original-Received: from balder.ntg.nl ([195.12.62.10]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1Sctm8-0002tV-Nx for gctc-ntg-context-518@m.gmane.org; Fri, 08 Jun 2012 09:38:28 +0200 Original-Received: from localhost (localhost [127.0.0.1]) by balder.ntg.nl (Postfix) with ESMTP id 27D6C101DD; Fri, 8 Jun 2012 09:38:27 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at balder.ntg.nl Original-Received: from balder.ntg.nl ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with LMTP id JRqRNxQaa3DQ; Fri, 8 Jun 2012 09:38:25 +0200 (CEST) Original-Received: from balder.ntg.nl (localhost [127.0.0.1]) by balder.ntg.nl (Postfix) with ESMTP id 96877101E0; Fri, 8 Jun 2012 09:38:25 +0200 (CEST) Original-Received: from localhost (localhost [127.0.0.1]) by balder.ntg.nl (Postfix) with ESMTP id E26C9101E0 for ; Fri, 8 Jun 2012 09:38:24 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at balder.ntg.nl Original-Received: from balder.ntg.nl ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with LMTP id uMUnYBQXrZD6 for ; Fri, 8 Jun 2012 09:38:24 +0200 (CEST) Original-Received: from filter3-ams.mf.surf.net (filter3-ams.mf.surf.net [192.87.102.71]) by balder.ntg.nl (Postfix) with ESMTP id 3221E101DD for ; Fri, 8 Jun 2012 09:38:24 +0200 (CEST) Original-Received: from smtp.smtpout.orange.fr (smtp08.smtpout.orange.fr [80.12.242.130]) by filter3-ams.mf.surf.net (8.14.3/8.14.3/Debian-9.4) with ESMTP id q587cNSl025695 for ; Fri, 8 Jun 2012 09:38:23 +0200 Original-Received: from micropit.couberia.bzh ([2.2.196.118]) by mwinf5d16 with ME id KjeN1j0052Zko4J03jeNDk; Fri, 08 Jun 2012 09:38:23 +0200 Original-Received: by micropit.couberia.bzh (Postfix, from userid 1000) id 1934E500799; Fri, 8 Jun 2012 09:38:22 +0200 (CEST) Mail-Followup-To: ConTeXt users User-Agent: Gnus/5.130006 (Ma Gnus v0.6) Emacs/24.1.50 (gnu/linux) X-Bayes-Prob: 0.0001 (Score 0, tokens from: @@RPTN) X-CanIt-Geo: ip=80.12.242.130; country=FR; latitude=46.0000; longitude=2.0000; http://maps.google.com/maps?q=46.0000,2.0000&z=6 X-CanItPRO-Stream: uu:ntg-context@ntg.nl (inherits from uu:default, base:default) X-Canit-Stats-ID: 03HjHCn2N - 8689ccab3c8f - 20120608 (trained as not-spam) X-Scanned-By: CanIt (www . roaringpenguin . com) on 192.87.102.71 X-BeenThere: ntg-context@ntg.nl X-Mailman-Version: 2.1.13 Precedence: list List-Id: mailing list for ConTeXt users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: ntg-context-bounces@ntg.nl Errors-To: ntg-context-bounces@ntg.nl Xref: news.gmane.org gmane.comp.tex.context:76791 Archived-At: Hi, It would be nice, if \getspr{} of the m-spreadsheet module could print a comma instead of a dot as decimal-point. For now, I use this workaround: --8<---------------cut here---------------start------------->8--- function spreadsheets.get(name,r,c,str) if name == "" then name = current if name == "" then name = "default" end end if not str or str == "" then context(data[name][c][r] or 0) else local result = execute(name,r,c,str) if result then if type(result) == "number" then data[name][c][r] = result end if userdata and userdata.spreadsheet_use_comma then result = tostring(result) result = result:gsub("%.", ",") end context(result) end end end --8<---------------cut here---------------end--------------->8--- -- Peter ___________________________________________________________________________________ If your question is of interest to others as well, please add an entry to the Wiki! maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context webpage : http://www.pragma-ade.nl / http://tex.aanhet.net archive : http://foundry.supelec.fr/projects/contextrev/ wiki : http://contextgarden.net ___________________________________________________________________________________