Description: When a pie chart is created in Excel 2007 using a column containing labels, this column is not taken into account when opening the file with Libreoffice 6.4.2.2. (instead, labels are "1,2,3,..."). It used to work, I tested with LibreOffice 6.0.7.3 and 5.2.0.4 and it worked fine with the same file. Steps to Reproduce: 1.Open a Xlsx file with a pie chart (having a column for labels) created with Excel 2007. Example here: https://github.com/jmcnamara/XlsxWriter/files/4564212/chart_pie2.xlsx 2.Open it with Libreoffice 6.4.2.2. Actual Results: The labels displayed are "1,2,3" and the column containing labels is ignored. Expected Results: The labels displayed are the values of the column containing labels. Reproducible: Always User Profile Reset: No Additional Info: Version : 6.4.2.2 Build ID : 1:6.4.2-0ubuntu3 Threads CPU : 8; OS : Linux 5.4; UI Render : par défaut; VCL: gtk3; Locale : fr-BE (fr_BE.UTF-8); Langue IHM : fr-FR Calc: threaded
No change after User Profile Reset
(In reply to fdegrave@gmail.com from comment #0) > Example here: > https://github.com/jmcnamara/XlsxWriter/files/4564212/chart_pie2.xlsx Reproduced with this example in 6.4.3: 版本: 6.4.3.2 (x64) Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU 线程: 2; 操作系统: Windows 10.0 Build 18363; UI 渲染: GL; VCL: win; 区域语言: zh-CN (zh_CN); UI 语言: zh-CN Calc: threaded ... as well as 6.3.5: Version: 6.3.5.2 (x64) Build ID: dd0751754f11728f69b42ee2af66670068624673 CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded But can not reproduce in 6.2.8: Version: 6.2.8.2 (x64) Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded
Bibisected using bibisect-win64-6.4 to: URL: https://cgit.freedesktop.org/libreoffice/core/commit/?id=e0b0502516a10181bbd1737b93b38b2bba4c98e8 author: Balazs Varga <balazs.varga991@gmail.com> committer: László Németh <nemeth@numbertext.org> summary: tdf#128016 Chart OOXML Import: fix duplicated category labels Adding Cc: Balazs Varga
Created attachment 160228 [details] Example xlsx Exemple should always be attached, in case link stops working.
After re saving the example file with excel 2016, it's good in: Version: 7.0.0.0.alpha0+ (x64) Build ID: 861b556bb3779242951c03b3f68a32eb8c15db02 CPU szálak: 4; OS: Windows 10.0 Build 17134; Felületmegjelenítés: Skia/Raster; VCL: win; Locale: hu-HU (hu_HU); Felület nyelve: hu-HU Calc: CL Version: 6.4.0.0.alpha0+ (x64) Build ID: e0b0502516a10181bbd1737b93b38b2bba4c98e8 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL Verzió: 6.3.0.4 (x64) Build az.: 057fc023c990d676a43019934386b85b21a9ee99 CPU szálak: 4; OS: Windows 10.0; Felületmegjelenítés: GL; VCL: win; Területi beállítások: hu-HU (hu_HU); Felület nyelve: hu-HU Calc: CL
Created attachment 160258 [details] Example xlsx saved in Excel 2016 (good)
Created attachment 160259 [details] Screenshot of the original document side by side saved in Excel 2007 and Excel 2016
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/47e45d75f7789f0178ea3e1b22ef7b8adc77018e tdf#132594 Chart XLSX import: fix legend entries in pie charts It will be available in 7.0.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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.0.0.0.beta1+ Build ID: 2506d8221dd940dfd93d3d7c183430ba6ba3089d CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Tünde Tóth, thanks for fixing this issue!!!
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/59a896d80feee9f4c25b931c77aee281da189868 tdf#132594 Chart XLSX import: fix legend entries in pie charts It will be available in 6.4.5. 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.