Issue 103147 - ODF, workaround MS-Office bug: charts without chart:plot-area table:cell-range-address are empty
Summary: ODF, workaround MS-Office bug: charts without chart:plot-area table:cell-rang...
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: sgautier.ooo
QA Contact: issues@graphics
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2009-06-26 17:39 UTC by IngridvdM
Modified: 2013-02-24 21:20 UTC (History)
3 users (show)

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

Attachments
example document containing the problem (4.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-26 17:42 UTC, IngridvdM 		no flags Details
how the chart is expected to look after the fix (12.91 KB, image/jpeg)
2009-07-01 12:50 UTC, IngridvdM 		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 IngridvdM 2009-06-26 17:39:10 UTC 
Load the attached file with OOo 3.1. The chart does not show any data.
The reason is that the attribute 'table:cell-range-address' at the 'plot-area'
element is missing. Documents with that bug are created by MS-Office2007sp2.

OpenOffice.org should try to workaround that MS bug and load the chart nevertheless.
Comment 1 IngridvdM 2009-06-26 17:42:05 UTC 
Created attachment 63237 [details]
example document containing the problem
Comment 2 IngridvdM 2009-06-26 18:02:12 UTC 
This issue was originally reported as a part of issue 103076.
Comment 3 IngridvdM 2009-06-26 18:31:01 UTC 
A missing 'table:cell-range-address' at the <chart:plot-area> normally indicates
that a chart has its own data. In that case the data must be provided with a
<table:table> element within the <chart:chart>. But such a <table:table> element
is missing in the attached document. So strictly speaking the document is broken.
To apply to the ODF spec it is not sufficient to only set the attribute
'chart:values-cell-range-address' at the series. The 'table:cell-range-address'
at the <chart:plot-area> must be set also.
This apparent duplication of information has its origin in backwards
compatibility. Early implementations of ODF have not been able to use
independent ranges for the different series. Instead only one single range was
separated into rows or columns. This single range is set at the
'table:cell-range-address' at the <chart:plot-area>.

Even if the attached document is wrong strictly speaking I will try to use the
data from the parent document in such cases to create the expected result for
the users.
Comment 4 IngridvdM 2009-06-30 09:38:50 UTC 
Fixed in CWS chart39.
Comment 5 IngridvdM 2009-07-01 12:50:30 UTC 
Created attachment 63304 [details]
how the chart is expected to look after the fix
Comment 6 IngridvdM 2009-07-01 12:56:06 UTC 
@Sophie, please verify in CWS chart39. Thanks, Ingrid!
Load the attached document ms_office_2007_sp2_corrected_OLE_Ref.ods and look at
the chart. Data from the spreadsheet should be shown within the chart. How it
should look like is illustrated within attached ExpectedDisplay.jpg.
Comment 7 sgautier.ooo 2009-07-02 12:18:53 UTC 
Verified in CWS chart39 - Data are correctly displayed within the chart. Sophie
Comment 8 sgautier.ooo 2009-08-05 14:03:28 UTC 
Verified in DEV300m54 under .deb version - Closing - Sophie