[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table, calc, reorder and protect calculation in one cell
From: |
Uwe Brauer |
Subject: |
Re: [O] table, calc, reorder and protect calculation in one cell |
Date: |
Mon, 17 Jun 2019 23:06:49 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/27.0.50 (gnu/linux) |
>>> "MB" == Michael Brand <address@hidden> writes:
> Hi Uwe
> On Tue, Jun 11, 2019 at 11:36 AM Uwe Brauer <address@hidden> wrote:
>> Is this behavior possible? When I delete a row or a column, the TBLFM
>> is updated, could that be done for reordering?
> You may want to use something like this, (I knew the syntax for ~"$1"~
> and used the formula debugger ~C-c {~ to find the syntax for
> ~"(Smith)"~):
> | name | C1 | C2 | Res |
> |--------+----+----+-----|
> | Smith | 9 | 1 | 1.7 |
> | Miller | 6 | 2 | 8 |
> | Adams | 5 | 5 | 10 |
> #+TBLFM: $4 = if("$1" == "(Smith)", 0.1 * $2 + 0.8 * $3, $3 + $2)
Ha, of course, thanks, why did that occur to me? I am bit surprised by
the () in Smith, should "Smith" not be sufficient? But it is not indeed,
how odd?
Anyhow, thanks a lot.
Uwe
smime.p7s
Description: S/MIME cryptographic signature