Andrew Douglas Pitonyak wrote:
Craig Johnson wrote:

What I have learned since yesterday is that if I select the chart and look at Format->Data Ranges through the GUI then do the Chart.getRanges I get an array with the expected elements in it. In fact all that's really necessary is to select/deselect the chart in the GUI and the getRanges works as expected.

Ummm. Really? OK, now that is strange! I would mention that specifically on the dev list...

Do you know of a way to do a select/deselect of a chart from a macro?

I just might. The following might work:

ThisComponent.CurrentController.select(Chart)

Unfortunately this seems to cause a runtime exception error

    Type:com.sun.star.lang.illegalArgumentException

when done as

    Dim Sheet as Object
    Sheet = getNamedSheet("My_Chart")

    Dim Charts as Object
    Dim Chart as Object

    Charts = Sheet.getCharts()
    Chart = Charts.getByIndex(0)

    ThisComponent.CurrentController.select(Chart)


As you suggested I'll try asking on the [EMAIL PROTECTED] alias.

Thanks again for all your help!

Craig

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to