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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
