NamedRange.ReadingOrder Property (2007 System)

Gets or sets the reading order for the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property ReadingOrder As Integer
'Usage
Dim instance As NamedRange 
Dim value As Integer 

value = instance.ReadingOrder

instance.ReadingOrder = value
[BrowsableAttribute(false)]
public int ReadingOrder { get; set; }
[BrowsableAttribute(false)]
public:
property int ReadingOrder {
    int get ();
    void set (int value);
}
public function get ReadingOrder () : int 
public function set ReadingOrder (value : int)

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", missing], "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 Class

NamedRange Members

Microsoft.Office.Tools.Excel Namespace