PV FIND ALL
version 6.8
PV FIND ALL (area; criteria; where; contains)
Parameter | Type | Description | |
area | Longint | 4D View area | |
criteria | String | String to look for | |
where | Integer | 0 = Formulas; 1 = Values | |
contains | Integer | 0 = Contains; 1 = Equals |
Description
The PV FIND ALL command is similar to PV FIND ONE but selects all the cells in area that correspond to the query criteria.
After calling this command, the first cell eventually found becomes the new current cell and the other found cells are selected.
If no cell was found during the search, the current cell remains the same.
criteria specifies the character string to query.
where indicates which part of the spreadsheet to query:
• 0: Queries formulas
• 1: Queries values
contains defines the type of comparison:
• 0: Partial (contains the queried value)
• 1: Total (equal to the queried value)
Example
Refer to the example for the PV SET CELL PROPERTY command.
See Also