* feature request for \getspr{}
@ 2012-06-08 7:38 Peter Münster
2012-06-08 8:02 ` Hans Hagen
0 siblings, 1 reply; 5+ messages in thread
From: Peter Münster @ 2012-06-08 7:38 UTC (permalink / raw)
To: ConTeXt users
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
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: feature request for \getspr{}
2012-06-08 7:38 feature request for \getspr{} Peter Münster
@ 2012-06-08 8:02 ` Hans Hagen
2012-06-08 10:21 ` Peter Münster
0 siblings, 1 reply; 5+ messages in thread
From: Hans Hagen @ 2012-06-08 8:02 UTC (permalink / raw)
To: ConTeXt users
On 8-6-2012 09:38, Peter Münster wrote:
> 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---
I've added moduledata.spreadsheets.settings.numberseparator but you have
to test it after the next upload.
(Typpically oen of those modules that I'd forgotten about.)
Hans
-----------------------------------------------------------------
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | voip: 087 875 68 74 | www.pragma-ade.com
| www.pragma-pod.nl
-----------------------------------------------------------------
___________________________________________________________________________________
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
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: feature request for \getspr{}
2012-06-08 8:02 ` Hans Hagen
@ 2012-06-08 10:21 ` Peter Münster
2012-06-08 19:58 ` Hans Hagen
0 siblings, 1 reply; 5+ messages in thread
From: Peter Münster @ 2012-06-08 10:21 UTC (permalink / raw)
To: mailing list for ConTeXt users
On Fri, Jun 08 2012, Hans Hagen wrote:
> I've added moduledata.spreadsheets.settings.numberseparator but you have to
> test it after the next upload.
Tested. Thanks!
Just a minor comment: \setupspreadsheet[numberseparator=,] would be
nicer than
\ctxlua{moduledata.spreadsheets.settings.numberseparator = ","}
--
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
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: feature request for \getspr{}
2012-06-08 10:21 ` Peter Münster
@ 2012-06-08 19:58 ` Hans Hagen
2012-06-09 8:16 ` Peter Münster
0 siblings, 1 reply; 5+ messages in thread
From: Hans Hagen @ 2012-06-08 19:58 UTC (permalink / raw)
To: mailing list for ConTeXt users
On 8-6-2012 12:21, Peter Münster wrote:
> On Fri, Jun 08 2012, Hans Hagen wrote:
>
>> I've added moduledata.spreadsheets.settings.numberseparator but you have to
>> test it after the next upload.
>
> Tested. Thanks!
>
> Just a minor comment: \setupspreadsheet[numberseparator=,] would be
> nicer than
> \ctxlua{moduledata.spreadsheets.settings.numberseparator = ","}
next beta
\setupspreadsheet
[test]
[period={{\bf\middlered .}},
comma={{\bf\middlegreen ,}},
split=yes]
\startspreadsheettable[test]
\startrow
\startcell 123456.78 \stopcell
\startcell 1234567.89 \stopcell
\startcell A[1] + B[1] \stopcell
\stoprow
\stopspreadsheettable
-----------------------------------------------------------------
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | voip: 087 875 68 74 | www.pragma-ade.com
| www.pragma-pod.nl
-----------------------------------------------------------------
___________________________________________________________________________________
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
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: feature request for \getspr{}
2012-06-08 19:58 ` Hans Hagen
@ 2012-06-09 8:16 ` Peter Münster
0 siblings, 0 replies; 5+ messages in thread
From: Peter Münster @ 2012-06-09 8:16 UTC (permalink / raw)
To: mailing list for ConTeXt users
On Fri, Jun 08 2012, Hans Hagen wrote:
> \setupspreadsheet
> [test]
> [period={{\bf\middlered .}},
> comma={{\bf\middlegreen ,}},
> split=yes]
Thanks, that's fine!
Just a minor fix in line 183: if split == "yes" then
--
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
___________________________________________________________________________________
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2012-06-09 8:16 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2012-06-08 7:38 feature request for \getspr{} Peter Münster
2012-06-08 8:02 ` Hans Hagen
2012-06-08 10:21 ` Peter Münster
2012-06-08 19:58 ` Hans Hagen
2012-06-09 8:16 ` Peter Münster
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).