Table of Contents

XlsFile.GetShapeLinkedCell Method

Returns the cell that is linked to the shape or image. If the object isn't linked, this method will return null. Note that when you change the value in the cell linked to this object, the value of the object will change. Also note that this method applies to shapes like a rectangle or circle, or an image. To get the link of a forms object like a combobox or a radiobutton use ExcelFile.GetObjectLinkedCell instead.

Remarks

Images behave differently from shapes: A linked shape will change its text with the value of the cells. A linked image will change its image, to be an screenshot of the selected range. Finally, a linked object like a combobox you can get with ExcelFile.GetObjectLinkedCell will modify the selected item depending on the linked cell.

Syntax

Namespace: FlexCel.XlsAdapter

public override String GetShapeLinkedCell(Int32 objectIndex, String objectPath)

Parameters

<-> Parameter Type Description
objectIndex Int32 Index of the object (1 based)
objectPath String Index to the child object you want to change the property.
If it is a simple object, you can use String.Empty here, if not you need to get the ObjectPath from ExcelFile.GetObjectProperties(Int32, Boolean)
If it is "absolute"(it starts with "\"), then the path includes the objectIndex, and the objectIndex is not used. An object path of "\1\2\3" is exactly the same as using objectIndex = 1 and objectPath = "2\3"

Returns

The cell address or name which this shape is linked to, or null if it isn't linked.

See also