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
signature.asc
Description: PGP signature
___________________________________________________________________________________ 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 ___________________________________________________________________________________
