Re: spreadsheet product of two cells in current row

[juh via ntg-context <ntg-context@ntg.nl>]

[-- Attachment #1.1: Type: text/plain, Size: 1480 bytes --]

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



[-- Attachment #1.2: signature.asc --]
[-- Type: application/pgp-signature, Size: 833 bytes --]

[-- Attachment #2: Type: text/plain, Size: 493 bytes --]

___________________________________________________________________________________
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
___________________________________________________________________________________