Description: When creating a combined chart in ODS format the visibility of the Y axis main grid visibility is turned on by default. Saving the file to XLSX format loses this setting. Steps to Reproduce: 1. Open attachment #149703 [details] 2. Double click on the chart to edit it and observe that the Horizontal grid is visible 3. Save the file to XLSX and reopen it Actual Results: Double click on the chart in the XLSX file and observe that the Horizontal grid is not visible. Clicking on the corresponding icon of the Chart toolbar turns it back on. Expected Results: The Horizontal grid should be visible in the XLSX file too if it was originally turned on. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 149710 [details] The example file saved by Calc
Created attachment 149711 [details] Screenshot of the original and exported document side by side in Calc.
Thank you for reporting the bug. When I try to open the file in writer for the first time,the horizontal grid is missing in the chart. 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
Please attach source .ods file. Thank you
Repro. Already in 3.3.0 Possibly a dupe of bug 114181, but that one has an xlsx coming from Excel as the source. Version: 6.3.0.0.alpha0+ (x64) Build ID: 9956cf0692058414ef3efdb0e8058fbb0b39f6bc CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-04_02:20:31 Locale: fi-FI (fi_FI); UI-Language: en-US Calc: threaded (In reply to raal from comment #4) > Please attach source .ods file. Thank you The .ods file is linked in the description.
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