|
A Calc sheet contains myDiagram which refers to
A1:B31 cells.
myDiagram.ChartRangeAddress sends the following string : 'mySheet'.$A$1:.$B$31 I want my macro to add a new curve in it, with
datas located in A32:C33.
I used myDiagram.ChartRangeAddress=
"'mySheet'.$A$1:.$C$33" and multiple variations on this
string.
myDiagram.ChartRangeAddress is correctly changed but the diagram itself refers to the lone A1 cell or various ref errors. If ChartRangeAddress is the right property to use, how should its argument be set ? |
- [api-dev] macro to add a new curve in a Calc diagram ch'prof
- Re: [api-dev] macro to add a new curve in a Calc d... Stephan Wunderlich
