Issue 115115 - second y-axis disappears/ merges with first y axis when saving as .xls
Summary: second y-axis disappears/ merges with first y axis when saving as .xls
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOO330m11
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-10-18 19:10 UTC by oliver1804
Modified: 2013-01-29 21:51 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file as .odf (everything works fine) (14.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-18 19:12 UTC, oliver1804
no flags Details
file as .xls(bug appears) (9.50 KB, text/plain)
2010-10-18 19:13 UTC, oliver1804
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description oliver1804 2010-10-18 19:10:15 UTC
produce a calc table with 3 columns (1x X-values, 2x Y-values)

make a XY-diagram with 2 y-axes and relate 1 of the columns to the 2nd y-axis

1. save as .ods
2. save as .xls
(everything o.k. until now)
3. close the .xls
4. open the .xls again
(the 2nd y-axis isn't where it should be but is placed o n the 1st y-axis)
Comment 1 oliver1804 2010-10-18 19:12:18 UTC
Created attachment 72096 [details]
file as .odf (everything works fine)
Comment 2 oliver1804 2010-10-18 19:13:01 UTC
Created attachment 72097 [details]
file as .xls(bug appears)
Comment 3 r4zoli 2010-10-18 20:12:58 UTC
I can confirm it on win7.
When you saved to xls the secondary axis went to the first Y axis.

If you open xls file and Chart, you can remove secondary axis in edit mode.
If you add secondary Y axis again it will be placed over on first Y axis.
Comment 4 r4zoli 2010-10-18 20:21:24 UTC
I can confirm on linux, tested on ubuntu 10.10 with OOO330m10.
Change OS to all.