TdxSpreadSheetOptionsView.R1C1Reference Property

Specifies if the control uses the “R1C1” cell reference style in all worksheets.

Declaration

property R1C1Reference: Boolean read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

Use this property to switch between the “A1” and “R1C1” reference styles. Set the property to True to use the “R1C1” reference style instead of “A1” (by default):

Value	Example	Absolute Reference Example	Partially Relative Reference Example	Relative Reference Example
True		R2C1	R[2]C1 or R2C[1]	R[2]C[1]
False		$A$2	A$2 or $A2	A2

The default R1C1Reference property value is False.