Issue 77463

Summary:

"document modified" immediately after opening

Product:

Calc

Reporter:

nily <nilyho>

Component:

viewing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

cno, issues

Version:

OOo 2.0.4

Keywords:

needmoreinfo, oooqa

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
document which makes the bug appear	none

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 paul.m.nz 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 paul.m.nz 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

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).

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 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.

Comment 8 cno 2007-09-03 19:46:34 UTC

entered issue #81238 for the defect.