Hi Michael,
this is just great! Thanks a lot for this major enhancement,
and for your details explanations and tests.
Michael Brand michael.ch.br...@gmail.com writes:
Patch 6 of the attached patches makes it possible to write
spreadsheet Calc formulas that check for empty fields: To sum the
Hi all
On Tue, Dec 11, 2012 at 4:14 PM, Michael Brand
michael.ch.br...@gmail.com wrote:
I would also like if some interest could be spent in this (see subject)
area.
Ok, so I thought to try myself this time. Now it looks as I am on a
good way with a solution. With quite some ERT for this and
Hi Michael,
Michael Brand michael.ch.br...@gmail.com writes:
Ok, so I thought to try myself this time. Now it looks as I am on a
good way with a solution. With quite some ERT for this and some more
of basic formulas.
Thanks for working on this, if there is a clean solution, I'm willing
to
Hi all
I would also like if some interest could be spent in this (see subject)
area. Let me give some examples as an overview, grouped as “check if
empty”, “range” and “single fields”. The first is the only one
directly related to the OP question. But the others still match the
subject perfectly.
Can't find out about this anywhere. My apologies if I missed something
simple or something already posted.
I want a calculation to appear in column 9 if and only if column 2 is
non-blank. If there is an explicit 0 in column 2, I want the calculation to
appear in column 9. But if column 2 is
Bob Newell bobnew...@bobnewell.net writes:
The problem obviously revolves around a blank cell being interpreted
as zero. That's all well and good, and quite correct, but makes
distinguishing blank and explicit zero more difficult.
I don't think thats well and good, and quite correct,
I'm making it work, and using L rather than S turns out to be better, as in
this revision of my example above:
$9 = '(if (eq $2 ) (* @2$8 $1));L
But when I want different actions when there is an explicit number (including
0)
vs. a blank cell, and if my action is at all complex, I end up
Bob Newell bobnew...@bobnewell.net wrote:
I'm making it work, and using L rather than S turns out to be better, as
in
this revision of my example above:
$9 = '(if (eq $2 ) (* @2$8 $1));L
But when I want different actions when there is an explicit number (including
0)
vs. a blank