Predefined Cells

Predefined Cells

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.

If it is necessary to specify a port for the connection, it is entered by adding the character : and the port number (alternative to the process parameter /P:<PortNr>).

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