From: Wolfgang Schuster via ntg-context <ntg-context@ntg.nl>
To: juh <juh+ntg-context@mailbox.org>,
mailing list for ConTeXt users <ntg-context@ntg.nl>
Cc: Wolfgang Schuster <wolfgang.schuster.lists@gmail.com>
Subject: Re: spreadsheet product of two cells in current row
Date: Fri, 12 Nov 2021 12:55:59 +0100 [thread overview]
Message-ID: <e00e2e28-8599-a384-b9d5-3f13c977d8a5@gmail.com> (raw)
In-Reply-To: <YY5N+W+dW2YtDh2y@sokrates>
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
___________________________________________________________________________________
next prev parent reply other threads:[~2021-11-12 11:55 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
2021-11-12 11:20 juh via ntg-context
2021-11-12 11:55 ` Wolfgang Schuster via ntg-context [this message]
2021-11-12 12:47 ` juh via ntg-context
2021-11-12 13:27 ` juh via ntg-context
2021-11-12 13:33 ` Wolfgang Schuster via ntg-context
2021-11-12 15:51 ` juh via ntg-context
2021-11-12 13:42 ` Hans Hagen via ntg-context
2021-11-12 15:56 ` juh via ntg-context
2021-11-12 16:15 ` juh via ntg-context
2021-11-12 17:06 ` Hans Hagen via ntg-context
2021-11-12 17:06 ` Hans Hagen via ntg-context
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=e00e2e28-8599-a384-b9d5-3f13c977d8a5@gmail.com \
--to=ntg-context@ntg.nl \
--cc=juh+ntg-context@mailbox.org \
--cc=wolfgang.schuster.lists@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).