From mboxrd@z Thu Jan 1 00:00:00 1970 From: Richard G Riley Subject: Re: Re: spreadsheet in org Date: Mon, 08 Sep 2008 16:56:27 +0200 Message-ID: References: <1h1vzv1pnr.fsf@googlemail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KciBA-0004oU-1T for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 10:57:24 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KciB9-0004nU-6E for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 10:57:23 -0400 Received: from [199.232.76.173] (port=39297 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KciB9-0004nH-1j for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 10:57:23 -0400 Received: from rn-out-0910.google.com ([64.233.170.187]:34586) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KciB8-0000is-Qc for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 10:57:22 -0400 Received: by rn-out-0910.google.com with SMTP id k32so100373rnd.7 for ; Mon, 08 Sep 2008 07:57:21 -0700 (PDT) In-Reply-To: (Thomas Baumann's message of "Mon, 08 Sep 2008 12:48:49 +0200") 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: Thomas Baumann Cc: emacs-orgmode@gnu.org Thomas Baumann writes: >>>> Or is there a totally better way to do this? I didnt see a way for all >>>> fields to auto calculate when a certain field was changed. One has to >>>> tab over the "#" in the left hand column. Or? >>> >>> As the manual says: C-u C-c * >> >> That is not the same thing as auto recalculation as in excel or similar >> : you must manually invoke it. This is easily forgotten (well by me :-;) >> > > Fortunately, there is _no_ auto-recalculation, it would slow down > things significantly on large tables with complex formulas. Well, clearly one would be able to turn it off in the case of excessive load. In my case its unfortunate, rather than fortunate, since the spreadsheets I have (or want to convert) are small and there is negligible slowdown. To have to remember to refresh the entire spreadsheet is a burden - not a large one I agree, but one which if forgotten could lead to catastrophic financial reports :-; > > >> If I tab to a field above and press enter a new row appears. It is bound >> to org-return. (Latest version). Also there is no preselection of the cell >> contents so if I type "8" when I have tabbed to the "cashbank" field >> above then I get "| 8 2040 |". > > tab into the field and start writing... believe me, it works (org 6.06b > and all versions I used since the tables were introduced.) As I said above, when I tab in and start writing it adds to the existing text. I do believe it might be different for you, but believe me, it does not for me... 6.06b Possibly it is some other mode interfering or we are at cross meanings here - the cashbank example explains the scenario reasonably well I think (or rather hope:-;).