NamedRange.ReadingOrder Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the reading order for the NamedRange control.

public:
 property int ReadingOrder { int get(); void set(int value); };

public int ReadingOrder { get; set; }

member this.ReadingOrder : int with get, set

Public Property ReadingOrder As Integer

Property Value

Int32

One of the following values: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.

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.

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;
    }
}

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

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.

Applies to