Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetOptionsView.R1C1Reference Property

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

#Declaration

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

See Also