Issue 74062 - New Chart: Loading binary Documents with Charts getting Data form other Sheet fails
Summary: New Chart: Loading binary Documents with Charts getting Data form other Sheet...
Status: CLOSED IRREPRODUCIBLE
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: bjoern.milcke
QA Contact: issues@graphics
URL:
Keywords: new_implementation
Depends on:
Blocks:
 
Reported: 2007-01-31 13:33 UTC by bjoern.milcke
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

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

Attachments
Bugdoc (72.50 KB, application/vnd.stardivision.calc)
2007-01-31 13:51 UTC, bjoern.milcke 		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 bjoern.milcke 2007-01-31 13:33:44 UTC 
Load a binary document (see attached one) with the property: it contains a chart
that uses data from a sheet on the "right hand" of the one the chart is on.
(E.g. chart on sheet1 getting data from sheet2)

=> The data comes only from sheets left of the chart or the one the chart is on.
The reason for this is that binfilter exports the document as a flat XML file,
so when the chart is being read only the sheets up to the current one have been
loaded.

The used data of a chart are stored in an XML-range string like
"Sheet2.$A$5:.$C$12 Sheet3.$D$5:.$E$12". The call to
XRangeXMLConversion::convertRangeFromXML() (the implementation is the same as
the XDataProvider in Calc) yields (assuming that the chart is on Sheet1)
"$Sheet1.$A$5:C12;$Sheet1.$D$5:E12".

The problem is that the not-yet-existing sheets are converted to Sheet1. It
looks also not correct that the $s are only replaced at the last part of the
range and not the first one.
Comment 1 bjoern.milcke 2007-01-31 13:34:56 UTC 
Sorry, forgot to say that this affects the new chart only. So, currently only
appears on the CWS chart2mst3.
Comment 2 bjoern.milcke 2007-01-31 13:51:55 UTC 
Created attachment 42610 [details]
Bugdoc
Comment 3 bjoern.milcke 2007-02-23 15:17:07 UTC 
taking back.
Comment 4 bjoern.milcke 2007-02-23 15:17:38 UTC 
Turns out that this a quite a big task to implement. As this is not a very
common scenario and the binary format is also no longer very common, I think it
doesn't make sense to put so much time in fixing this.
Comment 5 bjoern.milcke 2007-02-23 15:18:32 UTC 
closing