From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/113371 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: juh via ntg-context Newsgroups: gmane.comp.tex.context Subject: Re: spreadsheet product of two cells in current row Date: Fri, 12 Nov 2021 13:47:26 +0100 Message-ID: References: Reply-To: mailing list for ConTeXt users Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5589575218957354709==" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="2327"; mail-complaints-to="usenet@ciao.gmane.io" Cc: juh To: mailing list for ConTeXt users Original-X-From: ntg-context-bounces@ntg.nl Fri Nov 12 13:48:10 2021 Return-path: Envelope-to: gctc-ntg-context-518@m.gmane-mx.org Original-Received: from zapf.boekplan.nl ([5.39.185.232] helo=zapf.ntg.nl) by ciao.gmane.io with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mlVyU-0000Sl-JT for gctc-ntg-context-518@m.gmane-mx.org; Fri, 12 Nov 2021 13:48:10 +0100 Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 90AEA289217; Fri, 12 Nov 2021 13:47:39 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at zapf.boekplan.nl Original-Received: from zapf.ntg.nl ([127.0.0.1]) by localhost (zapf.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id w-Xa6lYTyD92; Fri, 12 Nov 2021 13:47:37 +0100 (CET) Original-Received: from zapf.ntg.nl (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id A61AA289214; Fri, 12 Nov 2021 13:47:37 +0100 (CET) Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id E3C4B289212 for ; Fri, 12 Nov 2021 13:47:35 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at zapf.boekplan.nl Original-Received: from zapf.ntg.nl ([127.0.0.1]) by localhost (zapf.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZLUMd0Vn_PhU for ; Fri, 12 Nov 2021 13:47:34 +0100 (CET) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=80.241.56.152; helo=mout-p-102.mailbox.org; envelope-from=juh+ntg-context@mailbox.org; receiver= Original-Received: from mout-p-102.mailbox.org (mout-p-102.mailbox.org [80.241.56.152]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) (No client certificate requested) by zapf.ntg.nl (Postfix) with ESMTPS id 92593289207 for ; Fri, 12 Nov 2021 13:47:34 +0100 (CET) Original-Received: from smtp1.mailbox.org (smtp1.mailbox.org [80.241.60.240]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-p-102.mailbox.org (Postfix) with ESMTPS id 4HrJJj51yczQk1P for ; Fri, 12 Nov 2021 13:47:33 +0100 (CET) X-Virus-Scanned: amavisd-new at heinlein-support.de DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812; t=1636721251; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=hcE/ncn0vj7RV9VBDyH+vnZXF/AHvFWt/UB+TxixVe0=; b=TFA63t9ZzszJQ524VQ+N3CUd7VJkVuaHW/73zDFF/mpyVsf852U164uMoesndrgYmKSfjz GKi9kqbUQVW/iscwUpAQUVLwHjTt9KbvBtjyS9coEiGHAUEkUiEcgm11FrQh5qw8VYxKeA DkxSr7tUDhVZ08AnUjXVuUUi6CpTk3FbpJu82wkcfZVlntaf0DGIWDLddTM6SOHWvSe9SG oM2cMtYm+INeIm1ZcNpYyCLxmwjE1YLwI0UMOYBn4unFADyzUOipjXJUKN86JeAigM4kJL 5wy+GvaUDb5YZl5xRVKtiE0f4ebAIv0jxHEC2L15fUHqw0z7fznYTbMz62ephw== Mail-Followup-To: juh , mailing list for ConTeXt users In-Reply-To: X-BeenThere: ntg-context@ntg.nl X-Mailman-Version: 2.1.26 Precedence: list List-Id: mailing list for ConTeXt users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: ntg-context-bounces@ntg.nl Original-Sender: "ntg-context" Xref: news.gmane.io gmane.comp.tex.context:113371 Archived-At: --===============5589575218957354709== Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="URQu5LuX174y9beq" Content-Disposition: inline --URQu5LuX174y9beq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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, > >=20 > > I thought I could find my way through the spreadsheet documentation to > > make my invoices. > >=20 > > 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*. > >=20 > > Amount | Single | Sum > > 2 | 5 | 10 <-- A[currentrow] * B[currentrow] does not work > > 3 | 4 | 12 > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > Sum 22 > >=20 > > The rows come from a script and there might be several items. > >=20 > > Any hints? >=20 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=3Dflushright] @ "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 --=20 Autoren-Homepage: ......... http://literatur.hasecke.com Satiren & Essays: ......... http://www.sudelbuch.de Privater Blog: ............ http://www.hasecke.eu Netzliteratur-Projekt: .... http://www.generationenprojekt.de --URQu5LuX174y9beq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEE9pEda910q7j+RYbgOz1ziuYU0i0FAmGOYlkACgkQOz1ziuYU 0i2Z6RAAqx1MLlPfvdTVoDkp/mzoHd+C5K5cVsNrfNx970QuSgEfQrxlLmRfq0jY 06x+zteeZ3jgvJhwax1JjAIxfpRdtU5Z0F6UO+nLBAJu4ed2pL9SWU0isnGWEogq uQQE1oHR3SZzvy6eTysC1rtM9QhKG5a+7cBnt69h3uwoEcZ3/sRIgG28FDzeRVCN BxzcBK6s5fvH54QgMbDv89+xiUpA0CjosrykKGrwO0HN+pbIcreuMD3mkxWXBL81 VWqL4sVcMZQ6u/nWZBzlBZtC1hWkLXEcxXINAS2KMu3smATuC1FVqW2YK8++87Ul r+WgGVY0AmFkMyYxFnEeRBAQZe+GHmP25+ECL3KZK7FFi3tzvQGgdE0EjBdhybEJ YHjJ00nra3jDQgmo/0k4MPEHODtdFDiD0Che3WmPOgX0aU9A6Fya6gCRm31y5xA8 i1kN6hLYngGZkLHGe1JHgA2+QKCOo29EG9xSPQ4uIC4knJOyH6wrXHU9/kwlmWOU p7Rs4lYaBPDxZ2+sdZ/60bYnaikHCnrFn04ipT4iT5pWZ8kQ9QfbSoq9XNsO8RvV 5ewDY8H8Uzx92dp6Lm7N7wljXtPXunmvek8NdteTBnILJxPXEYSUO3n+J1xNKdwn RsrUObPsAkmWAq2JNsUSQazgg/wo40aTBwU/iSXO2q5McDdk/5E= =2hkQ -----END PGP SIGNATURE----- --URQu5LuX174y9beq-- --===============5589575218957354709== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX18KSWYgeW91ciBxdWVzdGlvbiBpcyBvZiBpbnRlcmVz dCB0byBvdGhlcnMgYXMgd2VsbCwgcGxlYXNlIGFkZCBhbiBlbnRyeSB0byB0aGUgV2lraSEKCm1h aWxsaXN0IDogbnRnLWNvbnRleHRAbnRnLm5sIC8gaHR0cDovL3d3dy5udGcubmwvbWFpbG1hbi9s aXN0aW5mby9udGctY29udGV4dAp3ZWJwYWdlICA6IGh0dHA6Ly93d3cucHJhZ21hLWFkZS5ubCAv IGh0dHA6Ly9jb250ZXh0LmFhbmhldC5uZXQKYXJjaGl2ZSAgOiBodHRwczovL2JpdGJ1Y2tldC5v cmcvcGhnL2NvbnRleHQtbWlycm9yL2NvbW1pdHMvCndpa2kgICAgIDogaHR0cDovL2NvbnRleHRn YXJkZW4ubmV0Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCg== --===============5589575218957354709==--