How To Configure the DisableExcelCellFormat Option for Excel Export in Bold Reports
This article explains how to configure the DisableExcelCellFormat custom attribute in Bold Reports to control or disable formatting when exporting reports to Microsoft Excel. This option is useful when you want to reduce formatting overhead or prevent specific Excel cell formatting from being applied during export.
Steps to Configure DisableExcelCellFormat
Follow the steps below to configure this attribute:
-
Access Bold Reports designer:
- Open the Bold Reports Designer and open the report you wish to configure.
-
Access Report Properties
- Open the Properties panel, scroll down to the Miscellaneous section and expand it.
- Locate Custom Attributes and click the Set Attributes button to open the Custom Attributes dialog.
-
Add the DisableExcelCellFormat Attribute
-
In the Custom Attributes dialog, click Add to create a new attribute.
-
In the Name field :
DisableExcelCellFormat -
In the Value field, specify the Excel formatting element that you want to disable during export. The DisableExcelCellFormat attribute supports the following values:
Border — Disables only border formatting during Excel export.
All — Disables all cell formatting during Excel export.
Applies to: Report-level custom attributes. -
Confirm that Border and All are the only accepted values for the
DisableExcelCellFormatcustom attribute -
Click OK to save the attribute
-
-
Save the Changes:
- Click OK to close the dialog.
- Save your report changes and click the Preview button. From the previewer, select Export and choose Excel to verify the results.
Download the sample report here
Conclusion
The DisableExcelCellFormat custom attribute allows you to control how formatting is applied during Excel export. By using either Border or All, you can reduce unwanted formatting and customize the appearance of exported Excel files.
Related Articles
Exporting Reports to Excel from Bold Report: Handling Large Content Issues
How to Exclude Report Headers in Excel Export Using Bold Reports