Re: [NTG-context] spreadsheet product of two cells in current row
On 11/12/2021 4:56 PM, juh via ntg-context wrote:
Am Fri, Nov 12, 2021 at 02:42:13PM +0100 schrieb Hans Hagen:
educational tip:
\starttext
\startluacode
context("%M",1234567.89)
context.par()
context("%m",1234567.89)
\stopluacode
\stoptext
Nice, so I can use that instead:
\startcell[align=flushright] @ "0.2M €" 70 \stopcell
I was looking for the formatting strings, but could not find them. I
guess this is a lua thing? String formatting in lua?
a context thing (in cld manual)
-
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl
-
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
On 11/12/2021 5:15 PM, juh via ntg-context wrote:
Am Fri, Nov 12, 2021 at 04:56:51PM +0100 schrieb juh via ntg-context:
Am Fri, Nov 12, 2021 at 02:42:13PM +0100 schrieb Hans Hagen:
educational tip:
\starttext
\startluacode
context("%M",1234567.89)
context.par()
context("%m",1234567.89)
\stopluacode
\stoptext
Nice, so I can use that instead:
\startcell[align=flushright] @ "0.2M €" 70 \stopcell
Ok. This shot was too fast. I give up. ;-)
M or m depending on what you want to achieve
-
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl
-
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
Am Fri, Nov 12, 2021 at 04:56:51PM +0100 schrieb juh via ntg-context:
> Am Fri, Nov 12, 2021 at 02:42:13PM +0100 schrieb Hans Hagen:
> > educational tip:
> >
> > \starttext
> >
> > \startluacode
> > context("%M",1234567.89)
> > context.par()
> > context("%m",1234567.89)
> > \stopluacode
> >
> > \stoptext
>
> Nice, so I can use that instead:
>
> \startcell[align=flushright] @ "0.2M €" 70 \stopcell
>
Ok. This shot was too fast. I give up. ;-)
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
signature.asc
Description: PGP signature
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
Am Fri, Nov 12, 2021 at 02:42:13PM +0100 schrieb Hans Hagen:
> educational tip:
>
> \starttext
>
> \startluacode
> context("%M",1234567.89)
> context.par()
> context("%m",1234567.89)
> \stopluacode
>
> \stoptext
Nice, so I can use that instead:
\startcell[align=flushright] @ "0.2M €" 70 \stopcell
I was looking for the formatting strings, but could not find them. I
guess this is a lua thing? String formatting in lua?
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
signature.asc
Description: PGP signature
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
Am Fri, Nov 12, 2021 at 02:33:45PM +0100 schrieb Wolfgang Schuster:
> Not without a complete minimal example.
Sorry, of course.
\usemodule[spreadsheet]
\setupspreadsheet
[
period={,},
comma={.},
split=yes,
]
\startspreadsheettable[test][frame=off]
\startrow[topframe=on,bottomframe=on]
\startcell[align=flushleft] "Anz." \stopcell
\startcell[align=flushleft, width=9cm] "Beschreibung" \stopcell
\startcell[align=flushleft] "MwSt." \stopcell
\startcell[align=flushright] "Einzeln" \stopcell
\startcell[align=flushright] "Gesamt" \stopcell
\stoprow
\startrow
\startcell[align=center] 3 \stopcell
\startcell[align=flushleft] "Job 1, Job 2 und Job 3." \stopcell
\startcell[align=flushright] @ "0.2f \percent" 19 \stopcell
\startcell[align=flushright] @ "0.2f €" 70 \stopcell
\startcell[align=flushright] @ "0.2f €" (A[row] * D[row]) \stopcell
\stoprow
\stopspreadsheettable
\stoptext
Anz. MwSt.
And the comma separated enumeration under "Beschreibung".
TIA
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
signature.asc
Description: PGP signature
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
On 11/12/2021 2:27 PM, juh via ntg-context wrote:
Once again me,
I set this
\setupspreadsheet
[
period={,},
comma={.},
split=yes,
]
to get german numbers in my invoice like: 10.000,00 EUR.
educational tip:
\starttext
\startluacode
context("%M",1234567.89)
context.par()
context("%m",1234567.89)
\stopluacode
\stoptext
-
Hans Hagen | PRAGMA ADE
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: 038 477 53 69 | www.pragma-ade.nl | www.pragma-pod.nl
-
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
juh via ntg-context schrieb am 12.11.2021 um 14:27:
Once again me,
I set this
\setupspreadsheet
[
period={,},
comma={.},
split=yes,
]
to get german numbers in my invoice like: 10.000,00 EUR.
The drawback is that I can't use a normal period and comma in the normal
text.
Any hints?
Not without a complete minimal example.
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
Once again me,
I set this
\setupspreadsheet
[
period={,},
comma={.},
split=yes,
]
to get german numbers in my invoice like: 10.000,00 EUR.
The drawback is that I can't use a normal period and comma in the normal
text.
Any hints?
juh
signature.asc
Description: PGP signature
___
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
___
Re: [NTG-context] spreadsheet product of two cells in current row
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, > > > > 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? > 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=flushright] @ "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 -- Autoren-Homepage: . http://literatur.hasecke.com Satiren & Essays: . http://www.sudelbuch.de Privater Blog: http://www.hasecke.eu Netzliteratur-Projekt: http://www.generationenprojekt.de signature.asc Description: PGP signature ___ 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 ___
Re: [NTG-context] spreadsheet product of two cells in current row
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
___
[NTG-context] spreadsheet product of two cells in current row
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 signature.asc Description: PGP signature ___ 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 ___
