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