Command PV FIND ALL

4D View

PV FIND ALL

version 6.8


PV FIND ALL (area; criteria; where; contains)

ParameterTypeDescription
areaLongint4D View area
criteriaStringString to look for
whereInteger0 = Formulas; 1 = Values
containsInteger0 = 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

PV FIND ONE, PV REPLACE ALL.