Articles in this section

How To Configure the DisableExcelCellFormat Option for Excel Export in Bold Reports

Published:
Updated:

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:

  1. Access Bold Reports designer:

    • Open the Bold Reports Designer and open the report you wish to configure.
  2. 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.
      image.png
  3. 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 DisableExcelCellFormat custom attribute

    • Click OK to save the attribute

      image.png

  4. 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.
      image.png

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

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Access denied
Access denied