Bug 121285 - FILEOPEN XLSX Column chart axis labels created with Excel change to default value when the document is opened in Calc
Summary: FILEOPEN XLSX Column chart axis labels created with Excel change to default v...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2018-11-08 17:01 UTC by Gabor Kelemen
Modified: 2020-01-29 13:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel, simplified from attachment of bug #54757 (42.09 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-11-08 17:01 UTC, Gabor Kelemen
Details
Screenshot of the original document side by side in Excel and Calc (319.37 KB, image/jpeg)
2018-11-08 17:02 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-11-08 17:01:38 UTC
Created attachment 146454 [details]
Example file from Excel, simplified from attachment of bug #54757

Imported Chart axis labels in DOCX document created with Microsoft Word 2010 change to default when the document is opened in LibreOffice Writer 6.2.0.0.alpha1+.

Steps to reproduce:

    1. Open the attached DOCX file in LibreOffice Writer
    2. View the attached screenshot
    3. Notice that the chart axis labels changed to default

Actual results:
Chart axis labels change to default when the document is opened in LibreOffice Writer 6.2.0.0.alpha1+.

Expected results:
Chart axis should have the same values as the original file when the document is opened in Microsoft Word 2010

LibreOffice details:
Version: 6.2.0.0.alpha1+
Build ID: 2cef68a605494bcef0388201b1058c95788c45a8
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); Calc: threaded
Comment 1 Gabor Kelemen 2018-11-08 17:02:38 UTC
Created attachment 146455 [details]
Screenshot of the original document side by side in Excel and Calc

Of course the file is from Excel :)
Comment 2 raal 2018-11-08 17:31:59 UTC
Confirm with 4.1 and Version: 6.2.0.0.alpha1+
Build ID: b0da1ca2d7a426ff13f39b21362fbcd5c0580c24
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 3 Gabor Kelemen 2019-05-06 09:11:44 UTC
This seems to stem from the same area as bug #80816 - MSO supports custom axis label ranges, but LO doesn't.
Comment 4 NISZ LibreOffice Team 2019-12-07 10:16:28 UTC
(In reply to Gabor Kelemen from comment #3)
> This seems to stem from the same area as bug #80816 - MSO supports custom
> axis label ranges, but LO doesn't.

Looking further, these labels come from this tag in chart1.xml:

<c:numLit><c:formatCode>General</c:formatCode><c:ptCount val="5"/><c:pt idx="0"><c:v>2007</c:v></c:pt><c:pt idx="1"><c:v>2008</c:v></c:pt><c:pt idx="2"><c:v>2009</c:v></c:pt><c:pt idx="3"><c:v>2010</c:v></c:pt><c:pt idx="4"><c:v>2011</c:v></c:pt></c:numLit>

In other words Excel allows a list of string literals to be entered as custom axis labels, while LO allows only a range in Data Ranges dialog - Data Series tab - Categories list.

Selecting a range in Excel instead of the above, saving and opening works fine in Calc master.