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