See attachment #146447 [details] and attachment 146448 [details] 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 22.214.171.124.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
Chart data labels cover each other when the document is opened in LibreOffice Calc 126.96.36.199.alpha1+.
Chart data labels should have the same position as the original file as when the document is opened in Microsoft Excel 2010
Build ID: 2cef68a605494bcef0388201b1058c95788c45a8
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: hu-HU (hu_HU); Calc: threaded
It might get fixed if bug 121279 is fixed
The label import got implemented in https://cgit.freedesktop.org/libreoffice/core/commit/?id=790f9abeb1a1167ad5ab84c5fb855b36669c125b
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
Created attachment 147420 [details]
Screenshot of the file in Excel and current Calc
It got a lot better in:
Build ID: f3ea5e21bea80004b04edbf0287d4a2e1aaef5d0
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
But some custom formatting is still there, the font size appears larger than in Excel.
The incorrect font size problem is probably bug #108107
Created attachment 164088 [details]
Screenshot of the original document in Excel and current nightly
Looks better in todays nightly from 2020-08-08 03:16:08 after bug #134977 was fixed.
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#121281 pie chart: improve data label position
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Created attachment 168528 [details]
Screenshot of the unit test document before and after the fix
Commit https://gerrit.libreoffice.org/c/core/+/107829 has fixed the original document http://bugs.documentfoundation.org/attachment.cgi?id=146447 reported here, but
the unit test document of the commit is still not perfect, because the top border of the chart is higher, than the chart area. Likely we need to fix that, too.
Version: 188.8.131.52.alpha0+ (x64)
Build ID: 96bafa464ebdbce3ef04bec9beae5e745bb37794
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU