David Hawes wrote:
Hi guys,
I have been using Open Office for some time now.
I have come across a problem in that when i copy a
formula from one cell to another, the formula stays
the same rather than adjusting to the new cell.
Consequently the output of the formula is wrong.
EG f5-e5 as a formula in g5
when copied to g6, it stays as f5-e5.
Is this a bug or just how open office works?
In the same spreadsheet i total a column.
As values are added in that column, i expected the
total to change, but it doesnt.
When i edit the formula in the cell deleting the last
reference then entering it again, the total updates.
I am using 1.1.4
Regards
David
Is auto-calculate off? I think that it is somplace like Tools | Cells |
Auto-calculate
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
