From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: new spreadsheet features: field coordinates, multi line TBLFM with comments Date: Sun, 14 Mar 2010 13:13:57 +0100 Message-ID: <57645FA4-67B9-4CA7-9982-0D535EEA100E@gmail.com> References: <4B9BAED2.8000600@alumni.ethz.ch> <24E1A3E6-3F21-432B-801A-56726F002155@gmail.com> <4B9CCDB9.6060903@alumni.ethz.ch> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Nqmhn-00008x-RT for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 08:14:03 -0400 Received: from [140.186.70.92] (port=39748 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Nqmhm-000085-AM for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 08:14:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1Nqmhk-0008Cd-LM for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 08:14:02 -0400 Received: from mail-ew0-f216.google.com ([209.85.219.216]:43058) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1Nqmhk-0008CY-Fh for emacs-orgmode@gnu.org; Sun, 14 Mar 2010 08:14:00 -0400 Received: by ewy8 with SMTP id 8so711398ewy.8 for ; Sun, 14 Mar 2010 05:13:59 -0700 (PDT) In-Reply-To: <4B9CCDB9.6060903@alumni.ethz.ch> 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: Michael Brand Cc: Org Mode On Mar 14, 2010, at 12:51 PM, Michael Brand wrote: > 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 Done. > > >>> 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. Thanks. > 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 > ===================================================================== Applied as well, thank you! - Carsten