<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body><table border="1" cellspacing="0" cellpadding="8"> <tr> <th>Bug ID</th> <td><a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FILESAVE: Chart Data Series lost on save (XLSX)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=114657">114657</a> </td> </tr> <tr> <th>Summary</th> <td>FILESAVE: Chart Data Series lost on save (XLSX) </td> </tr> <tr> <th>Product</th> <td>LibreOffice </td> </tr> <tr> <th>Version</th> <td>5.3.1.2 release </td> </tr> <tr> <th>Hardware</th> <td>Other </td> </tr> <tr> <th>OS</th> <td>Linux (All) </td> </tr> <tr> <th>Status</th> <td>UNCONFIRMED </td> </tr> <tr> <th>Severity</th> <td>normal </td> </tr> <tr> <th>Priority</th> <td>medium </td> </tr> <tr> <th>Component</th> <td>Calc </td> </tr> <tr> <th>Assignee</th> <td>libreoffice-bugs@lists.freedesktop.org </td> </tr> <tr> <th>Reporter</th> <td>ndallas1983@gmail.com </td> </tr></table> <p> <div> <pre>Description: LO Calc reads the chart correctly when first opening the XLSX file. But when performing "Save As XLSX", the Data Series formula references are corrupted. If there is a workaround, do you have any alternative ways in writing out the Data Series in a different way that may not become corrupted? Steps to Reproduce: 1. Create an XLSX file using Microsoft Excel (2013+) 2. Create a chart using a Data Series to plot. 3. Assign the data series as similar: Name: =Sheet1!$A$1 Categories: =Sheet1!$B$1 X-Values: =Sheet1!$A$2:$A$10 Y-Values: =Sheet1!$B$2:$B$10 4. Save the XLSX file in Microsoft Excel. 5. Open the XLSX file in LibreOffice Calc. 6. Notice that the series look correct, the chart looks normal. 7. In LibreOffice, "Save As New XLSX file". 8. Close the XLSX file. 9. Open the "New XLSX file" in Microsoft Excel. Actual Results: 1. Open the XLSX File saved in Libre Office, into Microsoft Excel. 2. Click the Chart. 3. Click the Filter icon to the right. 4. Mouse over the Series label in the list. 5. Click the icon to the right of the label in Series. 6. Notice the Data Series References now look like the following: Name: =sheet1 $A$1 Categories: =sheet1 $B$1 X-Values: =sheet1 $A$2:$A$10 Y-Values: =sheet1 $B$2:$B$10 Expected Results: The Data Series should remain unchanged. Name: =Sheet1!$A$1 Categories: =Sheet1!$B$1 X-Values: =Sheet1!$A$2:$A$10 Y-Values: =Sheet1!$B$2:$B$10 Reproducible: Always User Profile Reset: Yes Additional Info: I can provide file attachments if that helps. Here's the output for the latest version of LibreOffice. Please note that I upgraded to LibreOffice 5.3.1, and the last version (2 months ago) had the same problem. Upgrading did not fix the issue. ** (soffice:13694): CRITICAL **: void g_lo_menu_insert_section(GLOMenu*, gint, const gchar*, GMenuModel*): assertion 'G_IS_LO_MENU (menu)' failed (soffice:13694): Gtk-CRITICAL **: gtk_menu_bar_new_from_model: assertion 'G_IS_MENU_MODEL (model)' failed (soffice:13694): Gtk-CRITICAL **: gtk_widget_insert_action_group: assertion 'GTK_IS_WIDGET (widget)' failed (soffice:13694): Gtk-CRITICAL **: gtk_widget_set_hexpand: assertion 'GTK_IS_WIDGET (widget)' failed (soffice:13694): Gtk-CRITICAL **: gtk_grid_attach: assertion 'GTK_IS_WIDGET (child)' failed (soffice:13694): GLib-GObject-WARNING **: invalid (NULL) pointer instance (soffice:13694): GLib-GObject-CRITICAL **: g_signal_connect_data: assertion 'G_TYPE_CHECK_INSTANCE (instance)' failed (soffice:13694): GLib-GObject-WARNING **: invalid (NULL) pointer instance (soffice:13694): GLib-GObject-CRITICAL **: g_signal_connect_data: assertion 'G_TYPE_CHECK_INSTANCE (instance)' failed ** (soffice:13694): CRITICAL **: void g_lo_menu_insert_section(GLOMenu*, gint, const gchar*, GMenuModel*): assertion 'G_IS_LO_MENU (menu)' failed (soffice:13694): Gtk-CRITICAL **: gtk_menu_bar_new_from_model: assertion 'G_IS_MENU_MODEL (model)' failed (soffice:13694): Gtk-CRITICAL **: gtk_widget_insert_action_group: assertion 'GTK_IS_WIDGET (widget)' failed (soffice:13694): Gtk-CRITICAL **: gtk_widget_set_hexpand: assertion 'GTK_IS_WIDGET (widget)' failed (soffice:13694): Gtk-CRITICAL **: gtk_grid_attach: assertion 'GTK_IS_WIDGET (child)' failed (soffice:13694): GLib-GObject-WARNING **: invalid (NULL) pointer instance (soffice:13694): GLib-GObject-CRITICAL **: g_signal_connect_data: assertion 'G_TYPE_CHECK_INSTANCE (instance)' failed (soffice:13694): GLib-GObject-WARNING **: invalid (NULL) pointer instance (soffice:13694): GLib-GObject-CRITICAL **: g_signal_connect_data: assertion 'G_TYPE_CHECK_INSTANCE (instance)' failed [13843:13843:1222/214903.577207:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. [13853:13853:1222/214903.661560:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: firefox: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: iceweasel: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: seamonkey: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: mozilla: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: epiphany: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: konqueror: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: chromium-browser: not found [13877:13877:1222/214903.736524:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: www-browser: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links2: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: elinks: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: lynx: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: w3m: not found xdg-open: no method available for opening '<a href="http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3">http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3</a>' root@secure-server:/var/www/vhosts/stage.mcedemo.com/storage/exports# [14009:14009:1222/214908.439797:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. [14019:14019:1222/214908.504337:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: firefox: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: iceweasel: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: seamonkey: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: mozilla: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: epiphany: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: konqueror: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: chromium-browser: not found [14043:14043:1222/214908.574746:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: www-browser: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links2: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: elinks: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: lynx: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: w3m: not found xdg-open: no method available for opening '<a href="http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3">http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3</a>' [14138:14138:1222/214909.290545:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. [14148:14148:1222/214909.341600:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: firefox: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: iceweasel: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: seamonkey: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: mozilla: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: epiphany: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: konqueror: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: chromium-browser: not found [14172:14172:1222/214909.401990:ERROR:zygote_host_impl_linux.cc(88)] Running as root without --no-sandbox is not supported. See <a href="https://crbug.com/638180">https://crbug.com/638180</a>. /usr/bin/xdg-open: 771: /usr/bin/xdg-open: www-browser: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links2: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: elinks: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: links: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: lynx: not found /usr/bin/xdg-open: 771: /usr/bin/xdg-open: w3m: not found xdg-open: no method available for opening '<a href="http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3">http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3</a>' User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36</pre> </div> </p> <hr> <span>You are receiving this mail because:</span> <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>