[Libreoffice-bugs] [Bug 114177] New: FILESAVE XLSX Selecting not adjacent cells as range of values leads to the disappearance of the chart

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114177

            Bug ID: 114177
           Summary: FILESAVE XLSX Selecting not adjacent cells as range of
                    values leads to the disappearance of the chart
           Product: LibreOffice
           Version: 6.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 138134
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138134&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171130/e1e090d7/attachment.html>