Description: I created a Calc chart with both a Y axis and an alternate Y axis. The chart looks fine. When I save and re-open the document, the labels for both Y axes overlap each other on the left axis, and the right axis is blank. I cannot fix this problem; I have to re-create the chart from scratch each time I open the document. FILEOPEN Steps to Reproduce: 1. create the chart with a left and right Y axis 2. save the file 3. open the file and note the two axes are merged on the left note that, by definition, I can only provide a defective file, not the original correct file Actual Results: the chart was wrong Expected Results: the two axes should be correct and distinct Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 184874 [details] data and chart that is defective the defective file, with data and defective chart
Created attachment 184877 [details] screen shot of the problem axes
Thank you for your report. I can see the two axes overlapped on the left in the following version: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 69c6f7bccec838b7288a25a29a83b7f782ba7586 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded MS Office doesn't show the tax rate axis at all. I tested using: Microsoft 365 MSO (Version 2212 Build 16.0.15928.20196) 64-bit - Is the original file created in LibreOffice? - Can you please provide an ODS file in which the chart looks good, so we can test saving as XLS? As a general note, if you are creating a new document, I would strongly recommend using ODS, or XLSX if you have to. XLS is an old binary format that we support for compatibility reasons, but saving as ODS is safer. Thank you!
Created attachment 184984 [details] Here is a correct chart in XLSX format for you. Do you need anything else?
[Automated Action] NeedInfo-To-Unconfirmed
Created attachment 185002 [details] example dual-axis chart in ODS file Thank you for the example document. Saving from XLSX to ODS or from XLSX to XLS, no problem: the two axes stay on their correct sides. However, saving from ODS to XLS, the two axes are merged on the left. I'm also attaching an ODS file for easier testing. Steps: 1. Open this ODS attachment 2. Save as XLS Result: Secondary Y axis is overlapped with primary Y axis on the left of the chart. Save as XLSX keeps works, and saving that XLSX as XLS also works. It's only the ODS to XLS that fails. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 69c6f7bccec838b7288a25a29a83b7f782ba7586 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
(In reply to Stéphane Guillou (stragu) from comment #6) > Steps: > 1. Open this ODS attachment > 2. Save as XLS Implicit step 3 is "File > Reload".