Issue 102321 - Labels on imported graphs display incorrectly
Summary: Labels on imported graphs display incorrectly
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-05-28 10:12 UTC by brianpickles
Modified: 2014-02-28 11:30 UTC (History)
3 users (show)

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

xls file that shows chart label formatting errors (88.21 KB, application/x-compressed)
2009-05-28 10:14 UTC, brianpickles
no flags Details
scalc (46.44 KB, text/plain)
2009-09-18 02:37 UTC, rpadmanabhan
no flags Details
ms office excel (46.37 KB, text/plain)
2009-09-18 02:38 UTC, rpadmanabhan
no flags Details
legend created (59.34 KB, text/plain)
2009-09-18 02:51 UTC, rpadmanabhan
no flags Details
Excel 2010 vs. Calc 4.1 (408.26 KB, image/jpeg)
2014-02-28 11:30 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description brianpickles 2009-05-28 10:12:51 UTC
Various graphs were create in Excel. When the xls file is opened in OpenOffice 
3.1.0 the graphs do not display correctly. Z Axis not displayed correctly in 3D 
bar chart - labels are wrong. Legend not formatted correctly on line graph - shape 
of box is wrong (labels displayed in horizontal list rather than vertical list)  
and labels are wrong. See attached xls file for examples.
Comment 1 brianpickles 2009-05-28 10:14:25 UTC
Created attachment 62608 [details]
xls file that shows chart label formatting errors
Comment 2 kla 2009-06-03 09:18:26 UTC
@DR: i think thats are known issues, right?
Comment 3 rpadmanabhan 2009-09-18 02:36:44 UTC
Raji Padmanabhan, 091709
Could successfully replicate the bug in Vista in build 3.1. 

Viewed the graphs created in MS Office Excel in OOo. The legend appears to be
different in OOo. OOo scalc uses its convention for the legend. It does not
retain the legend created in the original xls document created in MSOffice.

In 2D also, it  does not represent the negative values in the graph - basically
in the 4th coordinate of the graph. 

The same issue can also be observed while opening the 3D graphs.Z Axis not
displayed correctly in 3D. In bar charts - labels are wrong. 

See attached figures to see how OOo calc does not show negative values in the graph.
Comment 4 rpadmanabhan 2009-09-18 02:37:55 UTC
Created attachment 64823 [details]
Comment 5 rpadmanabhan 2009-09-18 02:38:25 UTC
Created attachment 64824 [details]
ms office excel
Comment 6 rpadmanabhan 2009-09-18 02:49:02 UTC
Raji Padmanabhan 091709

As a follow  up test, created a chart in OOo scalc to see if the legend was
being created. 

Find attached the document. 

Comment 7 rpadmanabhan 2009-09-18 02:51:08 UTC
Created attachment 64825 [details]
legend created
Comment 8 tora3 2011-03-07 14:16:34 UTC
rpadmanabhan: There are difficulties to confirm your snapshots.
Could you alter a MIME type of the snapshot files you had attached? 

I am not sure, but we have migrated our bug tracking system from IssueTracker 
to Bugzilla, so it seems possible to modify a MIME type any time.

To alter it, probably, 
 - click on the links named Details right next to the attachment. 
 - fill the MIME type with image/jpeg, instead of text/plain
 - click on the button Submit

Thanks in advance.
Comment 9 Edwin Sharp 2014-02-28 11:30:09 UTC
Created attachment 82753 [details]
Excel 2010 vs. Calc 4.1
Comment 10 Edwin Sharp 2014-02-28 11:30:46 UTC
Confirmed with
AOO410m14(Build:9760)  -  Rev. 1572807
Win 7