From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Table formulas: Cannot use column names on the left hand side Date: Thu, 16 Feb 2012 17:52:06 +0100 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:56542) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Ry4Z3-0002fM-SO for emacs-orgmode@gnu.org; Thu, 16 Feb 2012 11:52:19 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Ry4Yx-0001uT-UU for emacs-orgmode@gnu.org; Thu, 16 Feb 2012 11:52:13 -0500 Received: from mail-we0-f169.google.com ([74.125.82.169]:56039) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Ry4Yx-0001u9-QA for emacs-orgmode@gnu.org; Thu, 16 Feb 2012 11:52:07 -0500 Received: by wera13 with SMTP id a13so1834065wer.0 for ; Thu, 16 Feb 2012 08:52:06 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Yu Cc: org-mode mailing list Hi Yu On Thu, Feb 16, 2012 at 16:56, Yu 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- and M- 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