From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Re: spreadsheet in org Date: Mon, 8 Sep 2008 19:07:10 +0200 Message-ID: <6088737A-C295-4508-9575-5D6CE909C6F8@uva.nl> References: <1h1vzv1pnr.fsf@googlemail.com> Mime-Version: 1.0 (Apple Message framework v926) 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 1KckCr-0003ke-6Q for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 13:07:17 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KckCq-0003kI-Ji for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 13:07:16 -0400 Received: from [199.232.76.173] (port=42519 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KckCq-0003kF-8i for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 13:07:16 -0400 Received: from gv-out-0910.google.com ([216.239.58.185]:46538) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KckCp-0000va-Uk for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 13:07:16 -0400 Received: by gv-out-0910.google.com with SMTP id i36so258345gve.17 for ; Mon, 08 Sep 2008 10:07:14 -0700 (PDT) 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: Richard G Riley Cc: Thomas Baumann , emacs-orgmode@gnu.org On Sep 8, 2008, at 4:56 PM, Richard G Riley wrote: > 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 :-; Hi Richard, how about this code (can even go into .emacs): (run-with-idle-timer 1.0 'repeat (lambda () (and (eq major-mode 'org-mode) (org-at-table-p) (org-table-recalculate 'all)))) This will recalculate each time you are idle for more than 1 second with cursor inside the table. This may get you into trouble when you have a formula that produces and error, in which case you can protect the call with a condition- case, or you can write yourself a function that does turn this feature on and off. >> >> >>> 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... What is the setting of org-table-auto-blank-field ? If it is t and the feature Thomas describes does not work, you have indeed got interference from some other package. - Carsten