Share via


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

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace