# TextControl.FormulaReferenceStyle Property

> Gets or sets a value determining how references to table cells in formulas are specified. Supported are the A1 and the R1C1 notation. The A1 notation specifies a table cell with a column letter and a row number, for example B3 refers to the table cell in the third row and the second column. The R1C1 notation addresses a table cell with a row number and a column number, for example R3C2 refers to the table cell in the third row and the second column. Relative addresses can be expressed with square brackets. R[-3]C[-2]. The numbers inside the square brackets show how many rows or columns the cell is relative to itself. Negative row numbers mean that the referenced cell is above the cell containing the formula. Negative column numbers mean that the referenced cell is to the left of the cell containing the formula.

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

---

### Description

Gets or sets a value determining how references to table cells in formulas are specified. Supported are the A1 and the R1C1 notation. The A1 notation specifies a table cell with a column letter and a row number, for example B3 refers to the table cell in the third row and the second column. The R1C1 notation addresses a table cell with a row number and a column number, for example R3C2 refers to the table cell in the third row and the second column. Relative addresses can be expressed with square brackets. R\[-3\]C\[-2\]. The numbers inside the square brackets show how many rows or columns the cell is relative to itself. Negative row numbers mean that the referenced cell is above the cell containing the formula. Negative column numbers mean that the referenced cell is to the left of the cell containing the formula.

### Syntax

```csharp
public FormulaReferenceStyle FormulaReferenceStyle { get; set; }
```

```vbnet
Public Property FormulaReferenceStyle As FormulaReferenceStyle
```

### Members

| Value | Description |
|---|---|
| A1 | A table cell in formulas is addressed with a column letter and a row number. |
| R1C1 | A table cell in formulas is addressed with a column number and a row number. |

### Examples

The following example uses `TextControl.FormulaReferenceStyle` to configure formula reference style as part of the text control workflow. The configured value is checked before the workflow continues.

```csharp
textControl.FormulaReferenceStyle = FormulaReferenceStyle.R1C1;
Console.WriteLine($"Formula Reference Style used by Text Control: {textControl.FormulaReferenceStyle}");
```

```vbnet
textControl.FormulaReferenceStyle = FormulaReferenceStyle.R1C1
Console.WriteLine($"Formula Reference Style used by Text Control: {textControl.FormulaReferenceStyle}")
```

---

## Nearby

- **Previous:** [TextControl.FormFieldTextChanged Event](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/formfieldtextchanged-event/llms-full.txt)
- **Next:** [TextControl.FrameClicked Event](https://docs.textcontrol.com/tx-text-control-dotnet-wpf/reference/txtextcontrol-wpf/textcontrol/frameclicked-event/llms-full.txt)