FormulaMode Property

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

• C#
• VB.NET

​public RulerBarFormulaMode FormulaMode { get; set; }

​Public Property FormulaMode As RulerBarFormulaMode

Members

Examples

The following example uses the FormulaMode property and sets its value to Auto. This means ruler_bar will show cell references when the text input position is in a table cell containing a formula.

• C#
• VB.NET

​TXTextControl.RulerBar  rulerBar = new TXTextControl.RulerBar();

rulerBar.Alignment   = TXTextControl.RulerBarAlignment.Top;
rulerBar.BorderStyle = TXTextControl.RulerBarBorderStyle.Flat;
rulerBar.FormulaMode = TXTextControl.RulerBarFormulaMode.Auto;

​Dim rulerBar As TXTextControl.RulerBar = New TXTextControl.RulerBar()

rulerBar.Alignment   = TXTextControl.RulerBarAlignment.Top
rulerBar.BorderStyle = TXTextControl.RulerBarBorderStyle.Flat
rulerBar.FormulaMode = TXTextControl.RulerBarFormulaMode.Auto

End Sub