juh via ntg-context schrieb am 12.11.2021 um 12:20:
Dear all,
I thought I could find my way through the spreadsheet documentation to
make my invoices.
While it is simple to calculate the sum or the product of two cells if
you know that they are A[2] and B[2] I can't find the solution to access
cell A and B *on the same row*.
Amount | Single | Sum
2 | 5 | 10 <-- A[currentrow] * B[currentrow] does not work
3 | 4 | 12
====================
Sum 22
The rows come from a script and there might be several items.
Any hints?
Do you have a example because I have no problem to access values in the
current row.
\usemodule[spreadsheet]
\starttext
\bTABLE
\bTR
\bTD Amount \eTD
\bTD Single \eTD
\bTD Sum \eTD
\eTR
\bTR
\bTD \getspr{2} \eTD
\bTD \getspr{5} \eTD
\bTD \getspr{A[2] * B[2]} \eTD
\eTR
\bTR
\bTD \getspr{3} \eTD
\bTD \getspr{4} \eTD
\bTD \getspr{A[3] * B[3]} \eTD
\eTR
\eTABLE
\startspreadsheettable
\startrow
\startcell "Amount" \stopcell
\startcell "Single" \stopcell
\startcell "Sum" \stopcell
\stoprow
\startrow
\startcell 2 \stopcell
\startcell 5 \stopcell
\startcell A[2] * B[2] \stopcell
\stoprow
\startrow
\startcell 3 \stopcell
\startcell 4 \stopcell
\startcell A[3] * B[3] \stopcell
\stoprow
\stopspreadsheettable
\stoptext
Wolfgang
___________________________________________________________________________________
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://context.aanhet.net
archive : https://bitbucket.org/phg/context-mirror/commits/
wiki : http://contextgarden.net
___________________________________________________________________________________