Specifies whether to include spreadsheet calculation error types in query results.

Data Type

bool

Default Value

false

Remarks

This connection property controls how the driver treats cells containing invalid calculations in query results.

When this connection property is set to True, the driver returns the name of the error type, as it appears in the spreadsheet, (e.g. "#Name?") for these cells in query results.

When this connection property is set to False, the driver returns a null value for these cells in query results.

Note that, regardless of how this connection property is set, the driver does not halt query execution or display a driver-level error message when it detects a cell with invalid calculations.