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

Data Type

bool

Default Value

true

Remarks

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

If set to true, the provider 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 provider stops processing if a calculation error occurs.

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