Aspose::Cells::Drawing::Shape::SetLinkedCell method

void Aspose::Cells::Drawing::Shape::SetLinkedCell(const U16String &value)

U16String val = u"A1";
if (shape.GetLinkedCell() == u"$B$6")
    shape.SetLinkedCell(val);

void Aspose::Cells::Drawing::Shape::SetLinkedCell(const char16_t *value)

if (shape.GetLinkedCell() == u"$B$6")
    shape.SetLinkedCell(u"A1");

void Aspose::Cells::Drawing::Shape::SetLinkedCell(const U16String &formula, bool isR1C1, bool isLocal)

//After executing the code below, a ScrollBar object is created in the generated file. As you drag the slider, the value is displayed in cell A12.

//ActiveX Controls
//Aspose.Cells.Drawing.Shape scrollBar = book.GetWorksheets().Get(0).GetShapes().AddActiveXControl( Aspose.Cells.Drawing.ActiveXControls.ControlType::ScrollBar,2, 0, 2, 0, 30, 130);

//Form Controls
Shape scrollBar = book.GetWorksheets().Get(0).GetShapes().AddScrollBar(2, 0, 2, 0, 130, 30);

//Sets the range linked to the control's value.
U16String val = u"$A$12";
scrollBar.SetLinkedCell(val, false, true);

void Aspose::Cells::Drawing::Shape::SetLinkedCell(const char16_t *formula, bool isR1C1, bool isLocal)

//After executing the code below, a ScrollBar object is created in the generated file. As you drag the slider, the value is displayed in cell A12.

//ActiveX Controls
//Aspose.Cells.Drawing.Shape scrollBar = book.GetWorksheets().Get(0).GetShapes().AddActiveXControl( Aspose.Cells.Drawing.ActiveXControls.ControlType::ScrollBar,2, 0, 2, 0, 30, 130);

//Form Controls
Shape scrollBar = book.GetWorksheets().Get(0).GetShapes().AddScrollBar(2, 0, 2, 0, 130, 30);

//Sets the range linked to the control's value.
scrollBar.SetLinkedCell(u"$A$12", false, true);