feature request for \getspr{}
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
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 -----------------------------------------------------------------
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
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 -----------------------------------------------------------------
participants (2)
-
Hans Hagen -
Peter Münster