Description: When exporting a combined chart with X and Y axes as primary and Y as secondary to XLSX, the primary X axis visibility setting is lost. Steps to Reproduce: 1. Open attachment #149703 [details] 2. Click on the chart to edit it, right click and select Insert/remove axes 3. In the Axes window observe that the primary X and Y axes and secondary Y axis is turned on. 4. Save the file as XLSX and reopen it Actual Results: In the Axes window the primary X axis is no longer checked, neither is the secondary Y. Expected Results: The same axes are enabled as in ODS format. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 149714 [details] Screenshot of the original and exported document side by side in Calc
Thank you for reporting the bug. I cannot reproduce the bug in Version: 6.3.0.0.alpha0+ Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Hello Thank you for reporting the bug. Primary X axis and Secondary Y axis settings are lost after saving the file as .xlsx format I can confirm that the bug is present in Version: 6.2.1.2 (x64) Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL Version: 6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-08_00:38:10 Locale: en-US (en_US); UI-Language: en-US Calc: CL
Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.15; Render: default; and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
The old behaviour was that secondary X axis got turned on and nothing got turned off. Bibisected the change on Linux with 50max to https://gerrit.libreoffice.org/plugins/gitiles/core/+/1573315ec978b7f53a8babeb7ad44e104896209e%5E!/ export each axis only once non-deleted, related tdf#84347 At least it is a code pointer.
Probably could help here too. Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/9be1b6cf5b97727135c7f5e48c971edd8dc45e70%5E%21 tdf#123828 XLSX combined chart export: fix order of axis types 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.
Verified, thanks! Arch Linux 64-bit Version: 6.3.0.0.alpha0+ Build ID: d7f4f5650dd2c7fe1ccec50efd806e695b8bc18a CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 17 April 2019