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

Data Type

bool

Default Value

false

Remarks

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

When this connection property is set to True, the connector 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 connector returns a null value for these cells in query results.

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