OfficeHTMLFormulasEnabled (Property)

Applies To:

ResultsSection object, TableSection object

Description:

Enables generation of Microsoft Excel formulas when exporting Results and Tables sections to Microsoft Office HTML and MHTML formats. Adding formulas allows for automatic recalculation of Computed Items and Break/Grand Total in an Excel worksheet.

Action:

Read-write, Boolean

Example:

This example shows how to disable the formula generation:

Documents["Sales.bqy"].Sections["Results"].OfficeHTMLFormulasEnabled = false