Bug 114177 - FILEOPEN XLSX Selecting not adjacent cells as range of values leads to the disappearance of the chart in LibreOffice
Summary: FILEOPEN XLSX Selecting not adjacent cells as range of values leads to the di...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks:
 
Reported: 2017-11-30 14:47 UTC by Gabor Kelemen (allotropia)
Modified: 2018-02-16 10:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file made with Excel 2013 (50.56 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-11-30 14:47 UTC, Gabor Kelemen (allotropia) 		Details
The example file saved by LO6 alpha (25.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-11-30 14:53 UTC, Gabor Kelemen (allotropia) 		Details
The example file in LO (137.44 KB, image/png)
2017-11-30 15:02 UTC, Gabor Kelemen (allotropia) 		Details
The document opened with latest master build (259.90 KB, image/png)
2018-02-16 09:21 UTC, Gabor Kelemen (allotropia) 		Details
The example file saved by LO6.1 alpha (25.12 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-02-16 10:24 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2017-11-30 14:47:18 UTC 
Created attachment 138134 [details]
Example file made with Excel 2013

If we create a simple column chart in Microsoft Excel and we set not adjacent cells as range of value, but the address range cells are next to each other the chart will disappear after you save as the file as XLSX with LibreOffice Calc and reload it.


Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Add values to a few cells.
3. Add a new column chart to the spreadsheet.
4. Click on the empty chart with right click and choose “select datas”.
4. Select the value range, but select not adjacent cells. (=(Munka1!$B$4;Munka1!$D$4))
5. Select the address range, but select adjacent cells. (=Munka1!$B$3:$E$3)
6. Save the file as XLSX and open with LibreOffice Calc.
7. Save as the file as XLSX and reload the file.

Actual results:
The chart disappears. You can see in LibreOffice Calc, that the selected value ranges are lost.

Expected results:
The chart should not disappear, and the selected value ranges should be preserved.
Comment 1 Gabor Kelemen (allotropia) 2017-11-30 14:53:03 UTC 
Created attachment 138135 [details]
The example file saved by LO6 alpha
Comment 2 Gabor Kelemen (allotropia) 2017-11-30 15:02:12 UTC 
Created attachment 138138 [details]
The example file in LO
Comment 3 Buovjaga 2017-12-03 14:53:39 UTC 
Repro with attachment

Version: 6.1.0.0.alpha0+ (x64)
Build ID: cc1db6f2b0ebe05ae807628778835b62df00eca2
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-12-03_00:59:10
Locale: fi-FI (fi_FI); Calc: group threaded

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 4 Bartosz 2018-01-12 08:32:07 UTC 
It seems that the issue is with FILEOPEN of .xlsx file, and to with saving to .xlsx.
MS Excel 2013 is opening file exported with LibreOffice 6.0 properly.
Please confirm.
Comment 5 Buovjaga 2018-02-15 15:03:32 UTC 
(In reply to Bartosz from comment #4)
> It seems that the issue is with FILEOPEN of .xlsx file, and to with saving
> to .xlsx.
> MS Excel 2013 is opening file exported with LibreOffice 6.0 properly.
> Please confirm.

I re-tested with the latest 6.1 build and there is no problem in either LibO or MSO. Gábor, please confirm it is fixed.
Comment 6 Gabor Kelemen (allotropia) 2018-02-16 09:21:45 UTC 
Created attachment 139933 [details]
The document opened with latest master build

Seems to open correctly now. Thanks whoever did this :).
Comment 7 Buovjaga 2018-02-16 09:33:57 UTC 
Great, closing.
Comment 8 Gabor Kelemen (allotropia) 2018-02-16 10:24:49 UTC 
Created attachment 139940 [details]
The example file saved by LO6.1 alpha