TXlsFile.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.XlsAdapter
function TXlsFile.CheckDataValidationsInSheet(const sheet: Integer; const maxErrors: Integer): TArray<TCellAddress>; override;
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.
See also