Created attachment 143890 [details]
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.
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.
The X Axis labels and legend names of the chart should not disappear even if we set the formula syntax to Excel A1.
Build ID: bb1d5780226bb1b9156580972eea9aa849178742
CPU threads: 1; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2018-07-03_05:56:48
Locale: hu-HU (hu_HU); Calc: group threaded
Created attachment 143891 [details]
Example document saved with Excel A1 formula syntax
Created attachment 143892 [details]
Screenshot of the two files in LO
Found by my team. Verified with a more recent build from the bibisect-6.2 repo, still happens:
Build ID: 921f285c7ff713ad219d3e3385d7e7d12d33581e
CPU threads: 4; OS: Windows 6.3; UI render: default;
Locale: hu-HU (hu_HU); Calc: CL
Created attachment 150099 [details]
The originally Calc A1 example document saved as Excel A1 in 6.3
I can no longer reproduce this problem, in current master it works just fine even with Excel A1 syntax.
Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US