[O] table spreadsheet problem

2012-03-19 Thread Martin Halder
Hi all, question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with @II+2. Would like to calculate sum = vsum(@I..@II) and tax = sum * 0.08 Am I doing sth wrong ? Thanks for help, Martin | article | price | |-+|

Re: [O] table spreadsheet problem

2012-03-19 Thread Russell Adams
On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote: Hi all, question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with @II+2. Would like to calculate sum = vsum(@I..@II) and tax = sum * 0.08 Am I doing sth wrong ?

Re: [O] table spreadsheet problem

2012-03-19 Thread Martin Halder
Am 19.03.2012 um 16:32 schrieb Russell Adams: On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote: Hi all, question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with @II+2. Would like to calculate sum =

Re: [O] table spreadsheet problem

2012-03-19 Thread Russell Adams
On Mon, Mar 19, 2012 at 04:45:14PM +0100, Martin Halder wrote: Am 19.03.2012 um 16:32 schrieb Russell Adams: | article | price | |-+| | item1 | 100.00 | | item2 | 200.00 | |-+| | sum | 300.00 | | tax | 24.00 | |-+| |

Re: [O] table spreadsheet problem

2012-03-19 Thread Nick Dokos
Russell Adams rlad...@adamsinfoserv.com wrote: On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote: Hi all, question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with @II+2. Would like to calculate sum =

Re: [O] table spreadsheet problem

2012-03-19 Thread Russell Adams
Nowadays, you can use (both on the LHS and the RHS of the formula) symbolic references relative to the first, second, third ... row like this: @, @, @ ... and relative to the last, penultimate, antepenultimate (is there such a word?) row like this: @, @, @ ..., and similarly for columns, so

Re: [O] table spreadsheet problem

2012-03-19 Thread Martin Halder
Am 19.03.2012 um 16:56 schrieb Nick Dokos: Russell Adams rlad...@adamsinfoserv.com wrote: On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote: Hi all, question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with

Re: [O] table spreadsheet problem

2012-03-19 Thread Nick Dokos
Russell Adams rlad...@adamsinfoserv.com wrote: Nowadays, you can use (both on the LHS and the RHS of the formula) symbolic references relative to the first, second, third ... row like this: @, @, @ ... and relative to the last, penultimate, antepenultimate (is there such a word?) row like

Re: [O] table spreadsheet problem

2012-03-19 Thread Russell Adams
On Mon, Mar 19, 2012 at 01:42:50PM -0400, Nick Dokos wrote: It was introduced about a year ago, so it should be in 7.7 or later (possibly some earlier releases as well but I haven't checked in detail.) If you git, then the relevant commits are 5631a309ab567e0a6a059ce728f84c1637fd253f

Re: [O] table spreadsheet problem

2012-03-19 Thread Nick Dokos
Russell Adams rlad...@adamsinfoserv.com wrote: On Mon, Mar 19, 2012 at 01:42:50PM -0400, Nick Dokos wrote: It was introduced about a year ago, so it should be in 7.7 or later (possibly some earlier releases as well but I haven't checked in detail.) If you git, then the relevant commits

Re: [O] table spreadsheet problem

2012-03-19 Thread Russell Adams
On Mon, Mar 19, 2012 at 02:01:02PM -0400, Nick Dokos wrote: Be careful - you might run into problems (I don't know if you've seen Bastien's and Achim's emails about the git problems). It might be safer to wait a bit until the dust settles and Bastien gives the green light. Just out of