<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body><a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> Timur</a> changed <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE: Data table (from copied chart) with empty row exported incorrectly to XLSX (Data Labels missing and X-Values wrong) -see Comment 6" href="https://bugs.documentfoundation.org/show_bug.cgi?id=114657">bug 114657</a> <table border="1" cellspacing="0" cellpadding="8"> <tr> <th>What</th> <th>Removed</th> <th>Added</th> </tr> <tr> <td style="text-align:right;">Status</td> <td>NEEDINFO </td> <td>NEW </td> </tr> <tr> <td style="text-align:right;">Summary</td> <td>FILESAVE: Chart Data Series lost on save (XLSX) </td> <td>FILESAVE: Data table (from copied chart) with empty row exported incorrectly to XLSX (Data Labels missing and X-Values wrong) -see Comment 6 </td> </tr> <tr> <td style="text-align:right;">OS</td> <td>Linux (All) </td> <td>All </td> </tr> <tr> <td style="text-align:right;">Severity</td> <td>normal </td> <td>minor </td> </tr></table> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE: Data table (from copied chart) with empty row exported incorrectly to XLSX (Data Labels missing and X-Values wrong) -see Comment 6" href="https://bugs.documentfoundation.org/show_bug.cgi?id=114657#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILESAVE: Data table (from copied chart) with empty row exported incorrectly to XLSX (Data Labels missing and X-Values wrong) -see Comment 6" href="https://bugs.documentfoundation.org/show_bug.cgi?id=114657">bug 114657</a> from <a class="email" href="mailto:gtimur@gmail.com" title="Timur <gtimur@gmail.com>"> Timur</a> <pre>Original <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138602" name="attach_138602" title="XLSX with working chart (before saving from LO)">attachment 138602</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138602&action=edit" title="XLSX with working chart (before saving from LO)">[details]</a> XLSX has Data Ranges. Saving as XLSX keeps them in my test and MM noticed similar. Not clear how <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138603" name="attach_138603" title="XLSX after saving in LibreOffice as XLSX (breaks data series)">attachment 138603</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138603&action=edit" title="XLSX after saving in LibreOffice as XLSX (breaks data series)">[details]</a> has Data Table. So I guess: 1. Open <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138602" name="attach_138602" title="XLSX with working chart (before saving from LO)">attachment 138602</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138602&action=edit" title="XLSX with working chart (before saving from LO)">[details]</a> 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 (<a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - Copying a chart converts data ranges to data table" href="show_bug.cgi?id=113572">Bug 113572</a>) 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>