GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.FormatCells

FormatCells Method

FormatCells(GcSpreadSheet, IRange, FormatCellsTabs)

Shows the format cells dialog to customize the cell settings.

Declaration

public static IDialog FormatCells(GcSpreadSheet spread, IRange range = null, FormatCellsTabs activeTab = FormatCellsTabs.Number)

Public Shared Function FormatCells(spread As GcSpreadSheet, Optional range As IRange = Nothing, Optional activeTab As FormatCellsTabs = FormatCellsTabs.Number) As IDialog

Parameters

Type	Name	Description
GcSpreadSheet	spread	The GcSpreadSheet control to work with.
IRange	range	The current cell range to work with.
FormatCellsTabs	activeTab	The default active tab.

Returns

Type	Description
IDialog	The IDialog object represents the format cells dialog.

FormatCells(GcSpreadSheet, IRange, StyleFormat, FormatCellsTabs, int, object, bool)

Shows the format cells dialog to customize the cell settings.

Declaration

public static IDialog FormatCells(GcSpreadSheet spread, IRange range, StyleFormat styleFormat, FormatCellsTabs activeTab = FormatCellsTabs.Number, int numFmtCategory = 0, object cellValue = null, bool isTable = false)

Public Shared Function FormatCells(spread As GcSpreadSheet, range As IRange, styleFormat As StyleFormat, Optional activeTab As FormatCellsTabs = FormatCellsTabs.Number, Optional numFmtCategory As Integer = 0, Optional cellValue As Object = Nothing, Optional isTable As Boolean = False) As IDialog

Parameters

Type	Name	Description
GcSpreadSheet	spread	The GcSpreadSheet control to work with.
IRange	range	The current cell range to work with.
StyleFormat	styleFormat	The StyleFormat value to display as current settings.
FormatCellsTabs	activeTab	The default active tab.
int	numFmtCategory	The default selected number format category.
object	cellValue	The cell value to display as preview.
bool	isTable

Returns

Type	Description
IDialog	The IDialog object represents the format cells dialog.

FormatCells(GcSpreadSheet, StyleFormat, FormatCellsTabs)

Shows the format cells dialog to customize the cell settings.

Declaration

public static IDialog FormatCells(GcSpreadSheet spread, StyleFormat styleFormat, FormatCellsTabs activeTab = FormatCellsTabs.Number)

Public Shared Function FormatCells(spread As GcSpreadSheet, styleFormat As StyleFormat, Optional activeTab As FormatCellsTabs = FormatCellsTabs.Number) As IDialog

Parameters

Type	Name	Description
GcSpreadSheet	spread	The GcSpreadSheet control to work with.
StyleFormat	styleFormat	The StyleFormat value to display as current settings.
FormatCellsTabs	activeTab	The default active tab.

Returns

Type	Description
IDialog	The IDialog object represents the format cells dialog.