Sorry guys
I have explained my first issue wrongly.
On checking again, the formula changes in line with
the new cell.
The resultant sum of the formula, however, remains the
same as the value from where i took the formula from.
eg
f5-g5 is 10-5 which gives 5
copying the formula down i get:
f6-g6 is 12-4 which gives 5!
Hope i have explained that well enough.
cheers
David
Note: forwarded message attached.
--- Begin Message ---
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
--- End Message ---
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
