Issue 77463 - "document modified" immediately after opening
Summary: "document modified" immediately after opening
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2007-05-17 15:17 UTC by nily
Modified: 2007-09-03 19:46 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

document which makes the bug appear (11.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-05-17 15:21 UTC, nily
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description nily 2007-05-17 15:17:27 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)
Comment 1 nily 2007-05-17 15:21:35 UTC
Created attachment 45189 [details]
document which makes the bug appear
Comment 2 2007-05-22 01:05:12 UTC
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.
Comment 3 2007-05-22 02:46:48 UTC
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...
Comment 4 Joost Andrae 2007-05-22 09:44:18 UTC
the behavior is expected
Comment 5 Joost Andrae 2007-05-22 09:56:27 UTC

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).
Comment 6 cno 2007-05-22 11:39:55 UTC
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.
Comment 7 nily 2007-05-22 14:50:22 UTC
Hi cornouws,

it behaves exactly as you say (Linux 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.
Comment 8 cno 2007-09-03 19:46:34 UTC
entered issue #81238 for the defect.