set_linked_cell方法
set_linked_cell
设置链接到控件值的范围。
def set_linked_cell(self, formula, is_r1c1, is_local):
...
范围 | 类型 | 描述 |
---|---|---|
formula | str | 与控件值关联的范围。 |
is_r1c1 | bool | 公式是否需要格式化为R1C1。 |
is_local | bool | 公式是否需要按区域设置格式化。 |
例子
# 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.Worksheets[0].Shapes.AddActiveXControl( Aspose.Cells.Drawing.ActiveXControls.ControlType.ScrollBar,2, 0, 2, 0, 30, 130);
# Form Controls
scrollBar = book.worksheets[0].shapes.add_scroll_bar(2, 0, 2, 0, 130, 30)
# Sets the range linked to the control's value.
scrollBar.set_linked_cell("$A$12", False, True)