Gets or sets a value specifying whether the ruler bar shows cell references when the current input position is in a table cell. Depending on the TextControl.FormulaReferenceStyle property cell references are shown either in the A1 or in the R1C1 notation. This property has no effect when the BorderStyle property has been set to RulerBarBorderStyle.Simple3D or RulerBarBorderStyle.Fixed3D.

Introduced: X16.

Syntax

public RulerBarFormulaMode FormulaMode { get; set; }
Public Property FormulaMode As RulerBarFormulaMode

Members

Member Description
None Default. The ruler bar does not show cell references.
Always The ruler bar shows cell references when the text input position is in a table call. When the input position changes to another cell, all references are shown relative to this new cell.
Auto The ruler bar only shows cell references when the text input position is in a table cell containing a formula.
Fixed The ruler bar shows cell references relative to the cell which contains the text input position when this mode is switched on. When the input position changes to another cell, all references remain relative to the first cell.