[Libreoffice-bugs] [Bug 114657] New: FILESAVE: Chart Data Series lost on save (XLSX)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Dec 22 21:50:49 UTC 2017 

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

            Bug ID: 114657
           Summary: FILESAVE: Chart Data Series lost on save (XLSX)
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: Other
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ndallas1983 at gmail.com

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 https://crbug.com/638180.
[13853:13853:1222/214903.661560:ERROR:zygote_host_impl_linux.cc(88)] Running as
root without --no-sandbox is not supported. See https://crbug.com/638180.
/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 https://crbug.com/638180.
/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
'http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3'
root at 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 https://crbug.com/638180.
[14019:14019:1222/214908.504337:ERROR:zygote_host_impl_linux.cc(88)] Running as
root without --no-sandbox is not supported. See https://crbug.com/638180.
/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 https://crbug.com/638180.
/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
'http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3'
[14138:14138:1222/214909.290545:ERROR:zygote_host_impl_linux.cc(88)] Running as
root without --no-sandbox is not supported. See https://crbug.com/638180.
[14148:14148:1222/214909.341600:ERROR:zygote_host_impl_linux.cc(88)] Running as
root without --no-sandbox is not supported. See https://crbug.com/638180.
/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 https://crbug.com/638180.
/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
'http://help.libreoffice.org/swriter/sfx/ui/startcenter/open_all?Language=en-US&System=UNIX&Version=5.3'




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

-- 
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/20171222/a38bc144/attachment.html>

More information about the Libreoffice-bugs mailing list