4D v13

PV FIND ALL

Home

 
4D View v13
PV FIND ALL

PV FIND ALL 


 

PV FIND ALL ( area ; criteria ; where ; contains ) 
Parameter Type   Description
area  Longint in 4D View area
criteria  String in String to look for
where  Integer in 0 = Formulas; 1 = Values
contains  Integer in 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)

Example  

Refer to the example for the PV SET CELL PROPERTY command.

 
PROPERTIES 

Product: 4D
Theme: PV Cell manipulation
Number: 15976

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV FIND ONE
PV REPLACE ALL