Predefined cells
The following table contains descriptions of all the predefined cells D2000 Parameters:
| Cell name | Expected value type | Meaning |
|---|---|---|
| USER_NAME | Text | User name for automatic logon to the D2000 system.
The name will be used, if the parameter (the cell named) LOG_ON_FROM_HI doesn't exist or its value is other than TRUE. |
| PASSWORD | Text | User password for automatic logon to the D2000 system.
The password will be used, if the parameter (the cell named) LOG_ON_FROM_HI doesn't exist or its value is other than TRUE. |
| SERVER | Text | Computer name for automatic logon to the D2000 system in network.
If the application server is configured as Redundant group we recommend to write a name of redundant group with prefix /RD or /RF as the parameter value. The name will be used, if the parameter (the cell named) LOG_ON_FROM_HI doesn't exist or its value is other than TRUE. |
| PROC_DESC | Text | Text written into the log database during starting the report. |
| LOG_ON_FROM_HI | Logic | User logon method after opening the workbook.
If the cell exists and its value is TRUE, the workbook will be designed for opening in the process D2000 HI. If the cell does not exist or its value is other than TRUE, the parameters USER_NAME, PASSWORD, SERVER, PROC_DESC will be used after opening the workbook. If the parameters are defined incorrectly (or do not exist), there will be displayed the dialog box to log on. |
| D2000_BT | Absolute time | After opening the workbook or after clicking the button Calculate,
the cell is automatically initialized to the current time.
If the workbook is opened in the process D2000 HI, the cell is filled by the begin time (Time interval) defined in the process D2000 HI. |
| D2000_ET | Absolute time | After opening the workbook or after clicking the button Calculate,
the cell is automatically initialized to the current time.
If the workbook is opened in the process D2000 HI, the cell is filled by the end time (Time interval) defined in the process D2000 HI. |
| D2000_TEXT | Text | If the workbook is opened in the process D2000 HI, the cell is filled by a value of the parameter String defined in the process D2000 HI. |
| D2000_NUM1 | Number | If the workbook is opened in the process D2000 HI, the cell is filled by a value of the first parameter of Numeric parameters defined in the process D2000 HI. |
| D2000_NUM2 | Number | If the workbook is opened in the process D2000 HI, the cell is filled by a value of the first parameter of Numeric parameters defined in the process D2000 HI. |
| EXPORT_FILE_NAME | Text | Full name of a .xls file, that will be created by using the automatic report export method. |
| SUPP_NO_ARCH_DATA | Optional value | Cell value (if the cell exists) will be used as the return value of the function D2_ArchValue when the function access an value that doesn't exist (out of range). |
Pridať komentár