Predefined cells

The following table contains descriptions of all the predefined cells D2000 Parameters:

Cell nameExpected value typeMeaning
USER_NAME
TextUser 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
TextUser 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
TextComputer 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
TextText written into the log database during starting the report.
LOG_ON_FROM_HILogicUser 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_BTAbsolute timeAfter 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_ETAbsolute timeAfter 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_TEXTTextIf 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_NUM1NumberIf 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_NUM2NumberIf 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_NAMETextFull name of a .xls file, that will be created by using the automatic report export method.
SUPP_NO_ARCH_DATAOptional valueCell 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).
Napíšte komentár