Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread Hans Hagen via ntg-context
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:

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread Hans Hagen via ntg-context
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()

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread juh via ntg-context
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) > >

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread 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

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread juh via ntg-context
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]

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread Hans Hagen via ntg-context
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)

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread Wolfgang Schuster via ntg-context
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.

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread juh via ntg-context
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

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread juh via ntg-context
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

Re: [NTG-context] spreadsheet product of two cells in current row

2021-11-12 Thread Wolfgang Schuster via ntg-context
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