On 10/08/2010 10:21 AM, Mike Scott wrote:
On 08/10/10 16:52, 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.
I suggest you check Tools | Cell Contents | Autocalculate is on.
Thanks,
I checked that. It does not have a check mark on it. A right click or
left click will not add a check mark.
Yet now it does recalculate on a new spread sheet by changing a value or
by F9.
Auto-calculate and Auto-input are checked.
Even so, it now seems to work (before and I looked at and tried changing
things).
I checked the spreadsheet that had the problem before, and
Auto-calculate was not checked. It was a sheet that had been used a few
hundred times over the last few years without changes except data
additions at the bottom. Auto-calculate had been checked origionally.
This is not something that changes with an inadvertent slip of the
fingers on the keys (how could you? given the above) or some F- key. So
why did it change?
It does now work.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
