Specifies whether the provider should ignore formula calculation errors in Excel worksheets.

Data Type

bool

Default Value

true

Remarks

This property controls how the server handles formula calculation errors when reading Excel data.

If set to true, the server ignores any errors that occur during formula evaluation. While this may result in unreliable values for calculated fields, other non-calculated data remains accurate.

If set to false, the server stops processing if a calculation error occurs.

Use this property when you want to load available data despite potential issues in calculated cells.