« The new OpenOffice.org Charting Tool Coming in OpenOffice.org 2.3 | Main | Using the Navigator to get around in an OpenOffice Calc spreadsheet »

June 07, 2007


On the issue you have: The approach to take one set of many different ranges that are spread over a document as a whole region that is to split up into columns or rows always yields a lot of problems.

A region like Sheet1.A1:B4;Sheet2.C1:F4 should work as it is almost like one rectangular region. If the data is structured more complexly, you should indeed use the second tab to add your individual ranges for the data series.

However, there is a difference between using both ranges of your example on one sheet or on two. I wrote an Issue ( http://www.openoffice.org/issues/show_bug.cgi?id=78196 ) for that.

Hi Bjoern,

Thanks! I'll take a look at that.


The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog