Bug 153184

Summary:	Secondary Y axis moves to left after save as XLS from ODS
Product:	LibreOffice	Reporter:	jon bondy <jon>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	stephane.guillou
Priority:	medium	Keywords:	filter:xls
Version:	7.4.3.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	90486
Attachments:	data and chart that is defective screen shot of the problem axes Here is a correct chart in XLSX format for you. Do you need anything else? example dual-axis chart in ODS file

Description jon bondy 2023-01-24 13:44:00 UTC

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

Comment 1 jon bondy 2023-01-24 13:46:28 UTC

Created attachment 184874 [details]
data and chart that is defective

the defective file, with data and defective chart

Comment 2 jon bondy 2023-01-24 13:47:29 UTC

Created attachment 184877 [details]
screen shot of the problem axes

Comment 3 Stéphane Guillou (stragu) 2023-01-28 23:20:13 UTC

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!

Comment 4 jon bondy 2023-01-29 00:05:04 UTC

Created attachment 184984 [details]
Here is a correct chart in XLSX format for you.  Do you need anything else?

Comment 5 QA Administrators 2023-01-29 03:24:14 UTC Comment hidden (obsolete)

[Automated Action] NeedInfo-To-Unconfirmed

Comment 6 Stéphane Guillou (stragu) 2023-01-29 20:36:59 UTC

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

Comment 7 Stéphane Guillou (stragu) 2023-01-29 20:42:01 UTC

(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".