CODEWITHSUNDEEP
spreadsheetgear
papps
papps

Reputation: 169

Setting Application.ErrorCheckingOptions.BackgroundChecking with Spreadsheetgear

What's the equivalent of doing Application.ErrorCheckingOptions.BackgroundChecking = False with Spreadsheetgear ?

Thanks

Upvotes: 0

Views: 356

Answers (1)

Tim Andersen
Tim Andersen

Reputation: 3184

SpreadsheetGear does not provide formula error-checking options like this, so there are no equivalent options in SpreadsheetGear's API.

As I understand it, BackgroundChecking is a setting specific to the Excel Application itself and nothing that could be set in the XLS or XLSX/XLSM file format itself. So even if we did support such a feature, I don't think it would persist within the workbook file and upon opening in Excel later on, if that is what you are trying to do.

Upvotes: 2

Related Questions