Re: [O] Re: org-table formulas with missing values

2011-03-08 Thread Thorsten
suvayu ali writes: > Since recently calc code block support was added to babel, why not use > that to process your table instead of table formulae? Wouldn't you > expect it would be easier to deal with NaN and its likes directly with > calc source compared to formulae? I'm going to try that. I j

Re: [O] Re: org-table formulas with missing values

2011-03-06 Thread suvayu ali
Hi Thorsten, Disclaimer: I haven't tried any of what I am proposing below. Its just a thought that came to me while reading your post. On Sun, Mar 6, 2011 at 2:44 PM, Thorsten wrote: > But even if nil would work, my basic question remains: if I have for > example a dynamic report were one code-b

Re: [O] Re: org-table formulas with missing values

2011-03-06 Thread Thorsten
Rainer M Krug writes: > On Sat, Mar 5, 2011 at 11:55 AM, Thorsten > wrote: >> Bastien writes: >> >>> Hi Thorsten, >>> >>> Thorsten writes: >>> Ok, trial and error suggests that missing values in numeric columns can be represented as 0 in formulas, in string columns as "". Is there >>

Re: [O] Re: org-table formulas with missing values

2011-03-05 Thread Rainer M Krug
On Sat, Mar 5, 2011 at 11:55 AM, Thorsten wrote: > Bastien writes: > >> Hi Thorsten, >> >> Thorsten writes: >> >>> Ok, trial and error suggests that missing values in numeric columns can >>> be represented as 0 in formulas, in string columns as "". Is there >>> something like NaN in calc/org-tab

[O] Re: org-table formulas with missing values

2011-03-05 Thread Thorsten
Bastien writes: > Hi Thorsten, > > Thorsten writes: > >> Ok, trial and error suggests that missing values in numeric columns can >> be represented as 0 in formulas, in string columns as "". Is there >> something like NaN in calc/org-table? > > I don't know what is NaN. Can you give an example