Bug 77007 - FILEOPEN: User asked to save changes upon exit from unmodified XLS file (possibly because of particular chart)
Summary: FILEOPEN: User asked to save changes upon exit from unmodified XLS file (poss...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.0.4.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-03 14:29 UTC by larin
Modified: 2014-12-12 10:31 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
a sample .xls file with a chart to illustrate the problem (12.50 KB, application/vnd.ms-excel)
2014-04-03 14:29 UTC, larin 		Details
testcase (41.00 KB, application/vnd.ms-excel)
2014-10-19 19:53 UTC, Yan Pas 		Details
View All

Description larin 2014-04-03 14:29:08 UTC 
Created attachment 96853 [details]
a sample .xls file with a chart to illustrate the problem

LibreOffice Calc, ver. 4.0.4.2, Linux CentOS

Problem not critical but annoying.

Calc prompts user to save an XLS file (which contains a chart) when no changes were made to the file.  It seems as if the presence of a chart in the file may be triggering this.

A sample.xls file is attached.  To reproduce the problem, try opening and closing the file.

Thanks,
Max
Comment 1 Owen Genat 2014-04-04 05:23:25 UTC 
Confirmed under Debian 7 with v4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 and Crunchbang 11 with v4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f. Opening the provided XLS results in the file modified status being triggered, thus closing the file asks for confirmation. Status set to NEW.
Comment 2 Yan Pas 2014-10-19 19:53:41 UTC 
Created attachment 108074 [details]
testcase

I have this bug too. My file
Comment 3 ign_christian 2014-10-20 02:28:30 UTC 
Repro with LO 4.3.2.2 portable - Win7 x86

Seems a fileopen problem, not filesave. If someone could provide simple test case with exact reproducible steps it would help dev a lot.
Comment 4 Yan Pas 2014-10-20 07:15:33 UTC 
What do you mean under testcase? List of steps how to create such file with bug?
Comment 5 ign_christian 2014-10-20 12:34:29 UTC 
(In reply to Yan Pashkovsky from comment #4)
> What do you mean under testcase? List of steps how to create such file with
> bug?
Yup. More simple the steps to repro bug, more easy for dev to identify problem & fix the bug.
Comment 6 Yan Pas 2014-11-04 17:51:42 UTC 
I have found that if I delete all 3 diagrams from my xls I am no longer asked to save file
Comment 7 Yan Pas 2014-12-12 10:31:21 UTC 
(In reply to ign_christian from comment #5)
> (In reply to Yan Pashkovsky from comment #4)
> > What do you mean under testcase? List of steps how to create such file with
> > bug?
> Yup. More simple the steps to repro bug, more easy for dev to identify
> problem & fix the bug.

Another dependency! Steps to reproduce:
1) Create xls file
2) Insert formula (X^2 for example)
3) Save it
4) Open again and try to close - you will be asked if you want to save changes

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.