Back to Devexpress

SpreadsheetFont.Bold Property

officefileapi-devexpress-dot-spreadsheet-dot-spreadsheetfont-0d8e4f5d.md

latest8.9 KB
Original Source

SpreadsheetFont.Bold Property

Gets or sets the value indicating whether the cell content is formatted as bold.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
bool Bold { get; set; }
vb
Property Bold As Boolean

Property Value

TypeDescription
Boolean

true , if the cell text is bold; otherwise, false.

|

Remarks

To specify all the required font characteristics, use the SpreadsheetFont object properties such as SpreadsheetFont.Name, SpreadsheetFont.Size, SpreadsheetFont.Color, SpreadsheetFont.Script, etc. Access this object via the Formatting.Font property.

For examples on how to specify formatting for an individual cell and cell range or modify a style, refer to the How to: Format a Cell or Range of Cells or How to: Create or Modify a Style document, respectively.

You can also use the SpreadsheetFont.FontStyle property to specify the font style.

Example

This example demonstrates how to format cell font characteristics (e.g., font name, size, color, style) by modifying the SpreadsheetFont object accessed via the Formatting.Font property of the Cell object.

View Example

csharp
// Access the Font object.
SpreadsheetFont cellFont = worksheet.Cells["A1"].Font;
// Set the font name.
cellFont.Name = "Times New Roman";
// Set the font size.
cellFont.Size = 14;
// Set the font color.
cellFont.Color = Color.Blue;
// Format text as bold.
cellFont.Bold = true;
// Set font to be underlined.
cellFont.UnderlineType = UnderlineType.Single;
vb
' Access the Font object.
Dim cellFont As SpreadsheetFont = worksheet.Cells("A1").Font
' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.
cellFont.Size = 14
' Set the font color.
cellFont.Color = Color.Blue
' Format text as bold.
cellFont.Bold = True
' Set font to be underlined.
cellFont.UnderlineType = UnderlineType.Single

The following code snippets (auto-collected from DevExpress Examples) contain references to the Bold property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/CellActions.cs#L150

csharp
sourceCell.Font.Color = Color.Blue;
sourceCell.Font.Bold = true;
sourceCell.Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thin);

winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/FormattingActions.cs#L400

csharp
// Format text as bold.
cellFont.Bold = true;
// Set font to be underlined.

wpf-spreadsheetcontrol-api-part-1/CS/SpreadsheetControl_WPF_API/SpreadsheetActions/FormattingActions.cs#L369

csharp
// Format text as bold.
cellFont.Bold = true;
// Set font to be underlined.

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/CellActions.vb#L135

vb
sourceCell.Font.Color = Color.Blue
sourceCell.Font.Bold = True
sourceCell.Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thin)

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/TableActions.vb#L109

vb
headerRowStyle.Font.Color = System.Drawing.Color.White
headerRowStyle.Font.Bold = True
' Format the total row.

winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/FormattingActions.vb#L388

vb
' Format text as bold.
cellFont.Bold = True
' Set font to be underlined.

wpf-spreadsheetcontrol-api-part-1/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/FormattingActions.vb#L356

vb
' Format text as bold.
cellFont.Bold = True
' Set font to be underlined.

See Also

Name

Size

Color

Script

FontStyle

Strikethrough

UnderlineType

WinForms Spreadsheet Control Examples

SpreadsheetFont Interface

SpreadsheetFont Members

DevExpress.Spreadsheet Namespace