From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/113468 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: juh via ntg-context Newsgroups: gmane.comp.tex.context Subject: Re: Multiline cell in spreadsheettable Date: Thu, 18 Nov 2021 17:07:41 +0100 Message-ID: References: <783e8562-7665-0d96-d0d4-f9ccd3e6515f@xs4all.nl> Reply-To: mailing list for ConTeXt users Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============9106884847165101589==" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="24015"; mail-complaints-to="usenet@ciao.gmane.io" Cc: juh To: mailing list for ConTeXt users Original-X-From: ntg-context-bounces@ntg.nl Thu Nov 18 17:08:54 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 1mnjy1-0005yt-Lb for gctc-ntg-context-518@m.gmane-mx.org; Thu, 18 Nov 2021 17:08:53 +0100 Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id C6025289521; Thu, 18 Nov 2021 17:07:52 +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 PZDHJW_xATLX; Thu, 18 Nov 2021 17:07:50 +0100 (CET) Original-Received: from zapf.ntg.nl (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 5BF98289510; Thu, 18 Nov 2021 17:07:50 +0100 (CET) Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 4DBC428950E for ; Thu, 18 Nov 2021 17:07:49 +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 Hwb1IYJet2fC for ; Thu, 18 Nov 2021 17:07:48 +0100 (CET) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=80.241.56.171; helo=mout-p-201.mailbox.org; envelope-from=juh+ntg-context@mailbox.org; receiver= Original-Received: from mout-p-201.mailbox.org (mout-p-201.mailbox.org [80.241.56.171]) (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 F018E2824BB for ; Thu, 18 Nov 2021 17:07:47 +0100 (CET) Original-Received: from smtp102.mailbox.org (smtp102.mailbox.org [IPv6:2001:67c:2050:105:465:1:3: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-201.mailbox.org (Postfix) with ESMTPS id 4Hw4Sz3GsszQjhc for ; Thu, 18 Nov 2021 17:07:47 +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=1637251664; 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=u8WCb8KTA5fhXBVI/v5uf8BzIppdqW1kBdv2BaipMNY=; b=Upmh4x/wC2EQmJEYDZb1P38y5TKwzJoXtfmowBA2lRflcm9YZOusy7f2PBFVhOdAdhgBLW mbNjxk0ODYhSKFGaEugFOLSB+pecdpDlL6/06/vhekyht8GZe44WewYjl1W7t2VqU0rMJ3 Vb+TMDuggJNwKneifiUp2PT1R2lxPAImwt3M+4rDjB/dpTMSYaGfXUW7nPH11FiUCuNtWv hWdhsIZlq9z4ohg+AX1BtfAlvq/iYlP+H3JeyMHQXCSNYOK5ZmGiT3qZLo7KMGBimCYvfK 2DtAI6ns4N0HVi70qi2kIwQaLveFMuHC+1ehqprsm3Lk+KHzvdr+cgUKUBDDEA== Mail-Followup-To: juh , mailing list for ConTeXt users In-Reply-To: <783e8562-7665-0d96-d0d4-f9ccd3e6515f@xs4all.nl> 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:113468 Archived-At: --===============9106884847165101589== Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="yZiP/8viRf8Jp3C0" Content-Disposition: inline --yZiP/8viRf8Jp3C0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Am Thu, Nov 18, 2021 at 12:56:33PM +0100 schrieb Hans Hagen: > On 11/18/2021 10:29 AM, juh via ntg-context wrote: > > Hi all, > >=20 > > is there a parameter to have multiple lines in a cell in a spreadsheett= able? > see end of m-spreadsheet ... they are just natural tables I found this code on the wiki % mode=3Dmkiv \setuppapersize[A5] \bTABLE \setupTABLE[c][each][alignmentcharacter=3D{number->.},aligncharacter=3Dyes,= align=3Dmiddle] \bTABLEhead \bTR \bTH Same-Width Prefix \eTH \bTH Varying-Width Prefix \eTH \bTH Same-Width Suffix \eTH \bTH Varying-Width Suffix \eTH \eTR \eTABLEhead \bTABLEbody \bTR \bTD \$1.00 \eTD \bTD \$1.00 \eTD \bTD 1.00\% \eTD \bTD 1.00\% = \eTD \eTR \bTR \bTD \$10.00 \eTD \bTD \$\$10.00 \eTD \bTD 10.00\% \eTD \bTD 10.00\%\%= \eTD \eTR \bTR \bTD \$1.0 \eTD \bTD \$1.0 \eTD \bTD 1.0\% \eTD \bTD 1.0\% = \eTD \eTR \bTR \bTD \$10.0 \eTD \bTD \$\$10.0 \eTD \bTD 10.0\% \eTD \bTD 10.0\%\% = \eTD \eTR \eTABLEbody \eTABLE It sets the text of bTH like p{4cm} in LaTeX in several lines. But this does not work with my invoice code: \startspreadsheettable[test][frame=3Doff] \setupTABLE[c][each][alignmentcharacter=3D{number->.},aligncharacter=3Dyes,= align=3Dmiddle] \startrow[topframe=3Doff,bottomframe=3Don] \startcell[align=3Dflushleft] "Anz" \stopcell \startcell[align=3Dflushleft, width=3D9cm] "Beschreibung" \stopcell \startcell[align=3Dflushleft] "MwSt" \stopcell \startcell[align=3Dflushright] "Einzeln" \stopcell \startcell[align=3Dflushright] "Gesamt" \stopcell =20 \stoprow $for(positions)$ \startrow \startcell[align=3Dcenter] @ "0.2f h" $it.stunden$ \stopcell \startcell[align=3Dflushleft] "$it.name$" \stopcell %<-- this cell should be like p{4cm} \startcell[align=3Dflushright] @ "0.2f \percent" $it.mwst$ \stopcell \startcell[align=3Dflushright] @ "0.2f =E2=82=AC" $it.stundensatz$ \stopcell \startcell[align=3Dflushright] @ "0.2f =E2=82=AC" (A[row] * D[row]) \stopce= ll =20 \stoprow $endfor$ \startrow[topframe=3Don] \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft, style=3Dbold] "Gesamt netto" \stopcell \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushright, style=3Dbold] @ "0.2f =E2=82=AC" sum(E) \sto= pcell \stoprow \startrow[topframe=3Doff] \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft] "Mehrwertsteuer" \stopcell \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushright] @ "0.2f =E2=82=AC" 0.19 * E[row-1] \stopcell \stoprow \startrow[topframe=3Doff] \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft, style=3Dbold] "Gesamtsumme" \stopcell \startcell[align=3Dflushleft] " " \stopcell \startcell[align=3Dflushleft] " " \stopcell =20 \startcell[align=3Dflushright, style=3Dbold] @ "0.2f =E2=82=AC" E[row-1]+E[= row-2] \stopcell \stoprow \stopspreadsheettable The key between $ are variables which get filled by pandoc. --yZiP/8viRf8Jp3C0 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEE9pEda910q7j+RYbgOz1ziuYU0i0FAmGWekwACgkQOz1ziuYU 0i2ugQ/+KDtf6RZ5DmOptMe1Pn47eIHMZ7x3KdkRAjIFLfDgywcET2ydm69RtwC8 fisAuS5QJ0pHMbX50lrCtrJPEAjP9g1Qiv8mifXmBW/GAmeb7y0lnBFwDR/u6lnx +X3xWivct7rFb4kxfRdNlyz10r+G5VmDV5G+T+xuZnLV+NEYGuSn9J2CCFY2tV1y U5z4hoK+/C49uGFYRzafeiTVVlW3Pr+3uWDocJx6Qj+xrHvii/TaWKmVNVhTqlsU 3WFVcppODzi5ZL2YMIYjvh5N1T+qcj51S0XBkkPrE22vbuafHCuC1PS1fR+fHUfP /NK8z/Dp9sSMhmhePpPHOqmyCWRjtHajFWB+bPQDSwMKDghqF/0UB319DZHdN1IQ Xiqm+yz8NCooANXigSZLujT6urtYDh7FdriUG9Igq0oHldQvyakr5oSU+J7yvTFJ qIqxrAmGPE7FYhK1uMd7mXeRwmhmB+Nwq7sthE65Wb7AmQg2Hf3p9cUBTtnK0NdC zc+ElRjUTvNlcZvDPyEynhXzfqiAX6M8FFEdIsZ/x+0OQxzu94KEeWEpzyccdgPH awsUFVpzU8DXljHd2XlCxaGLZL0yPIf0c+hAJ2GdLBWNIWfoZJyPxZJ00CYAyOe+ 0UghCJ8y5pUQ+uFebgqfchsWyIj+YOSy3aWJ/ExK8lS2NGCKkpU= =opCx -----END PGP SIGNATURE----- --yZiP/8viRf8Jp3C0-- --===============9106884847165101589== 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== --===============9106884847165101589==--