[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Table formulas: Cannot use column names on the left hand side
From: |
Michael Brand |
Subject: |
Re: [O] Table formulas: Cannot use column names on the left hand side |
Date: |
Thu, 16 Feb 2012 17:52:06 +0100 |
Hi Yu
On Thu, Feb 16, 2012 at 16:56, Yu <address@hidden> wrote:
> I tried today to use named columns for calculations. While this works
> on the right hand side of the equation, names don't seem to work for
> the left hand side --
Named columns are not supported on the left hand side.
> which is a problem, because a change in column
> arrangement, that isn't caused by org functions (e.g. manually
> inserting a column with rectangle-copying) may cause an input column
> to be overwritten accidentially (e.g. having a formula $4=$3*$2+$1 and
> then manually inserting a column for line markers as described in
> "Advanced Features").
If one uses M-<left> and M-<right> instead of rectangle edit to move
around columns then it is much faster and Org takes care of adapting
the formulas so that they still match the new coordinates.
Michael