[Libreoffice-bugs] [Bug 114657] FILESAVE: Data table (from copied chart) with empty row exported incorrectly to XLSX ( Data Labels missing and X-Values wrong) -see Comment 6

[bugzilla-daemon at bugs.documentfoundation.org]

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

Timur <gtimur at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW
            Summary|FILESAVE: Chart Data Series |FILESAVE: Data table (from
                   |lost on save (XLSX)         |copied chart) with empty
                   |                            |row exported incorrectly to
                   |                            |XLSX (Data Labels missing
                   |                            |and X-Values wrong) -see
                   |                            |Comment 6
                 OS|Linux (All)                 |All
           Severity|normal                      |minor

--- Comment #6 from Timur <gtimur at gmail.com> ---
Original attachment 138602 XLSX has Data Ranges. Saving as XLSX keeps them in
my test and MM noticed similar. 
Not clear how attachment 138603 has Data Table. So I guess:

1. Open attachment 138602 XLSX with Data Ranges
2. Note Data Range is wrong: $Summary.$A$5:$B$10;$Summary.$B$4 because A4 is
missing but it doesn't affect result
3. Note Data Ranges has empty row, which will affect result
4. Copy chart to a new spreadsheet file (Bug 113572) and save as ODS and XLSX
5. Reopen new ODS and see that chart looks fine, data is in Data Table with
Data Labels 1-6 and 5 X-Values and Y-values (not in 6th)
6. Reopen new XLSX and see that chart doesn't look fine because Data Table is
wrong: no Data Labels and 6th X-Values is 1 and 6th Y-Values is empty

Obvious workaround is to restrict Data Range is original XLSX to avoid empty
row. 
Solution is to fix xlsx export. 
So I'll confirm as I wrote and rename. I'll leave version 5.3 although there
were some changes, 6th Y-Values was 0 which is also wrong. LO 5.2 was worse,
didn't export Y-Values at all. So no regression, but it would be useful to see
who worked on this. 
If it's not like that, please comment.

-- 
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/20171227/e097435a/attachment.html>