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

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

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.

Applies to

Condividi tramite