Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

As far as I can understand you are not talking of named ranges but of named objects.
What do you expect a "linked OLE object" to be or to be able of?
Anyway it will only be an O​bject L​inked to a software component of LibO and E​mbedded into a document.

Any chart gets a name like "Object 1" automatically when it is created. It is accessible under this name e.g. inside the Calc document by the API via the .Charts property. Manipulating this name is useless.

Each chart is also inserted into the respective DrawPage for rendering/viewing purposes using a special kind of shape. It's only this shape you can set and edit the name of via the UI.

If you copy the chart from a Calc sheet and paste it into a slide (or elsewhere) the linkage to its data ranges inside the Calc sheets is broken. The chart object then contains the data itself in special tables. When a chart is pasted also probable naming conflicts must automatically be resolved. I don't think there is still any rudiment then of a name you gave in advance of the Copy/Paste.

I do not know a way to retain or to re-establish links to the now external data. If you find one, please report here.
(I wouldn't actually expect there is one.)

As far as I can understand you are not talking of named ranges but of named objects.
What do you expect a "linked OLE object" to be or to be able of?

Anyway it will only be an O​bject L​inked to a software component of LibO and E​mbedded into a document.

Any chart gets a name like "Object 1" automatically when it is created. It is accessible under this name e.g. inside the Calc document by the API via the .Charts property. Manipulating this name is useless.

Each chart is also inserted into the respective DrawPage for rendering/viewing purposes using a special kind of shape. It's only this shape you can set and edit the name of via the UI.

If you copy the chart from a Calc sheet and paste it into a slide (or elsewhere) the linkage to its data ranges inside the Calc sheets is broken. The chart object then contains the data itself in special tables. When a chart is pasted also probable naming conflicts must automatically be resolved. I don't think there is still any rudiment then of a name you gave in advance of the Copy/Paste.

I do not know a way to retain or to re-establish links to the now external data. If you find one, please report here.
(I wouldn't actually expect there is one.)

As far as I can understand you are not talking of named ranges but of named objects.
What do you expect a "linked OLE object" to be or to be able of?

Anyway it will only be an O​bject L​inked to a software component of LibO and E​mbedded into a document.

Any chart gets a name like "Object 1" automatically when it is created. It is accessible under this name e.g. inside the Calc document by the API via the .Charts property. Manipulating this name is useless.

Each chart is also inserted into the respective DrawPage for rendering/viewing purposes using a special kind of shape. It's only this shape you can set and edit the name of via the UI.

If you copy the chart from a Calc sheet and paste it into a slide (or elsewhere) the linkage to its data ranges inside the Calc sheets is broken. The chart object then contains the data itself in special tables. When a chart is pasted also probable naming conflicts must automatically be resolved. I don't think there is still any rudiment then of a name you gave in advance of the Copy/Paste.

I do not know a way to retain or to re-establish links to the now external data. If you find one, please report here.
(I wouldn't actually expect there is one.)

one.)

To be able to update a chart shown in a slide (or a Writer documenr) I woul need to link to the Calc document, and to adjust the OLE object then to only show the chart. I can update then using the 'Edit Links to External Data' tool.

As far as I can understand you are not talking of named ranges but of named objects.
What do you expect a "linked OLE object" to be or to be able of?

Anyway it will only be an O​bject L​inked to a software component of LibO and E​mbedded into a document.

Any chart gets a name like "Object 1" automatically when it is created. It is accessible under this name e.g. inside the Calc document by the API via the .Charts property. Manipulating this name is useless.

Each chart is also inserted into the respective DrawPage for rendering/viewing purposes using a special kind of shape. It's only this shape you can set and edit the name of via the UI.

If you copy the chart from a Calc sheet and paste it into a slide (or elsewhere) the linkage to its data ranges inside the Calc sheets is broken. The chart object then contains the data itself in special tables. When a chart is pasted also probable naming conflicts must automatically be resolved. I don't think there is still any rudiment then of a name you gave in advance of the Copy/Paste.

I do not know a way to retain or to re-establish links to the now external data. If you find one, please report here.
(I wouldn't actually expect there is one.)

To be able to update a chart shown in a slide (or a Writer documenr) I woul would need to link to the Calc document, and to adjust the OLE object then to only show the chart. I can update then using the 'Edit Links to External Data' tool.

Automatic update "every ... seconds" should also be possible, but I would dissuade of.

As far as I can understand you are not talking of named ranges but of named objects.
What do you expect a "linked OLE object" to be or to be able of?

Anyway it will only be an O​bject L​inked to a software component of LibO and E​mbedded into a document.

Any chart gets a name like "Object 1" automatically when it is created. It is accessible under this name e.g. inside the Calc document by the API via the .Charts property. Manipulating this name is useless.

Each chart is also inserted into the respective DrawPage for rendering/viewing purposes using a special kind of shape. It's only this shape you can set and edit the name of via the UI.

If you copy the chart from a Calc sheet and paste it into a slide (or elsewhere) the linkage to its data ranges inside the Calc sheets is broken. The chart object then contains the data itself in special tables. When a chart is pasted also probable naming conflicts must automatically be resolved. I don't think there is still any rudiment then of a name you gave in advance of the Copy/Paste.

I do not know a way to retain or to re-establish links to the now external data. If you find one, please report here.
(I wouldn't actually expect there is one.)

To be able to update a chart shown in a slide (or a Writer documenr) document) I would need to link to the Calc document, and to adjust the OLE object then to only show the chart. I can update then using the 'Edit Links to External Data' tool. Automatic update "every ... seconds" should also be possible, but I would dissuade of.