Exclusive API for Data Entry Preview

Difference from V10.0:

No changes, and all the following APIs are supported in V10.0.

Widget name, which is a string.

Note: 

Widgets in cells are unnamed by default. You can set the names in Widget Name.

_g().getWidgetByName("comboBox0");

For details, you can download the template Disabling the WidgetAfter Value Input.cpt

_g().getWidgetByCell("A1");

Example 2: In a data entry report, you can use this API to get the widget in a cell by specifying the column and row numbers. For example, you can get the widget located in the cell at column 1, row 1 (cell A1). The columnRow2CellStr API can convert row and column indices into a cell address. For details about, see the corresponding document.

_g().getWidgetByCell(FR.columnRow2CellStr({col:0, row:0}))

For details, you can download the template Disabling the Widget After Value Input (by Cell Address).cpt

Widget name, which is a string.

Note: 

Widgets in cells are unnamed by default. You can set the names in Widget Name.

_g().getWidgetsByName("comboBox0");

num: number

cell: string

num: number of rows to be inserted, which is a number.

cell: cell address where insertion occurs. number of the cell where the row is inserted. Without this parameter, the insertion occurs at the row where the cursor is located.

_g().appendReportRC(3,"A1");

For details, you can download the template Inserting Rows at a Specified Position.cpt

cell: string

sheetindex: number

num: number

cell: cell address where the Insert Row button is located, which is a string.

sheetindex: sheet number, which is a number starting from zero.

num: number of rows to be inserted, which is a number.

In a data entry report, the Insert Row button is located in cell F1 of sheet1.

You can insert three rows by using the button in cell F1 with the following JavaScript code.

_g().appendReportRow("F1", 0,3);

Example 2: You can insert three rows after obtaining the Insert Row button and the sheet number by using this.options.location and this.options.reportIndex.

report.appendReportRow(this.options.location,this.options.reportIndex,3);

Example 3: In a data entry report, you can insert three rows after obtaining the Insert Row button and sheet number by using this.options.location and this.options.reportIndex.

_g().appendReportRow(this.options.location,this.options.reportIndex,3);

_g().deleteReportRC("A1");

Example 2: In a data entry report. you can delete the row where the cursor is located.

_g().deleteReportRC();

_g().deleteRows(['A1','A2']);

_g().refreshAllSheets();

For details, you can download the template Staying on the Current Sheet After Refresh.cpt

In a data entry report, you can switch to the second sheet.

_g().loadSheetByIndex(1);

When multiple sheets exist in a report, you can set the second sheet to be displayed by default during preview.

For details, you can download the template Displaying the Sheet with the Specified Name by Default.cpt

_g().loadSheetByName("Product");

When multiple sheets exist in a report, you can set the sheet named sheet2 to be displayed by default during preview.

For details, you can download the template Displaying the Sheet with the Specified Name by Default.cpt

 _g().writeReport(1);

For details, you can download the template Force Submission Without Verification.cpt

isallsheet: Determines whether to submit all sheets.

true: Submit all sheets.

false: Submit the current sheet.

_g().verifyAndWriteReport(true);

For details, you can download the template Submission with Verification.cpt

_g().verifyReport();

For details, you can download the template Custom Verify Button.cpt

Import mode, which is a string. 

If this parameter is not provided, the general import is used. 

customize: The custom import is used.

_g().importExcel();

Example 2: In a data entry report, you can bring up a pop-up window for Excel import, and import an Excel file using the custom import method.

 _g().importExcel("customize");

You can customize an Import Excel button. After clicking the button, you can  import an Excel file.

 For details, you can download the template Custom Excel Import.cpt

_g().importExcel_Clean();

For details, you can download the template Multiple Excel Imports.cpt

 _g().importExcel_Append();

For details, you can download the template Multiple Excel Imports.cpt

_g().importExcel_Cover();

 For details, you can download the template Multiple Excel Imports.cpt

The value indicating whether a page has been edited, which is a boolean value.

true: Indicates that the page has been edited.

false: Indicates that the page has not been edited.

 _g().isDirtyPage();

For details, you can download the template Viewing the Editting Status.cpt

The value indicating whether  auto-stash is enabled, which is a boolean value.

true: enabled

false: disabled

_g().isAutoStash();

_g().stash(undefined,true);

Example 2: In a data entry report, you can stash the data without the pop-up success prompt.

_g().stash();

_g().clear();

Example 2: In a data entry report, you can clear the stashes without the confirmation and success prompts.

_g().clear(undefined,false);