Hi Michael,
this is just great! Thanks a lot for this major enhancement,
and for your details explanations and tests.
Michael Brand writes:
> Patch 6 of the attached patches makes it possible to write
> spreadsheet Calc formulas that check for empty fields: To sum the
> first two columns unles
Hi Michael,
Michael Brand 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 add it for Org 8.0.
Best,
Hi all
On Tue, Dec 11, 2012 at 4:14 PM, Michael Brand
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 some more
of basic formula
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.
Bob Newell 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 cell,
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 e
Bob Newell 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", otherwise all
the statistic
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 blank
