From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nick Dokos Subject: Re: Suggested change to Manual 3.5.9 example table Date: Wed, 11 Jul 2012 11:30:53 -0400 Message-ID: <11334.1342020653@alphaville> References: <4FFD89AD.1030707@verizon.net> Reply-To: nicholas.dokos@hp.com Return-path: Received: from eggs.gnu.org ([208.118.235.92]:46195) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Soysi-0002Ua-Rh for emacs-orgmode@gnu.org; Wed, 11 Jul 2012 11:31:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SoysZ-000208-Sk for emacs-orgmode@gnu.org; Wed, 11 Jul 2012 11:31:12 -0400 Received: from g4t0015.houston.hp.com ([15.201.24.18]:14700) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SoysZ-0001z8-Lo for emacs-orgmode@gnu.org; Wed, 11 Jul 2012 11:31:03 -0400 In-Reply-To: Message from Charles of "Wed, 11 Jul 2012 10:11:57 EDT." <4FFD89AD.1030707@verizon.net> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Charles Cc: emacs-orgmode Mode Charles wrote: > I have searched the news groups concerning this and found nothing. > > I am attempting to learn the advance features for tables and could not > understand 29.7 as the result for $at=vmean(@-II..@-I);%.1f. > > I copied the table and formulas into a scratch org file, changed the > floating point to .2f and the result was 25.00, which I believe is > correct. I changed it back to .1f and 25.0 was the result. > > Is the result as given in the manual supposed to demonstrate some > concept that is not evident to me? > Good one. It *may* have been intended to illustrate the difference between rows marked with # and unmarked rows; e.g. if you go back and change a grade in Sam's row and press TAB, then the # rows are recalculated but the unmarked one is not. So the 29.7 might have been a (now incorrect) remnant of a previous calculation that would have been corrected in the next global recalculation. However, if that's the case, a more extensive explanation would certainly be welcome. Nick