Issue 111916

Summary: Embedded data source table indices interpreted off-by-one
Product: General Reporter: hardcoder <remid0d0s0>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: 3.3.0 or older (OOo)Keywords: regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
double click the chart -> there should be 3 series with 4 points each none

Description hardcoder 2010-05-29 00:05:04 UTC
I have a <table:table> embedded in a <chart:chart>, using the table as the
source of data for the chart.

Apparently, OO wants the data to start at "B2", not "A1", even if the table has
no header rows/columns.

Although my table is *just* table rows with data in them (as float values +
text), in order to access the data in the table I have to use addresses rooted
at B2, not A1:

<chart:series chart:values-cell-range-address="local-table.B2:.B5">

In addition, Chart ignores the size of the range and uses the entire range of
data. In other words it could be .B2:.B1000 and work the same.

I'm running into a bunch of other idiosyncracies too. Is this "just how it is"
with OO and directly embedded charts/tables? Should I be creating contained
objects instead?
Comment 1 IngridvdM 2010-06-02 10:22:25 UTC
This is an error. It was not detected so far as OOo itself always creates tables
with header row and header column.
To be safe against future changes I would suggest you create also only documents
with header row and header column.
Comment 2 IngridvdM 2010-06-02 10:28:56 UTC
This is broken since OOo 3.0.
Comment 3 IngridvdM 2010-06-02 10:38:02 UTC
Created attachment 69759 [details]
double click the chart -> there should be 3 series with 4 points each
Comment 4 hardcoder 2010-06-02 21:21:58 UTC
Thanks. Using row and column headers is not a problem as a workaround for me.

In regard to my other comment, that the row range is ignored, what is your
observation about that? That is, .B2:.B5 vs. .B2:.B1000, et cetera. I haven't
explored the problems that this might or might not cause me when creating plots
of more than one series, where the don't necessarily cover the entire
range of the x axis.
Comment 5 IngridvdM 2011-02-10 13:10:48 UTC
change prio