Issue 105315 - Secondary Axis Lost when save to Excel format
Summary: Secondary Axis Lost when save to Excel format
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows Vista
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 110613 (view as issue list)
Depends on:
Blocks:
 
Reported: 2009-09-24 01:12 UTC by rsking84
Modified: 2017-02-03 17:09 UTC (History)
2 users (show)

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

Attachments
Export this file to Excel 97/2003 .xls format to see the problem (12.52 KB, text/plain)
2009-09-24 01:13 UTC, rsking84 		no flags Details
Comparison of the imported vs. correct charts (41.00 KB, application/vnd.ms-excel)
2009-09-24 21:35 UTC, rsking84 		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 rsking84 2009-09-24 01:12:34 UTC 
In Windows Vista or Win7, I create an XY scatter chart containing both a primary
and secondary Y axis (choose Insert > Axis, check "secondary y axis.")  Then
choose Insert > Titles > Secondary Y Axis title and type a title.  Save the file
in .ods format.  If the file is subsequently exported in Excel 97-2003 .xls
format, the labels (values) on the secondary Y axis disappear, but the plotting
of the data and secondary y axis title are preserved.

I've observed this in both MS Office 2003 and 2007.

See the attached two files.
Comment 1 rsking84 2009-09-24 01:13:16 UTC 
Created attachment 64924 [details]
Export this file to Excel 97/2003 .xls format to see the problem
Comment 2 kla 2009-09-24 09:34:43 UTC 
duplicate, and see comment at the end:
"Excel charts do not have a subtitle. This object cannot be exported to Excel."

*** This issue has been marked as a duplicate of 46626 ***
Comment 3 rsking84 2009-09-24 21:33:57 UTC 
Maybe I'm misunderstanding, but I don't think the duplicate issue listed here is
the same one at all.  This problem does not have to do with formatting,
positioning, or objects (the Secondary Axis title exports just fine).  The
problem is that the values and scale from the axis disappear.

Excel is fully capable of displaying a secondary Y axis with values and a title,
so I don't see why they shouldn't be exported properly.  In the attachment below
I show a comparison of what the chart looks like when first exported vs. what it
should look like.

NOTE: Make sure to open the .xls in Excel, as the issue doesn't seem to occur if
the file is opened in OpenOffice.
Comment 4 rsking84 2009-09-24 21:35:09 UTC 
Created attachment 64957 [details]
Comparison of the imported vs. correct charts
Comment 5 daniel.rentz 2009-09-25 08:51:18 UTC 
confirmed. Secondary Y axis does not show up in Excel.
Comment 6 oooforum (fr) 2017-02-03 17:09:53 UTC 
*** Issue 110613 has been marked as a duplicate of this issue. ***