Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Michael Brand
On Tue, Sep 16, 2014 at 1:56 PM, Michael Brand wrote: > the currently newest released Emacs 23.3. This was (hopefully obviously) a typo and should have been the currently newest released Emacs 24.3. Michael

Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Michael Brand
Hi Uwe On Tue, Sep 16, 2014 at 1:02 PM, Uwe Brauer wrote: > this is patch is from 2012, which orgmode version did it enter then? I implemented it in release_7.9.2-908-ga77442b and "git tag --contains" tells that it is available since Org release 8.0 which is newer than the pre-packaged Org mode

Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Uwe Brauer
> Uwe Brauer writes: > I think something like NaN was introduced to Org-tbls, but I don't > remember the exact syntax, maybe try with 'nan': > Http://lists.gnu.org/archive/html/emacs-orgmode/2012-12/msg00983.html Aha, so I would indeed get: | Name | Ex 1 | Ex2 | Ex + Ex2 | | smi

Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Nicolas Richard
Michael Brand writes: > On Tue, Sep 16, 2014 at 11:42 AM, Thorsten Jolitz wrote: >> I think something like NaN was introduced to Org-tbls, but I don't >> remember the exact syntax, maybe try with 'nan': >> >> http://lists.gnu.org/archive/html/emacs-orgmode/2012-12/msg00983.html > > Yes, and I al

Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Michael Brand
On Tue, Sep 16, 2014 at 11:42 AM, Thorsten Jolitz wrote: > I think something like NaN was introduced to Org-tbls, but I don't > remember the exact syntax, maybe try with 'nan': > > http://lists.gnu.org/archive/html/emacs-orgmode/2012-12/msg00983.html Yes, and I already documented the OP use case

Re: [O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Thorsten Jolitz
Uwe Brauer writes: > Hello > > Consider the following table. > > > | Name | Ex 1 | Ex2 | Ex + Ex2 | > | smith |1 | 2 |3 | > | miller | | |0 | > #+TBLFM: $4=$2+$3 > > > Miller has no entries in Ex1 and Ex2 but when using C-u C-u C-c C-c also > Ex2+Ex3 gets an entr

[O] spreadsheet: empty field should be an empty field.

2014-09-16 Thread Uwe Brauer
Hello Consider the following table. | Name | Ex 1 | Ex2 | Ex + Ex2 | | smith |1 | 2 |3 | | miller | | |0 | #+TBLFM: $4=$2+$3 Miller has no entries in Ex1 and Ex2 but when using C-u C-u C-c C-c also Ex2+Ex3 gets an entry namely zero. I don't like this I would