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).