WinGridExcelExporter™ now has the ability to export WinCalcManager™ Formulas to Excel as Excel Functions. Previously, when using WinGridExcelExporter to export WinGrid Data to Excel, any WinCalcManager calculated cells would be exported as the actual evaluated value. The calculated WinGrid columns would end up as actual values in the Excel file where modifications to Excel Worksheet cells would not cause a recalculation of the values. By exporting the WinCalcManager Formulas as Excel Functions, your end user can now make changes to the Worksheet cells and cause the values to recalculate.
WinGridExcelExporter also comes complete with FormulaExporting and FormulaExported events which allow you to cancel certain Formulas from being exported as well as modifying or altering Formulas after they are exported. You also have a FormulaExportError event which can be used to trap and handle any errors that may occur whenever exporting Formulas to Excel.
This new feature can also be turned off by simply setting the ExportFormulas WinGridExcelExporter property to false.