Description

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.

Syntax

public RulerBarFormulaMode FormulaMode { get; set; }

Public Property FormulaMode As RulerBarFormulaMode

Members

Value	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.

Examples

The following example uses RulerBar.FormulaMode to configure formula mode as part of the ruler bar workflow. The change is then applied to the active document or user interface.

rulerBar.FormulaMode = RulerBarFormulaMode.Auto;
rulerBar.Update();

rulerBar.FormulaMode = RulerBarFormulaMode.Auto
rulerBar.Update()