Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Embedded data source table indices interpreted off-by-one|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||3.3.0 or older (OOo)||Keywords:||regression|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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