4D View v16

PV SPECIAL CLEAR

Home

4D View Language
- PV Cell manipulation
- - PV Cell manipulation, Introduction
  - PV Copy to blob
  - PV FIND ALL
  - PV FIND ONE
  - PV PASTE FROM BLOB
  - PV REPLACE ALL
  - PV REPLACE ONE
  - PV SORT COLUMN
  - PV SORT MANY
  - PV SORT ONE
  - PV SPECIAL CLEAR
  - PV SPECIAL CUT
  - PV SPECIAL PASTE

Home

4D View v16

4D View Language

PV Cell manipulation

PV SPECIAL CLEAR


PV SPECIAL CLEAR ( area ; value ; formula ; format ; borders )

Parameter	Type	Description
area	Longint	4D View area
value	Integer	0 = Do not clear; 1 = Clear
formula	Integer	0 = Do not clear; 1 = Clear
format	Integer	0 = Do not clear; 1 = Clear
borders	Integer	0 = Do not clear; 1 = Clear

Description

The PV SPECIAL CLEAR command clears the information defined in the value, formula,format and borders parameters from the selection of current cells in area.

Example

Erase the formulas, formats and borders of selected cells, while keeping possible values for cells containing values and not formulas:

PV SPECIAL CLEAR(Area;0;1;1;1) `Erase formulas, formats and borders