[NTG-context] Re: max function in spreadsheettable

[Henning Hraban Ramm <texml@fiee.net>]

Am 15.10.24 um 10:59 schrieb juh+ntg-context--- via ntg-context:
> Dear all,
> 
> I have a cell that calculates a value that may not be a negative value. 
> If it is a negatiive value the cell should show zero.
> 
> 
> \startcell[style=normal]
> @ "0.2f EUR" $pauschale.eintag$ - ((D[row] * (0.2  * 
> $pauschale.vororttag$)) + (E[row] * (0.4  * $pauschale.vororttag$)) + 
> (F[row] * (0.4  * $pauschale.vororttag$)))
> \stopcell
> 
> The $-variables will get resolved by Pandoc before ConTeXt comes into play.
> 
> As far as I understood the handdbook spreadsheets-mkiv.pdf it is 
> possible to define lua functions inside a cell.
> 
> Who would you implement a max function that sets the value to 0 if it is 
> negative?

I’d advise against using the spreadsheet module and for CLD, i.e. 
creating the table from the Lua end. How that works from Markdown 
metadata (that I know you’re using) I’m not sure. It might make sense to 
avoid the Pandoc step and read Markdown or whatever input format with Lua.

WRT German: if you setup a decimal comma with the spreadsheet module, 
all dots get replaced by commas, e.g. in abbreviations – one reason to 
avoid that module.

Otherwise it should be possible to define that function in Lua and use 
it in the table.

I guess you know the cld-mkiv manual?

Hraban
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / https://mailman.ntg.nl/mailman3/lists/ntg-context.ntg.nl
webpage  : https://www.pragma-ade.nl / https://context.aanhet.net (mirror)
archive  : https://github.com/contextgarden/context
wiki     : https://wiki.contextgarden.net
___________________________________________________________________________________