Re: [O] table, calc, reorder and protect calculation in one cell

[Uwe Brauer]

>>> "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