Command PV REPLACE ONE

PV REPLACE ONE

version 6.8

PV REPLACE ONE (area; string; replace; where; contains{; column; row})

Parameter	Type		Description
area	Longint		4D View area
string	String		String to replace
replace	String		Replacement string
where	Integer		0 = Formulas; 1 = Values
contains	Integer		0 = Contains; 1 = Equals
column	Longint		Starting cell column number
			Found cell column number
row	Longint		Starting row column number
			Found cell row number

The PV REPLACE ONE command replaces character string with replace in the first cell in area that corresponds to the query criteria defined using where or contains, starting from the cell set by column and row.

string specifies the character string to search and replace with replace.

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)

If the column and row optional parameters are omitted, the search begins at the top left corner of the area. If column and row are passed, they indicate the cell of the area from which the search will begin.

The search is carried out from top to bottom and then from left to right beginning with the starting cell.

After execution of the command, the first cell found, if any, becomes the new current cell. If they were called, the column and row parameters will then contain the coordinates of this new cell.

If no cell was found during the search, the current cell remains unchanged.

Replace the first occurrence of the current T.V.A. rate with a new reference (new rate).

   C_INTEGER($Where)  `0=Formula / 1=Value
   C_INTEGER($Contains)  `0=Contains / 1=Equals

   $Where:=0  `Replacement formula
   $Contains:=0  `Contains

      `Replace first instance
   PV REPLACE ONE (Area;"$C$30";"$C$31";$Where;$Contains)

PV FIND ONE, PV REPLACE ALL.