Issue 111916 - Embedded data source table indices interpreted off-by-one
Summary: Embedded data source table indices interpreted off-by-one
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2010-05-29 00:05 UTC by hardcoder
Modified: 2013-09-25 20:41 UTC (History)
1 user (show)

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

Attachments
double click the chart -> there should be 3 series with 4 points each (12.40 KB, application/vnd.oasis.opendocument.text)
2010-06-02 10:38 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 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 series..es don't necessarily cover the entire
range of the x axis.
Comment 5 IngridvdM 2011-02-10 13:10:48 UTC 
change prio