Description: Align Data series changes from Secondary Y axis to Primary Y axis when the document is saved as XLSX with LibreOffice Calc 6.3.0.0.alpha0+. Steps to Reproduce: 1. Create a new document in LibreOffice Calc 6.3.0.0.alpha0+. 2. Insert a Line Chart with Points and Lines. 3. Change the Align of the first Data Series to Secondary Y axis. 4. Save the file as ODS. 5. Save the file as XLSX. 6. Compare the ODT and the XLSX file opened in LibreOffice Calc 6.3.0.0.alpha0+. 7. View the attaches screenshot. 8. Notice, that Secondary axis changes to Primary axis. Actual Results: Align Data series changes from Secondary Y axis to Primary Y axis. Expected Results: Align Data series should be Secondary Y axis. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.3.0.0.alpha0+ Build ID: ade1df0948563b532a5d293c31d46a4f042559ee CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Created attachment 150439 [details] Example ODS file
Created attachment 150440 [details] Example file saved in XLSX format
Created attachment 150441 [details] Screenshot
Confirmed with Version: 6.3.0.0.alpha0+ Build ID: 210ed60686009128bc772af6ba41650ad17d40e1 CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/ad363fd42e439b43c57b6541988234fbaf1ddb30%5E%21 tdf#124463 XLSX export: fix splitDataSeriesByAxis 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.
Also reproduced in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)