Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2008
Visual Studio
Visual Studio Tools for Office
Reference
2007 System Managed Reference
Microsoft.Office.Tools.Excel Namespace (2007 System)
Worksheet Class (2007 System)
Worksheet Properties (2007 System)
_CodeName Property (2007 System)
_DisplayRightToLeft Property (2007 System)
Application Property (2007 System)
AutoFilter Property (2007 System)
AutoFilterMode Property (2007 System)
Cells Property (2007 System)
CircularReference Property (2007 System)
CodeName Property (2007 System)
Columns Property (2007 System)
Comments Property (2007 System)
ConsolidationFunction Property (2007 System)
ConsolidationOptions Property (2007 System)
ConsolidationSources Property (2007 System)
Controls Property (2007 System)
Creator Property (2007 System)
CustomProperties Property (2007 System)
DisplayAutomaticPageBreaks Property (2007 System)
DisplayPageBreaks Property (2007 System)
DisplayRightToLeft Property (2007 System)
EnableAutoFilter Property (2007 System)
EnableCalculation Property (2007 System)
EnableFormatConditionsCalculation Property (2007 System)
EnableOutlining Property (2007 System)
EnablePivotTable Property (2007 System)
EnableSelection Property (2007 System)
FilterMode Property (2007 System)
HPageBreaks Property (2007 System)
Hyperlinks Property (2007 System)
Index Property (2007 System)
InnerObject Property (2007 System)
ListObjects Property (2007 System)
MailEnvelope Property (2007 System)
Name Property (2007 System)
Names Property (2007 System)
Next Property (2007 System)
OnCalculate Property (2007 System)
OnData Property (2007 System)
OnDoubleClick Property (2007 System)
OnEntry Property (2007 System)
OnSheetActivate Property (2007 System)
OnSheetDeactivate Property (2007 System)
Outline Property (2007 System)
PageSetup Property (2007 System)
Parent Property (2007 System)
Previous Property (2007 System)
ProtectContents Property (2007 System)
ProtectDrawingObjects Property (2007 System)
Protection Property (2007 System)
ProtectionMode Property (2007 System)
ProtectScenarios Property (2007 System)
QueryTables Property (2007 System)
Range Property (2007 System)
Rows Property (2007 System)
Scripts Property (2007 System)
ScrollArea Property (2007 System)
Shapes Property (2007 System)
SmartTags Property (2007 System)
Sort Property (2007 System)
StandardHeight Property (2007 System)
StandardWidth Property (2007 System)
Tab Property (2007 System)
TransitionExpEval Property (2007 System)
TransitionFormEntry Property (2007 System)
Type Property (2007 System)
UsedRange Property (2007 System)
Visible Property (2007 System)
VPageBreaks Property (2007 System)
Expand Minimize
This topic has not yet been rated - Rate this topic

Worksheet.ConsolidationFunction Property (2007 System)

Visual Studio 2008

Gets the function code used for the current consolidation.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
C#
C++
JScript
VB
Copy 
public XlConsolidationFunction ConsolidationFunction { get; }

Property Value

Type: XlConsolidationFunction
One of the XlConsolidationFunction values.

The following code example uses the ConsolidationFunction property to determine which function is used by the worksheet for consolidation.

This example is for a document-level customization.

C#
VB
Copy 
private void ShowConsolidationFunction()
{
    string simpleName;

    switch (this.ConsolidationFunction)
    {
        case Excel.XlConsolidationFunction.xlSum:
            simpleName = "Sum()";
            break;

        case Excel.XlConsolidationFunction.xlMax:
            simpleName = "Max()";
            break;

        case Excel.XlConsolidationFunction.xlProduct:
            simpleName = "Product()";
            break;

        default:
            simpleName = "Other";
            break;
    }
    MessageBox.Show("This worksheet uses " + simpleName +
        " for the consolidation function.");
}
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.