Apache OpenOffice (AOO) Bugzilla – Issue 77463
"document modified" immediately after opening
Last modified: 2007-09-03 19:46:34 UTC
If you have a cell containing function now() and you use this cell in a chart, Calc thinks that the document has been modified immediately after opening. When you close the document you are asked to save changes. It shouldn't happen because you have made no changes! A way to reproduce this bug: 1) Create a new document. 2) Write "=NOW()" to any cell in this document. 3) Select this cell. From main menu select Insert->Chart. In column Range should be address of cell from step 2. Click on "Create". New Chart should appear. 5) Save and close the document. 6) Open the document. 7) When you try to close it, Calc says that the document has been modified. (=bug)
Created attachment 45189 [details] document which makes the bug appear
Confirmed that this issue is as reported (win2000 on OOo2.2.1RC). However I'm not sure it is a bug. When the spreadsheet is reopened, the chart has been altered (based on the =now() formula) so it reasonable to expect that re-saving should occur. Note, that this doesn't occur if the spreadsheet only has the formula (ie, no chart exists). I'll leave as unconfirmed at the moment, and ask on QA list for suggestions whether this is a bug or not. Outcome will be updated back into this issue.
IMHO I don't think this is a bug that needs rectifying. Can the OP reply or add comments to the issue to support the claim that this is a bug...
the behavior is expected
closing the behavior is correct. The 'set document modified status' is set because content within the document changes. Using the function NOW() the content changes each time the document gets recalculated. This is the case if you load the document and it is the case when you press function key F9 (recalculate).
Hi *, I've a Calc document with Now() in a formula/cell. After saving, closing and opening (any time) I can close without the question to save or not -> it seems that Now() doesn't make the document dirty on opening; only when the result is used in a chart ... If others can confirm what I noticed, that should be filed as a bug.
Hi cornouws, it behaves exactly as you say (Linux 2.6.21.1 Debian Lenny (testing) OOo 2.0.4). The problem is in the chart. The function now() doesn't make the document "changed". I really think that it should be treated as a bug. I have a big document that takes quite a long time to save and because of this bug it gets auto saved every time I leave it open for a while. It's really annoying.
entered issue #81238 for the defect.