114589 – Wrong status of the save icon when opening a Calc file

Issue 114589 - Wrong status of the save icon when opening a Calc file

Summary: Wrong status of the save icon when opening a Calc file

Status:	CONFIRMED

Alias:	None

Product:	Calc
Classification:	Application
Component:	save-export (show other issues)
Version:	OOO320m18
Hardware:	Unknown Windows Vista

Importance:	P3 Trivial (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:
Keywords:

Depends on:
Blocks:

Reported:	2010-09-18 15:44 UTC by mi_jm_ru
Modified:	2013-07-07 12:02 UTC (History)
CC List:	2 users (show)

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

Attachments
Wrong status of the save icon when opening this Calc file (948.48 KB, application/vnd.oasis.opendocument.spreadsheet) 2010-09-18 15:49 UTC, mi_jm_ru	no flags	Details
Difference with the previous file: a different data series in the last sheet and it’s ok! (997.22 KB, application/vnd.oasis.opendocument.spreadsheet) 2010-09-18 15:59 UTC, mi_jm_ru	no flags	Details
Various cases showing the relation of the function INDIRECT with the issue (42.33 KB, application/octet-stream) 2010-11-01 18:18 UTC, mi_jm_ru	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description mi_jm_ru 2010-09-18 15:44:15 UTC

When opening some Calc file the save icon in the toolbar is highlighted and
without any change when I close this file the message "the document ... has been
modified. Do you want to save your changes?" appears.
This can be repeated on two computers (with Vista and Windows 7).
I can send a copy of this file and another one slightly different that works
correctly.

Comment 1 mi_jm_ru 2010-09-18 15:49:17 UTC

Created attachment 71757 [details]
Wrong status of the save icon when opening this Calc file

Comment 2 mi_jm_ru 2010-09-18 15:59:55 UTC

Created attachment 71758 [details]
Difference with the previous file: a different data series in the last sheet and it’s ok!

Comment 3 py_samyn 2010-10-31 18:13:16 UTC

Hello

The explanation seems to me the following : a chart in the workbook defaut.ods
(sheet "Q & DN") uses as a source of a data serie a range calculated with a
formula :

= INDIRECT ("densité_HQ." & ADDRESS (ROW (densité_HQ.A $ 23)-I3; COLUMN
(densité_HQ.B $ 24) + H3))

Because of INDIRECT, this is automatically evaluated at the opening, causing the
update of the chart and thus the state "is modified"  of the workbook.

I'm not sure we need to consider this as a bug ...

Workaround : disable Tools > Cells contents > AutoCalculate

Comment 4 py_samyn 2010-11-01 17:36:38 UTC

Hello 

The evaluation of the INDIRECT function does not change the state "modified"
when used in formulas, but only when it is the source of a data series in a chart. 

Upon reflection, I consider this difference of treatment as a bug : chart does
not need to be modified.

Best regards

Comment 5 mi_jm_ru 2010-11-01 18:16:08 UTC

Here are observations which can help:

The bug comes from the use of the INDIRECT function together with the use of the
results in a graph (joined example : “modif-bad”) - a similar file without the
INDIRECT function does not raise problem (joined example “modif-ok1”)

The use of results of the INDIRECT function in calculations and others functions
does not create the problem (joined example : “modif-ok”).

Comment 6 mi_jm_ru 2010-11-01 18:18:25 UTC

Created attachment 72807 [details]
Various cases showing the relation of the function INDIRECT with the issue

Comment 7 Edwin Sharp 2013-07-07 12:02:49 UTC

Attachment 71757 [details] opens with save icon on.

Rev. 1499775 Win 7