4D v18
VP Get formula
- 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 Get formula
VP Get formula
| VP Get formula ( rangeObj ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |
|
Range object | |||||
| Function result | Text |
|
Formula | |||||
The VP Get formula command retrieves the formula from a designated cell range.
In rangeObj, pass a range whose formula you want to retrieve. If rangeObj designates multiple cells or multiple ranges, the formula of the first cell is returned. If rangeObj is a cell that does not contain a formula, the command returns an empty string.
//set a formula
VP SET FORMULA(VP Cell("ViewProArea";5;2);"SUM($A$1:$C$10)")
$result:=VP Get formula(VP Cell("ViewProArea";5;2)) // $result="SUM($A$1:$C$10)"
See also
PROPERTIES
Product: 4D
Theme: 4D View Pro Language
Number:
9587
HISTORY
Created: 4D v17 R4
ARTICLE USAGE
4D View Pro Reference ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.