TExcelFile.CheckDataValidationsInSheet Method
Checks if all the cells in the active sheet inside data validations have values that are valid according to the data validation specifications.
Syntax
Unit: FlexCel.Core
function TExcelFile.CheckDataValidationsInSheet(const sheet: Integer; const maxErrors: Integer): TArray<TCellAddress>; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | sheet | Integer | Sheet to check (1 based) |
| const | maxErrors | Integer | The maximum number of errors reported by this method. To avoid getting a too big list, set it to a number like 100. If set to 0 or a negative number, the full list of errors will be returned, which can be very big. |
Returns
An array with the first maxErrors cells that do not conform to the data validation. And empty array if all the cells conform.