4D v13
PV FIND ALL
PV FIND ALL
| 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 | |||||
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)
Refer to the example for the PV SET CELL PROPERTY command.
Product: 4D
Theme: PV Cell manipulation
Number:
15976
Created: 4D View 6.8
