[Libreoffice-bugs] [Bug 121281] New: FILEOPEN XLSX Chart data labels created with Excel cover each other when the document is opened in Calc

[b***@bugs.documentfoundation.org]

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

Bug ID: 121281
Summary: FILEOPEN XLSX Chart data labels created with Excel
cover each other when the document is opened in Calc
Product: LibreOffice
Version: 6.2.0.0.alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@ubuntu.com

See attachment #146447 and attachment 146448 from bug #121279

Imported upper Pie Chart data labels in XLSX documents created with Microsoft
Excel 2010 cover each other when the document is opened in LibreOffice Calc
6.2.0.0.alpha1+.

Steps to reproduce:

1. Open the attached XLSX file in LibreOffice Calc
2. View the attached screenshot
3. Notice, that chart data labels cover each other

Actual results:
Chart data labels cover each other when the document is opened in LibreOffice
Calc 6.2.0.0.alpha1+.

Expected results:
Chart data labels should have the same position as the original file as when
the document is opened in Microsoft Excel 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

[b***@bugs.documentfoundation.org]

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

Gabor Kelemen <***@ubuntu.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Component|Calc |Chart
CC| |***@nisz.hu

[b***@bugs.documentfoundation.org]

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

Gabor Kelemen <***@ubuntu.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=12
| |1279

[b***@bugs.documentfoundation.org]

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
CC| |***@libreoffice.org
Version|6.2.0.0.alpha1+ Master |6.1.0.0.alpha1+
Keywords| |bisected, filter:xlsx
Status|UNCONFIRMED |NEW

--- Comment #1 from Xisco Faulí <***@libreoffice.org> ---
It might get fixed if bug 121279 is fixed

The label import got implemented in
https://cgit.freedesktop.org/libreoffice/core/commit/?id=790f9abeb1a1167ad5ab84c5fb855b36669c125b

Reproduced in

Version: 6.2.0.0.alpha1+
Build ID: 0f68e45e2ec6b9fa8c562044e88355d95af0347d
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

[b***@bugs.documentfoundation.org]

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

--- Comment #2 from Gabor Kelemen <***@ubuntu.com> ---
Created attachment 147420
--> https://bugs.documentfoundation.org/attachment.cgi?id=147420&action=edit
Screenshot of the file in Excel and current Calc

It got a lot better in:

Version: 6.3.0.0.alpha0+
Build ID: f3ea5e21bea80004b04edbf0287d4a2e1aaef5d0
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

But some custom formatting is still there, the font size appears larger than in
Excel.

[b***@bugs.documentfoundation.org]

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

Gabor Kelemen <***@ubuntu.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=10
| |8107

--- Comment #3 from Gabor Kelemen <***@ubuntu.com> ---
The incorrect font size problem is probably bug #108107