#DEFINITION DIALOG BOX LAUNCHER HOW TO#
#DEFINITION DIALOG BOX LAUNCHER CODE#

For details, refer to the How to: Apply Gradient Fill example. Set the Fill.FillType property to FillType.Gradient and specify the gradient characteristics.

Use the Formatting.Fill property to access the Fill object that specifies the cell background fill. The SpreadsheetControl also provides the capability to specify a gradient fill for a cell’s background color. For an example, refer to the How to: Change Cell Font and Background Color document. To change font characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Fill property of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification. To specify the background color programmatically for an individual cell, modify the Formatting.Fill property of the Cell object. The Fill tab of the Format Cells… dialog provides end-users with the capability to specify the cell background color and pattern style.

For more information, refer to the How to: Add and Remove Cell Borders document. Then call the CellRange.EndUpdateFormatting method to finalize the modification. To apply borders to a range of cells, call the CellRange.BeginUpdateFormatting method for this range, and specify the Borders property of the returned Formatting object. To access this object for an individual cell, use the Formatting.Borders property of the Cell object. To access and specify cell borders programmatically, use the Borders object. The Border tab of the Format Cells… dialog allows end-users to apply a border around an individual cell or a range of cells and customize border appearance by changing the line style and color. To change the font characteristics for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Font property of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification. To do this for an individual cell, modify the Formatting.Font property of the Cell object. You can also modify font attributes programmatically. The Font tab of the Format Cells… dialog allows end-users to specify a typeface and its attributes (such as style, size, color, underlining and effects).Įnd-users can invoke the Format Cells dialog with the Font tab open by clicking the dialog box launcher located in the bottom-right corner of the Font group in the Home tab of the Ribbon UI. For more information, refer to the How to: Align Cell Content example. To change the alignment attributes of a range of cells, call the CellRange.BeginUpdateFormatting method for this range, modify the Alignment property of the returned Formatting object, and call the CellRange.EndUpdateFormatting method to finalize the modification. To apply the alignment to an individual cell, use the Cell object’s Formatting.Alignment property. To programmatically align data, use the properties of the Alignment object. The Alignment tab of the Format Cells… dialog allows end-users to align and rotate cell content and specify text control options.Įnd-users can invoke the Format Cells dialog with the Alignment tab open by clicking the dialog box launcher located in the bottom-right corner of the Alignment group in the Home tab of the Ribbon UI. For an example, refer to the How to: Specify Number or Date Format for Cell Content topic.

#DEFINITION DIALOG BOX LAUNCHER CODE#

To apply a number format to a cell or cell range programmatically, assign the corresponding number format code to the Formatting.NumberFormat property of the cell or cell range object. By default, all worksheet cells in the SpreadsheetControl are formatted with the General number format.Įnd-users can invoke the Format Cells dialog with the Number tab open by clicking the dialog box launcher located in the bottom-right corner of the Number group in the Home tab of the Ribbon UI. The Number tab of the Format Cells… dialog allows end-users to apply a number format to display cell numbers as monetary values, percentage values, date values, etc.

#DEFINITION DIALOG BOX LAUNCHER HOW TO#

(For an example on how to create a Ribbon UI, refer to the Getting Started document.) Number Tab To do this, provide the Home Ribbon page for the SpreadsheetControl. You can also allow end-users to invoke the Format Cells… dialog via the Ribbon UI. The dialog box includes six tabs: Number Alignment Font Border Fill and ProtectionĮnd-users can invoke this dialog by right-clicking a cell and selecting the Format Cells… item from the context menu. The Format Cells dialog allows end-users to format data in a worksheet (specify cell background, font color and style, change content alignment, apply cell borders, etc.).

Definition dialog box launcher