Issue 78196

Summary: Creating a chart from non-fitting ranges from more than one sheet does not work
Product: General Reporter: bjoern.milcke
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description bjoern.milcke 2007-06-07 16:23:28 UTC 
1. Create a spreadsheet
2. Add some data on Sheet1 in cells A1:B3
3. Add some data on Sheet2 in cells C2:D4
4. Create a chart using both regions in the second tab (Data Source)
"Sheet1.A1:B3;Sheet2.C2:D4"
=> The chart has two unnamed series

If instead you use C2:D4 also from Sheet1, you only get two series. It is always
difficult to decide what to do with non-aligned data ranges used as "one range
to split up", but at least there shouldn't be any empty series.

Additional Dev Note: It seems like when using ranges from different sheets that
after deletion the chart model is still listener to the ranges. It must remove
as listener when being deleted.
Comment 1 bjoern.milcke 2007-06-07 16:27:39 UTC 
Accepted.
Comment 2 Martin Hollmichel 2007-09-12 13:13:39 UTC 
move to target 3.x according http://wiki.services.openoffice.org/wiki/Target_3x
Comment 3 IngridvdM 2008-07-03 11:39:40 UTC 
change owner
Comment 4 IngridvdM 2008-07-22 14:21:59 UTC 
reset to new