4D v18
Handling 4D View Pro areas
- 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
Handling 4D View Pro areas
When working with 4D View Pro areas in your forms, you need to handle several elements:
- The 4D View Pro form area (4D form object): contains and displays the 4D View Pro object. This area is defined by a name ("Object name" field in the Property list).
- The 4D View Pro object (C_OBJECT type variable or expression): stores the whole spreadsheet contents (see below). You can get or set this object using the VP IMPORT FROM OBJECT or VP Export to object commands.
- The 4D View Pro document (.4vp documents): stores the whole spreadsheet contents in JSON format.
When loading a 4D View Pro object in a form area, 4D generates the On VP Ready form event once the whole area is loaded. You must execute any 4D View Pro code handling the area in this event, otherwise an error is returned.
The 4D View Pro object describes the document and is automatically handled by the 4D View Pro commands. It contains the following properties:
| Property | Value type | Description |
| version | Longint | Internal component version |
| dateCreation | Timestamp | Creation date |
| dateModified | Timestamp | Last modification date |
| meta | Object | Free contents, reserved for the 4D developer |
| spreadJS | Object | Reserved for the 4D View Pro component |
The 4D View Pro form object variable manages information used by the 4D View Pro object. It contains the following variables:
| Property | Value type | Description callbacks | Object | Stores temporary information necessary for commands requiring callbacks such as importing and exporting. commandBuffers | Collection | Stores sequentially the commands called by the method and executes them as a batch (rather than individually) upon exiting the method, or if a command returns a value or the VP FLUSH COMMANDS is called. This mechanism increases performance by reducing the number of requests sent. formulaBar | Boolean | Indicates whether or not the formula bar is displayed. Available only for the "toolbar" interface. inited | Boolean | Indicates whether or not the 4D View Pro area has been initialized (see On VP Ready). interface | Text | Specifies the type of user interface:"ribbon", "toolbar", "none". |
Note: The 4D View Pro form object variable is for information purposes only (i.e., debugging). Under no circumstances should it be modified.
Product: 4D
Theme: 4D View Pro Language
4D View Pro Reference ( 4D v18)
