# RulerBar.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.

- **Product:** TX Text Control .NET for Windows Forms
- **Section:** Reference
- **Kind:** Property
- **Introduced:** 26.0
- **Namespace:** `TXTextControl`
- **Package:** `TXTextControl.TextControl.WinForms.SDK` (assembly `TXTextControl.Windows.Forms.dll`, from the private NuGet feed or Text Control Offline Packages)
- **.NET Framework:** reference `TXTextControl.Windows.Forms.dll` from the setup
- **Path:** TX Text Control .NET for Windows Forms > Reference > TXTextControl > RulerBar.FormulaMode Property
- **542 words**
- **Web URL:** https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/formulamode-property/
- **LLMs URL:** https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/formulamode-property/llms.txt
- **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/formulamode-property/llms-full.txt

---

### 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](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/textcontrol/formulareferencestyle-property/llms-full.txt) property cell references are shown either in the A1 or in the R1C1 notation. This property has no effect when the [BorderStyle](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/borderstyle-property/llms-full.txt) property has been set to `RulerBarBorderStyle.Simple3D` or `RulerBarBorderStyle.Fixed3D`.

### Syntax

```csharp
public RulerBarFormulaMode FormulaMode { get; set; }
```

```vbnet
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.

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

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

---

## Nearby

- **Previous:** [RulerBar.EnablePageMargins Property](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/enablepagemargins-property/llms-full.txt)
- **Next:** [RulerBar.ReadOnly Property](https://docs.textcontrol.com/tx-text-control-dotnet-winforms/reference/txtextcontrol/rulerbar/readonly-property/llms-full.txt)