Bug 67945

Summary: FILEOPEN: when opening a file with INDIRECT to another sheet and chart -> file dirty
Product: LibreOffice Reporter: A. Stucki <a.stucki>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: a.stucki, jmadero.dev
Version: 4.1.0.4 releaseKeywords: regression
Hardware: Other   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: file with indirect & chart
same as test 1, _except_ chart deleted

Description A. Stucki 2013-08-09 09:49:16 UTC
Created attachment 83886 [details]
file with indirect & chart

System: Win7 Pro x64, LO 4.0.0.4

Behavior:
1. open the attached file -> the "save" button is on (the user does not change anything!)
2. exit Calc -> the save/ dont save/ cancel box appears

I.e. the file is "dirty", LO changed something even if there is no change in the content by the user (the INDIRECT expression links to another sheet, not to some external file!)

The effect disappears in the following cases:
- use of LO 4.0.4.2
- deleting the chart on the "Sum" sheet (approx. cell G5)
- replacing the indirect expression in cell B7 with its literal: "2010-04-10"
Comment 1 A. Stucki 2013-08-09 09:50:08 UTC
Sorry, typo with the LO version where the bug shows, is of cource 4.1.0.4
Comment 2 Joel Madero 2014-03-06 21:17:27 UTC
This was never confirmed by an independent person - setting to UNCONFIRMED
Comment 3 Joel Madero 2014-03-06 22:53:44 UTC
Sorry but I'm not understanding the reproducible steps. Please verify that this is still a problem with 4.1.5 or 4.2.1.1 and then provide clearer steps on what we are seeing that is broken.

Marking as NEEDINFO - if it's still an issue and you can provide clearer instructions mark as UNCONFIRMED and we'll take a look. Thanks
Comment 4 A. Stucki 2014-03-07 07:41:16 UTC
Tested with 4.2.1.1, still same behavior...

I do not know what information to provide in addition, sorry, just added another file where the chart is deleted ->
- "save" button is off
- when exiting Calc, the the save/ dont save/ cancel box diƓes _not_ appear
Comment 5 A. Stucki 2014-03-07 07:42:16 UTC
Created attachment 95293 [details]
same as test 1, _except_ chart deleted

see last comment, one of the 3 changes that make the bug disappear
Comment 6 QA Administrators 2014-10-05 23:05:53 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 7 A. Stucki 2014-10-06 06:50:00 UTC
Just tested with LO 4.3.1.2 Win7/ 64 -> still the same wrong behavior
Comment 8 ign_christian 2014-10-06 09:20:23 UTC
I can confirm with LO 4.3.2.2 portable - Win7 x86, "Save" button is active after file loaded.

Not occured with LO 4.0.6.2
Comment 9 ign_christian 2014-10-06 09:38:43 UTC
(In reply to A. Stucki from comment #0)
> - deleting the chart on the "Sum" sheet (approx. cell G5)
> - replacing the indirect expression in cell B7 with its literal: "2010-04-10"

Confirmed. No problem if we remove indirect function nor chart. Both must exist to reproduce the problem.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.