John Bowling wrote:
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On
openSUSE 11.3 Work fine until an update in the last few days.
Now simple calculations such as =A15+1 (in A16) will not change if
the value in A15 changes. A16 remains the old value. It does effect
other calculations also, but that's the simplest to describe.
It does the calculation if you are entering new calculations into a
spread sheet, but will not anytime after that. Closing and reopening
the file or Calc will not make it recalculate.
John
Did you get the latest version from openSUSE or from the OOo
website? If you got it from SUSE, that might be the problem. Seems that
every Linux distribution modifies OOo is some way. It might be a bug in
the SUSE flavor of OOo.
I download my version of OOo from the OOo website, and I don't
have that problem. When I change the value in A15, the value in A16
changes as soon as I use the Enter key or any other method to move from
A15 to another cell.
To recalculate, use the F9 key. (Unless SUSE has changed that option.)
Dan
