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 10:23:36 +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 1Kcc32-0005uu-Ot for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 04:24:36 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Kcc30-0005t6-5s for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 04:24:35 -0400 Received: from [199.232.76.173] (port=51884 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Kcc30-0005sy-2B for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 04:24:34 -0400 Received: from wx-out-0506.google.com ([66.249.82.226]:5249) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1Kcc2y-000350-Fn for emacs-orgmode@gnu.org; Mon, 08 Sep 2008 04:24:33 -0400 Received: by wx-out-0506.google.com with SMTP id s15so105665wxc.24 for ; Mon, 08 Sep 2008 01:24:31 -0700 (PDT) In-Reply-To: (Thomas Baumann's message of "Mon, 08 Sep 2008 10:03:11 +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: > Richard G Riley writes: > >> Here is a straightforward spreadsheet: >> >> >> * Test org-mode spreadsheet for cash books >> >> >> | | Name | Cash | >> |---+------------------+----------------| >> | _ | | cashforward | >> | | | 68000 | >> | _ | | cashtake | >> | | cash takings | 2340 | >> | _ | | cashbank | >> | | moved to bank | 2000 | >> |---+------------------+----------------| >> | _ | | cash | >> | # | subtotal | 68340 | >> |---+------------------+----------------| >> | | emp1 | 315 | >> | | emp2 | 289 | >> | | | 0 | >> | | | 0 | >> |---+------------------+----------------| >> | _ | | wages | >> | # | total wages | 604 | >> |---+------------------+----------------| >> | _ | | cashafterwages | >> | # | Cash After Wages | 67736 | >> |---+------------------+----------------| >> #+TBLFM: $cash=$cashforward+$cashtake-$cashbank::$cashafterwages=$cash-$wages::$wages=vsum(@10$3..@13$3) >> >> My questions are: > >> Can one not actually name a specific cell? Or must the name itself be >> stored above or below the cell? > > C-c' > gives you a nice interface to the table formulas, making names > almost obsolete I dont see how - names make the formula readable. How does this buffer makes anything much easier in terms of cell referencing? > >> The wages field : how to generalise this to allow for rows to be >> added/deleted in the emp1,emp2 block? > > $wages = vsum(@-I..@-II) > will do the trick (sum between hlines) > apart from that, if you add rows using M-S-down your formulas will be > adjusted automatically. Thats nice - thanks. > >> 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 :-;) > you might also want to look at the Tbl menu > > >> Oh yes, can one change the enter mode so that the field only edits if >> you press enter first? And then it preselects the previous contents so a >> single key other than cursor keys will wipe the previous contents? >> Currently if I type "5" in the wages field above then, depending where >> the cursor is, I get (for example) 6504. > > The interface is already outstandingly smart: Try moving with the TAB > from one field to another or use enter to stay inside the column. You > will notice that the requested features are already present. Maybe, also > try another couple of spreadsheets :-) 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 |". > > Thomas > > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode