From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: new spreadsheet features: field coordinates, multi line TBLFM with comments Date: Sun, 14 Mar 2010 12:51:21 +0100 Message-ID: <4B9CCDB9.6060903@alumni.ethz.ch> References: <4B9BAED2.8000600@alumni.ethz.ch> <24E1A3E6-3F21-432B-801A-56726F002155@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NqmLv-0004qU-Ma for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 07:51:27 -0400 Received: from [140.186.70.92] (port=53236 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NqmLu-0004pq-7c for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 07:51:27 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NqmLs-0006PM-Ot for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 07:51:26 -0400 Received: from mail01.solnet.ch ([212.101.4.135]:58450) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NqmLs-0006Ov-Jl for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 07:51:24 -0400 In-Reply-To: <24E1A3E6-3F21-432B-801A-56726F002155@gmail.com> 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: Carsten Dominik Cc: Org Mode Carsten Dominik wrote: >> 1) field coordinates: >> [...] >> +@subsubheading Field coordinates >> [...] > > That does look reasonable, and I am going to take that patch. Thank you. Maybe this change of the above would make it clearer: +@subsubheading Field coordinates in formulas >> 2) self-edited multi line TBLFM with comments: > > Before looking further, I would like to find out if you are aware > of the existence of the formula editior, invoked the command > C-c ' (that is C-c followed by the single quote) while the > cursor is in a table. > > The formula editor does not have comments, but otherwise it is more > powerful than what you propose. Much more powerful, really great and well designed! Most of all the highlighting of fields and ranges. I prefer that much over my proposal and abandon comments inside. I knew the manual heading but since I stuck on the word `debugging' and _underestimated_ the word `Editing', at least when already editing in a org-mode buffer, I thought there is no need to read as long as my formulas work... Not only for this reason but mostly because of the great value I think it is more than worth mentioning it in the spreadsheet summary in the manual somehow like this: ====================================================================== --- org.texi.orig.texi Sat Mar 13 15:41:20 2010 +++ org.texi Sun Mar 14 12:39:07 2010 @@ -1931,7 +1931,9 @@ derive fields from other fields. While implementation is not identical to other spreadsheets. For example, Org knows the concept of a @emph{column formula} that will be applied to all non-header fields in a column without having to copy the -formula to each relevant field. +formula to each relevant field. There is a special formula editor with +features for highlighting fields in the table corresponding to the +references at the point in the formula, moving these references by +arrow keys and a formula debugger. @menu * References:: How to refer to another field or range =====================================================================