[Libreoffice-bugs] [Bug 119040] New: FILESAVE XLSX: ‘X axis’ labels and legend names disappear from chart with Excel formula syntax

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119040
           Summary: FILESAVE XLSX: ‘X axis’ labels and legend names
                    disappear from chart with Excel formula syntax
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 143890
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143890&action=edit
Example document saved with Calc A1 formula syntax

If we insert a chart into the *.xlsx spreadsheet and save as *.xlsx with Excel
A1 formula syntax in the Formula Option, the X axis labels and the legend names
disappear.

Steps to reproduce:
1.      Open LibreOffice Calc and create a simple chart (e.g.: Column)
2.      Set the Formula Option to Excel A1 syntax: Tools -> Options ->
LibreOffice Calc -> Formula -> Excel A1
3.      Save the file as *.xlsx and reload.


Actual results:
The X Axis labels and legend names of the chart will disappear. But if we do
the same steps, except we modify the Formula Option to Calc A1, nothing will
disappear.

Expected results:
The X Axis labels and legend names of the chart should not disappear even if we
set the formula syntax to Excel A1.

LibreOffice details:
Version: 6.2.0.0.alpha0+
Build ID: bb1d5780226bb1b9156580972eea9aa849178742
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:master, Time: 2018-07-03_05:56:48
Locale: hu-HU (hu_HU); Calc: group threaded

-- 
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/20180801/f51752d0/attachment.html>