From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Re: Table questions Date: Wed, 20 Dec 2006 00:25:02 +0100 Message-ID: <42f043ca7c4c6d9e666bd66f8c7a1af3@science.uva.nl> References: <1oac1qih6j.fsf@bass.biostat.umn.edu> <1x3b7bbzco.fsf@bass.biostat.umn.edu> Mime-Version: 1.0 (Apple Message framework v624) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1GwoKZ-0007gL-KA for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 18:25:07 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1GwoKY-0007g7-0W for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 18:25:07 -0500 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1GwoKX-0007g4-Rf for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 18:25:05 -0500 Received: from [66.249.92.169] (helo=ug-out-1314.google.com) by monty-python.gnu.org with esmtp (Exim 4.52) id 1GwoKW-0006Kg-V5 for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 18:25:05 -0500 Received: by ug-out-1314.google.com with SMTP id j3so2351487ugf for ; Tue, 19 Dec 2006 15:25:04 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Eddward DeVilla Cc: Michael , emacs-orgmode@gnu.org On Dec 19, 2006, at 23:28, Eddward DeVilla wrote: > I know I use column swapping a lot. I haven't got formulas down yet, > but if I where to use them in a table where I'm liable to column swap, > I'd probably use named columns. (That's supported, right?) Actually, column swapping is not the problem, and org-mode supports it - the formulas stored in a TBLFM line will magically change the $N references along with the swapped columns. This is possible because the calculations in org-mode tables are focused on row formulas at the central use case. An yes, named columns do work as well. For individual fields that you want to use in formulas, you can name a field, or use a constant. > Row > swapping would be trickier, but I don't do that much unless I'm > sorting based on a field, and if I'm sorting, I don't think I'd do > much more than ask for "$named_column one row up". This is what I have started working on some time ago, but not finished because I was not satisfied with the logics. Maybe I'll get back to it. > > The ability to ask for a named column in a row relative to the current > one might be reasonably safe without having to change formulas. > Swapping rows could still bite the user if he didn't plan things out > right. Definitely. - Carsten