Ask Your Question
0

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: https://wiki.documentfoundation.org/images/2/27/CG4012-CalcMacros.pdf nor in the old OO documentation, nor on Google. [EDIT] To be precise, much information is here: http://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Structure_of_Charts 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
0

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

Comments

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: http://wiki.openoffice.org/wiki/Documentation/DevGuide/Charts/Common_Parts_of_all_Chart_Types and a different section for special chart (statistics, 3-D, pie, and stock) parts: http://wiki.openoffice.org/wiki/Documentation/DevGuide/Charts/Features_of_Special_Chart_Types</p<>>

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

Question Tools

1 follower

Stats

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

Seen: 1,265 times

Last updated: Jul 20 '13