4D v18
VP SET FORMULAS
- 4D View Pro Reference
-
- 4D View Pro Language
-
- About 4D View Pro commands
- Handling 4D View Pro areas
- 4D View Pro Constants
- VP ADD FORMULA NAME
- VP ADD RANGE NAME
- VP ADD SELECTION
- VP ADD STYLESHEET
- VP All
- VP Cell
- VP Cells
- VP Column
- VP Combine ranges
- VP Convert from 4D View
- VP Convert to pictureNew
- VP EXPORT DOCUMENTUpd
- VP Export to object
- VP FLUSH COMMANDS
- VP Font to object
- VP Get active cell
- VP Get cell style
- VP Get default style
- VP Get formula
- VP Get formula by name
- VP Get formulas
- VP Get names
- VP Get print infoNew
- VP Get selection
- VP Get stylesheet
- VP Get stylesheets
- VP Get value
- VP Get values
- VP IMPORT DOCUMENT
- VP IMPORT FROM OBJECT
- VP Name
- VP NEW DOCUMENT
- VP Object to font
- VP PRINTNew
- VP REMOVE NAME
- VP REMOVE STYLESHEET
- VP RESET SELECTION
- VP Row
- VP SET ACTIVE CELL
- VP SET ALLOWED METHODS
- VP SET BOOLEAN VALUE
- VP SET BORDER
- VP SET CELL STYLE
- VP SET DATE TIME VALUE
- VP SET DATE VALUE
- VP SET DEFAULT STYLE
- VP SET FIELD
- VP SET FORMULA
- VP SET FORMULAS
- VP SET NUM VALUE
- VP SET PRINT INFONew
- VP SET SELECTION
- VP SET TEXT VALUE
- VP SET TIME VALUE
- VP SET VALUE
- VP SET VALUES
- VP SHOW CELL
- 4D View Pro Range Object Properties
- 4D View Pro Print Attributes
- 4D View Pro Cell Format
- 4D View Pro Style Objects and Style Sheets
4D v18
VP SET FORMULAS
VP SET FORMULAS
| VP SET FORMULAS ( rangeObj ; formulasCol ) | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |
|
Cell range object | |||||
| formulasCol | Collection |
|
Collection of formulas | |||||
The VP SET FORMULAS command assigns a collection of formulas starting at the specified cell range.
In rangeObj, pass a range of the cell (created with VP Cell) whose formula you want to specify. If rangeObj includes multiple ranges, only the first range is used.
The formulasCol is a two-dimensional collection:
- The first-level collection contains subcollections of formulas. Each subcollection defines a row.
- Each subcollection defines cell values for the row. Values must be text elements containing the formulas to assign to the cells.
Note: If a 4D method is used, it must be allowed with the SET ALLOWED METHODS command (see Project method references).
This code:
$formulas:=New collection
$formulas.push(New collection("MAX(B11,C11,D11)";"myMethod(G4)")) // First row
$formulas.push(New collection("SUM(B11:D11)";"AVERAGE(B11:D11)")) // Second row
VP SET FORMULAS(VP Cell("ViewProArea";6;3);$formulas) // Set the cells with the formulaswill set the formulas in the designated range:
myMethod:
$0:=$1*3.33
See also
PROPERTIES
Product: 4D
Theme: 4D View Pro Language
Number:
9774
HISTORY
Created: 4D v17 R6
ARTICLE USAGE
4D View Pro Reference ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.