[Libreoffice-bugs] [Bug 121285] FILEOPEN XLSX Column chart axis labels created with Excel change to default value when the document is opened in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
(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.

-- 
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/20191207/aa3a8eb9/attachment.html>