listErrors

List all formula errors and model errors in a workbook, grouped by error kind. Results are scoped to a sheet or range when provided, and truncated per group when the default cell limit is exceeded.

Parameter	Type		Description
sheet	string	optional	Restrict to a single sheet by name.
range	string	optional	Restrict to a range, e.g. ‘Sheet1!B2:D10’ or ‘B2:D10’ (resolved against the default/first sheet). Takes precedence over ‘sheet’ if both are given.
max	integer	optional	Max cells listed per formula-error group (default 50).