Expand Minimize

NamedRange.ReadingOrder Property

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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)

int ReadingOrder { get; set; }

Property Value

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

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft