Andrew Douglas Pitonyak wrote:
Craig Johnson wrote:Hi folks! Just joined the [email protected] mailing list.I'm trying to write some staroffice basic macros to update some charts that display data from weekly updated spreadsheets. I have the macros in place to update the spreadsheet rows with new data but can't find how to access the chart data ranges. I know how to get at them from the Format->Data Ranges popup but I need to change the ranges from within a macro.Anyone know how to access spreadsheet chart data ranges from a macro?Depends on what you need or desire to do...
Hi Andrew,I hope you'll excuse me for bothering you directly with this. I've tried posting on the [email protected] alias but found it to be mostly off-topic rants and/or discussions that have little or nothing to do with using openoffice. I'm getting ready to file what I think is a bug at the api.openoffice.org site but that too seems to be a non-trival task.
Do you remember replying to my question above? You were really the only one who gave any useful feedback! I've recently purchased a copy of your OOME book too and have found it quite useful.
The problem I'm facing now has to do with the chart getRanges and setRanges routines you pointed out in your reply to me. I'm having some difficulty understanding why they do not seem to be working for me and have come to a conclusion that it may actually be a bug (or bugs) in the openoffice code itself.
To illustrate my problem(s) I have tried to encapsulate them in a spreadsheet doc with macros that "test" things. I am hoping to find an expert user to review what I am facing and give me some feedback as to whether I'm doing something wrong or have really encountered an openoffice bug.
The attached spreadsheet doc contains the necessary data and instructions. I would greatly appreciate any feedback you may be able to provide. Eagerly awaiting your response, Craig Johnson
my_chart_data.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
