Bug 119040 - FILESAVE XLSX: ‘X axis’ labels and legend names disappear from chart with Excel formula syntax
Summary: FILESAVE XLSX: ‘X axis’ labels and legend names disappear from chart with Exc...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Chart-Labels Chart-Legends
  Show dependency treegraph
 
Reported: 2018-08-01 13:28 UTC by Gabor Kelemen
Modified: 2019-03-19 12:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example document saved with Calc A1 formula syntax (16.71 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 13:28 UTC, Gabor Kelemen
Details
Example document saved with Excel A1 formula syntax (16.72 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-08-01 13:30 UTC, Gabor Kelemen
Details
Screenshot of the two files in LO (100.52 KB, image/png)
2018-08-01 13:30 UTC, Gabor Kelemen
Details
The originally Calc A1 example document saved as Excel A1 in 6.3 (11.64 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-19 12:15 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen 2018-08-01 13:28:25 UTC
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
Comment 1 Gabor Kelemen 2018-08-01 13:30:18 UTC
Created attachment 143891 [details]
Example document saved with Excel A1 formula syntax
Comment 2 Gabor Kelemen 2018-08-01 13:30:48 UTC
Created attachment 143892 [details]
Screenshot of the two files in LO
Comment 3 Gabor Kelemen 2018-08-01 13:34:30 UTC
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
Comment 4 Gabor Kelemen 2019-03-19 12:15:15 UTC
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