NamedRange.ReadingOrder Property
Gets or sets the reading order for the NamedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property ReadingOrder As Integer
int ReadingOrder { get; set; }
Property Value
Type: System.Int32
One of the following values: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.
Remarks
Some of these constants might not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed.
Examples
The following code example uses the ReadingOrder property to reverse the reading order of a NamedRange, if the current language that is selected or installed supports it.
This example is for a document-level customization.
Private readingOrderRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub ReverseReadingOrder()
readingOrderRange = Me.Controls.AddNamedRange( _
Me.Range("C1"), "readingOrderRange")
If Me.readingOrderRange.ReadingOrder = _
Fix(Excel.Constants.xlRTL) Then
Me.readingOrderRange.ReadingOrder = _
Fix(Excel.Constants.xlLTR)
Else
Me.readingOrderRange.ReadingOrder = _
Fix(Excel.Constants.xlRTL)
End If
End Sub
Microsoft.Office.Tools.Excel.NamedRange readingOrderRange;
private void ReverseReadingOrder()
{
readingOrderRange = this.Controls.AddNamedRange(
this.Range["C1"], "readingOrderRange");
if (this.readingOrderRange.ReadingOrder ==
(int)Excel.Constants.xlRTL)
{
this.readingOrderRange.ReadingOrder =
(int)Excel.Constants.xlLTR;
}
else
{
this.readingOrderRange.ReadingOrder =
(int)Excel.Constants.xlRTL;
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.