From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/113369 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: juh via ntg-context Newsgroups: gmane.comp.tex.context Subject: spreadsheet product of two cells in current row Date: Fri, 12 Nov 2021 12:20:25 +0100 Message-ID: Reply-To: mailing list for ConTeXt users Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2579770556947868340==" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="15103"; 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 12:21: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 1mlUcI-0003lg-NU for gctc-ntg-context-518@m.gmane-mx.org; Fri, 12 Nov 2021 12:21:10 +0100 Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id C55B52891F9; Fri, 12 Nov 2021 12:20:42 +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 IFl4Z97YgiGE; Fri, 12 Nov 2021 12:20:40 +0100 (CET) Original-Received: from zapf.ntg.nl (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 924222891EE; Fri, 12 Nov 2021 12:20:40 +0100 (CET) Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 14A072891EE for ; Fri, 12 Nov 2021 12:20:38 +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 oKEOUSgyjZYr for ; Fri, 12 Nov 2021 12:20:36 +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 850032891AB for ; Fri, 12 Nov 2021 12:20:36 +0100 (CET) Original-Received: from smtp202.mailbox.org (smtp202.mailbox.org [IPv6:2001:67c:2050:105:465:1:4:0]) (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 4HrGNM5dfnzQlL9 for ; Fri, 12 Nov 2021 12:20:35 +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=1636716033; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type; bh=52lXb8M8fa41kBgK8+2QlXk3ntJa7tL7i4XNMcaGGRU=; b=FQvZZsTPJQtlhHD5hAblh9xEPpsnpXgf4GO0oVNePlGmeFoGnacht+MnXYZb5mGoHWSyrt wetGMZSMtNegHMBegif5RmnuimxvU5+thmfzF6kHdCh09wKmf2/f220NGlGYb+MNVXpirs sKVNNNgqJzEAwk1Zs2ehoFoZ0/dwHpDIgCGlF7rYlxvCb8BR9JrC7GX603ag7iVJIyPrTl c9ntSvw9SZUKzcH9fRChyR7idFvo1LVaT5gEqja9otpQbi0TZr0DKVSVBjilaAI/JFMyd6 2931Hp85kAQCA69rDvCiiNtLMeQyBkXk7T0UizMDN3hSfRBKXsp+aMpuB4PzYA== Mail-Followup-To: juh , mailing list for ConTeXt users 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:113369 Archived-At: --===============2579770556947868340== Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tXao8/NEQxLM3lN+" Content-Disposition: inline --tXao8/NEQxLM3lN+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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*.=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 The rows come from a script and there might be several items. Any hints? =20 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 --tXao8/NEQxLM3lN+ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEE9pEda910q7j+RYbgOz1ziuYU0i0FAmGOTfkACgkQOz1ziuYU 0i0FDRAAm2LcdgOVAiISv0BnPBAEInwGlMK5bEIeLQ4vn9Va/01iJ3GMD2YQdWcY eGXiaRb4yROx/dVopV92+1a7Pk4ERTWZ5mIL20hxjxXSEiy75SKqRNXRON6qXucb JNomGgqn/33Rfv3+Q5V/kd/T5vRAvpL2jfhbvS9ZLd4JQo3cmTWyVIjRYl1D1Lgm Q6DUT99cEKVdMXCeQ6hFsKgLDi08lgtuBETlWgFGN8TTu0smDMSdBRruEkAvOzgF oChOmaHyMXOGzhGPP1AWCjN4aZoYZzfq7wlN+YkoEf8oE4+PmYyTUMYrSBaRg9m5 /vzpt0A1yyc/zf9LnkS6clYbVZmOzB5mV7KVsHo7PqgGl36/PCzMDZw4FaxSY2dj 4t/isUQnOmGfJKGPAjOeNNvUHO/JVnJDN+SB+GR7kp3TyXUaI+/O3IcE++jQL0tv VIBAvVfF5NFnsrZgTY+Mcs3qbAFqV4mvzTvq3KsYU17nu7sXPB4ITqJkZAWmo8KD yMxWkspj2WmWUF3xNeu+fmcp92obXCe55G6DKOmNF/J9wxh+vfDluD7x0adQ9h6A Fz1/PQlry8dPrqWzRwQ8ZoK94WEiTVo2H7WFRgEseHpYM96KG+rZt64CQtO1BnJW DrvPdzzoNyDXGXIkw964fKsABURXduwYZulh9iL4O5LdO8tq6o8= =4/ud -----END PGP SIGNATURE----- --tXao8/NEQxLM3lN+-- --===============2579770556947868340== 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== --===============2579770556947868340==--