WorksheetBase.ConsolidationOptions Property

Gets a three-element Array of consolidation options.

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

Syntax

'Declaration
Public ReadOnly Property ConsolidationOptions As Object

public Object ConsolidationOptions { get; }

Property Value

Type: System.Object
A three-element Array of consolidation options.

Remarks

If an element in the returned array is true, then the corresponding option is set. The three elements in the array are:

Examples

The following code example uses the ConsolidationOptions property to display the values of the consolidation options for the current worksheet.

This example is for a document-level customization.

Private Sub ShowConsolidationOptions()
    If Not (Me.ConsolidationOptions Is Nothing) Then 
        Dim options As Array = CType(Me.ConsolidationOptions, Array)

        Me.Range("A1").Value2 = "Use labels in top row" 
        Me.Range("A2").Value2 = "Use labels in left column" 
        Me.Range("A3").Value2 = "Create links to source data" 

        Dim i As Integer 
        For i = 1 To 3
            If CBool(options.GetValue(i)) Then 
                Me.Range("B" + i.ToString()).Value2 = "True" 
            Else 
                Me.Range("B" + i.ToString()).Value2 = "False" 
            End If 

            Me.Columns.AutoFit()
        Next i
    End If 
End Sub

private void ShowConsolidationOptions()
{
    if (this.ConsolidationOptions != null)
    {
        Array options = (Array)this.ConsolidationOptions;

        this.Range["A1"].Value2 = "Use labels in top row";
        this.Range["A2"].Value2 = "Use labels in left column";
        this.Range["A3"].Value2 = "Create links to source data";

        for (int i = 1; i <= 3; i++)
        {
            if ((bool)options.GetValue(i))
            {
                this.Range["B" + i.ToString()].Value2 = "True";
            }
            else
            {
                this.Range["B" + i.ToString()].Value2 = "False";
            }
            this.Columns.AutoFit();
        }
    }
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace