ntg-context - mailing list for ConTeXt users
 help / color / mirror / Atom feed
* 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).