Skip to main content
Version: 20 R7 BETA

On VP Range Changed

CodeCan be called byDefinition
614D View Pro AreaThe 4D View Pro cell range has changed (e.g., a formula calculation, value removed from a cell, etc.)

Description

This event is generated when a change occurs within a cell range in the 4D View Pro document.

The object returned by the FORM Event command contains:

PropertyTypeDescription
objectNametext4D View Pro area name
codelongintOn VP Range Changed
descriptiontext"On VP Range Changed"
sheetNametextName of the sheet of the event
rangeobjectCell range of the change
changedCellsobjectRange containing only the changed cells. It can be a combined range.
actiontextThe type of operation generating the event:
  • "clear" - A clear range value operation
  • "dragDrop" - A drag and drop operation
  • "dragFill" - A drag fill operation
  • "evaluateFormula" - Setting a formula in a specified cell range
  • "paste" - A paste operation
  • "setArrayFormula" - Setting a formula in a specified cell range
  • "sort" - Sorting a range of cells
  • See also On After Edit.