Share via


XmlMappedRange.ReadingOrder Property

Gets or sets the reading order for the XmlMappedRange 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 may 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 an XmlMappedRange, if the current language that is selected or installed supports it. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub ReverseReadingOrder()
    If Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlRTL Then 
        Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlLTR
    Else 
        Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlRTL
    End If 
End Sub
private void ReverseReadingOrder()
{
    if (this.CustomerLastNameCell.ReadingOrder == 
        (int)Excel.Constants.xlRTL)
    {
        this.CustomerLastNameCell.ReadingOrder = 
            (int)Excel.Constants.xlLTR;
    }
    else
    {
        this.CustomerLastNameCell.ReadingOrder = 
            (int)Excel.Constants.xlRTL;
    }
}

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace