From: juh via ntg-context <ntg-context@ntg.nl>
To: mailing list for ConTeXt users <ntg-context@ntg.nl>
Cc: juh <juh+ntg-context@mailbox.org>
Subject: spreadsheet product of two cells in current row
Date: Fri, 12 Nov 2021 12:20:25 +0100 [thread overview]
Message-ID: <YY5N+W+dW2YtDh2y@sokrates> (raw)
[-- Attachment #1.1: Type: text/plain, Size: 770 bytes --]
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?
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
___________________________________________________________________________________
next reply other threads:[~2021-11-12 11:20 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
2021-11-12 11:20 juh via ntg-context [this message]
2021-11-12 11:55 ` Wolfgang Schuster via ntg-context
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=YY5N+W+dW2YtDh2y@sokrates \
--to=ntg-context@ntg.nl \
--cc=juh+ntg-context@mailbox.org \
/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).