Thank you Wolfgang for your reply. I was lucky in the meantime. Am Fri, Nov 12, 2021 at 12:55:59PM +0100 schrieb Wolfgang Schuster:
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?
I found "row" so: \startcell @ "0.2f EUR" (A[row] * D[row]) \stopcell gives the product of cell A and D in the current row. And I even found row-n \startcell @ "0.2f EUR" 0.19 * E[row-1] \stopcell gives the VAT of cell E in the row before. and: \startcell[align=flushright] @ "0.2f EUR" E[row-1]+E[row-2] \stopcell add the numbers of cell E in the two rows before. It works, but is there a better approach? juh -- Autoren-Homepage: ......... http://literatur.hasecke.com Satiren & Essays: ......... http://www.sudelbuch.de Privater Blog: ............ http://www.hasecke.eu Netzliteratur-Projekt: .... http://www.generationenprojekt.de