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. 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@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: Version: 6.2.0.0.alpha0+ 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. Version: 6.3.0.0.alpha0+ Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded