Re: empty/nil in table cells

2020-07-10 Thread Mario Frasca
On 09/07/2020 16:59, Nicolas Goaziou wrote: and it simplifies a lot writing functions. How so? thank you Michael, for answering Nicolas' question, in a different and much structured way than I did in my original message. the formula you provided —I reduced it slightly, hard coding a

Re: empty/nil in table cells

2020-07-10 Thread Nicolas Goaziou
Hello, Mario Frasca writes: > I think we really need a bug-tracking mechanism, you know? H... I had read about the message you've sent again. However, even if we don't have a bug-tracking mechanism, you can still group messages related to the same issue in the same thread. It would be

Re: empty/nil in table cells

2020-07-10 Thread Michael Brand
Hi Mario For such cases I use ~subseq~ to take the running window out of the complete range ~@I$2..@II$2~: | date | measure | running avg | |---+-+-| | 01-27 | 604 | | | 01-28 | 314 | | | 01-29 | 636 | | | 01-30 | 305 |

Re: empty/nil in table cells

2020-07-09 Thread Mario Frasca
I think we really need a bug-tracking mechanism, you know? see attachment On 09/07/2020 16:59, Nicolas Goaziou wrote: Hello, Mario Frasca writes: I've been experimenting with associating the empty cell with the value nil, Where? both ways, What do you mean? and it simplifies a lot

Re: empty/nil in table cells

2020-07-09 Thread Nicolas Goaziou
Hello, Mario Frasca writes: > I've been experimenting with associating the empty cell with the value > nil, Where? > both ways, What do you mean? > and it simplifies a lot writing functions. How so? > also, I've removed the error generation when reading from outside the > table (instead

empty/nil in table cells

2020-07-09 Thread Mario Frasca
Hi people, I've been experimenting with associating the empty cell with the value nil, both ways, and it simplifies a lot writing functions. also, I've removed the error generation when reading from outside the table (instead of giving up with a user-error, I now get a nil). it works for