SetExcelSummaryCellFormatSettings Method

Sets the value of the 'ExcelSummaryCellFormatSettings' attached property.

Syntax

Visual Basic

'Declaration
 
Public Shared Sub SetExcelSummaryCellFormatSettings( _
   ByVal d As DependencyObject, _
   ByVal value As FormatSettings _
) 

C#

public static void SetExcelSummaryCellFormatSettings( 
   DependencyObject d,
   FormatSettings value
)

Parameters

d

value

Example

The following snippets demonstrate how to set the appearance of exported summary cells.

Visual Basic

FormatSettings summaryCellFormatSettings = new FormatSettings();
summaryCellFormatSettings.FillPatternForegroundColor = Colors.LightGray;
summaryCellFormatSettings.FontWeight = FontWeights.Bold;

DataPresenterExcelExporter.SetExcelSummaryCellFormatSettings(this.Grid.FieldSettings, summaryCellFormatSettings);

C#

FormatSettings summaryCellFormatSettings = new FormatSettings();
summaryCellFormatSettings.FillPatternForegroundColor = Colors.LightGray;
summaryCellFormatSettings.FontWeight = FontWeights.Bold;

DataPresenterExcelExporter.SetExcelSummaryCellFormatSettings(this.Grid.FieldSettings, summaryCellFormatSettings);

XAML

<igDP:XamDataGrid.FieldSettings>
    <igDP:FieldSettings>
        <igExcelExporter:DataPresenterExcelExporter.ExcelSummaryCellFormatSettings>
            <igExcelExporter:FormatSettings 
                FillPatternForegroundColor="LightGray"
                FontWeight="Bold"/>            
        </igExcelExporter:DataPresenterExcelExporter.ExcelSummaryCellFormatSettings>
    </igDP:FieldSettings>            
</igDP:XamDataGrid.FieldSettings>

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2