4D v18
VP ADD FORMULA NAME
- 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
VP ADD FORMULA NAME
| VP ADD FORMULA NAME ( vpAreaName ; vpFormula ; name {; options} ) | ||||||||
| Parameter | Type | Description | ||||||
| vpAreaName | Text |
|
4D View Pro area form object name | |||||
| vpFormula | Text |
|
4D View Pro formula | |||||
| name | Text |
|
Name for the fomula | |||||
| options | Object |
|
Options for the named formula | |||||
The VP ADD FORMULA NAME command creates or modifies a named formula in the open document.
Note: Named formulas created by this command are saved with the document.
In vpAreaName, pass the name of the 4D View Pro area. If you pass a name that does not exist, an error is returned.
Pass the 4D View Pro formula that you want to name in vpFormula. For detailed information about formula syntax, please refer to the 4D View Pro Formulas section.
Pass the new name for the formula in name. If the name is already used within the same scope, the new named formula replaces the existing one. Note that you can use the same name for different scopes (see below).
You can pass an object with additional properties for the named formula in options. The following properties are supported:
| Property | Type | Description | |||||||||
| scope | Number | Scope for the formula. You can pass the sheet index (counting begins at 0) or use the following constants:
Note: The scope determines whether a formula name is local to a given worksheet (scope=sheet index or vk current sheet), or global across the entire workbook (scope=vk workbook). | |||||||||
| comment | Text | Comment associated to named formula |
VP ADD FORMULA NAME("ViewProArea";"SUM($A$1:$A$10)";"Total2")
Product: 4D
Theme: 4D View Pro Language
Number:
9556
Created: 4D v17 R4
4D View Pro Reference ( 4D v18)
