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
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.