Description: Excel 2016 shows wrong values of Data Series when the document is exported and opened in LibreOffice Calc 6.2.0.0.beta1++ The same happens when the Column and Line Chart is created with LibreOffice Calc Steps to Reproduce: 1. Create a new document in Microsoft Excel. 2. Fill in with text the first five item in the first column 3. Fill in with numbers the first five item in the second and third column 4. Select A1:C5 range 5. Insert Combo Chart 6. Save the file as XLSX 7. Open the same file in LibreOffice Calc 8. Select File and Save As 9. Name and reload the file 10. Compare the original file opened in Calc and the exported file opened in Calc Actual Results: Y axis of Column and Line Chart in XLSX documents created with Microsoft Excel 2016 shows wrong values of Data Series when the document is exported and opened in LibreOffice Calc 6.2.0.0.beta1++ Expected Results: Y axis of Column and Line Chart should show the same values of Data Series as the original file opened in Calc 6.2.0.0.beta1++ Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 147070 [details] A screenshot showcasing the issue.
Created attachment 147071 [details] An example file
Created attachment 147072 [details] An example file after saved in Calc
Patch in gerrit: https://gerrit.libreoffice.org/#/c/64146/
Reprodcued in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.10; Render: default; Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Jozsef Szakacs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/21399c7378be020e5e43fc07575f46e87e2d607b%5E%21 tdf#121744 XLSX Export Combinated Chart (Column and Line) It will be available in 6.3.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.
Jozsef Szakacs committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/d58d92d72b00f45c56a3b0fe55ca9fd837d244a9%5E%21 tdf#121744 XLSX Export Combinated Chart (Column and Line) It will be available in 6.2.0.2. 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.
A polite ping to Jozsef Szakacs: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks
It's fixed, we just forgot to close it.