[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Suggested change to Manual 3.5.9 example table
From: |
Nick Dokos |
Subject: |
Re: [O] Suggested change to Manual 3.5.9 example table |
Date: |
Wed, 11 Jul 2012 11:30:53 -0400 |
Charles <address@hidden> 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(@address@hidden);%.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
Re: [O] Suggested change to Manual 3.5.9 example table,
Nick Dokos <=