Ask Your Question

What's the object hierarchy inside ThisComponent.Sheets(i).Charts? [closed]

asked 2013-07-18 13:27:05 +0200

daeh2gi gravatar image

updated 2013-07-18 14:29:45 +0200

I'm trying to write a macro using VB, Calc to make changes to a chart, but I couldn't find information on this subject here: nor in the old OO documentation, nor on Google. [EDIT] To be precise, much information is here: but not about data ranges.

I've made educated guessings, but that's not enough.

Thanks a lot to anyone willing to answer. :)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-04 02:33:32.613588

1 Answer

Sort by » oldest newest most voted

answered 2013-07-19 12:48:49 +0200

oweng gravatar image

updated 2013-07-20 02:54:48 +0200

I would suggest having a look at the Spreadsheets Documents and Charts parts of the AOO Developer's Guide. I am not sure there is an LO equivalent of this level of detail on an LO site somewhere yet, but if there is I am sure someone will chime in and set me straight. The module chart of the LO API appears to be the object you require. Evidently data series are termed "rows" in the API, so you will need to use something like ChartDataArray or ChartDataRowProperties I imagine.

edit flag offensive delete link more


Thank you for your answer. I looked around your link but I couldn't find information about the dataserie ranges inside a chart. Hope I searched well...

daeh2gi gravatar imagedaeh2gi ( 2013-07-19 22:40:59 +0200 )edit

Sorry. I misread the chart part of your question. I will add a link to the Chart section of the AOO Dev Guide. What type of chart are you using? I am not familiar with using the API so can only offer general help in this respect.

oweng gravatar imageoweng ( 2013-07-20 02:48:50 +0200 )edit

It is a line chart, but (I guess) the data series ranges should not depend on the data type (maybe). Thanks!

daeh2gi gravatar imagedaeh2gi ( 2013-07-20 07:38:59 +0200 )edit

I asked as there is a section of common chart parts: and a different section for special chart (statistics, 3-D, pie, and stock) parts:</p<>>

oweng gravatar imageoweng ( 2013-07-20 08:41:21 +0200 )edit

Question Tools

1 follower


Asked: 2013-07-18 13:27:05 +0200

Seen: 1,265 times

Last updated: Jul 20 '13