Exporting Data Entry Form

A dialog box for setting export options opens after external file format is selected. Working with the dialog box depends on the browser in use.

The appearance of this dialog box may vary depending on the export file type, but the following settings are always available:

NOTE. When exporting to XLS and XLSX, the sheets list displays hidden sheets if the Hidden Sheets checkbox is selected in the Export dialog box.

Export Features

When saving a data entry form to XLS and XLSX the Export dialog box looks as follows:

Set the parameters:

Hidden Rows and Columns. When the checkbox is selected, hidden areas (if available) are exported and can be worked with using Microsoft Excel tools.
Hidden Sheets. When the checkbox is selected, hidden sheets of the data entry form are displayed in the sheets list. When exporting the entire data entry form hidden sheets will also be exported.
Color Palette. When the checkbox is selected, and original colors are used, one can replace the Microsoft Excel palette with the palette used in Foresight Analytics Platform. When the checkbox is deselected, the most appropriate color is selected from Microsoft Excel palette, the palette is not changed.

NOTE. The parameter is available only on export to XLS.

Expanders. The checkbox is deselected by default. When the checkbox is selected, displayed expanders are exported with data entry form table area in the current view. If expanders are collapsed, all nesting elements of table area with collapsed and expanded expanders are exported. Expanders can be used to work in Microsoft Excel.

NOTE. The parameter is available only for export to XLSX file.

Sheets and Cells Protection. When the checkbox is selected, sheet and cell protection will be exported.
Formulas. The checkbox is selected by default. When the checkbox is selected, formulas on data entry form sheet will be exported. If the checkbox is deselected, only values are exported.

NOTE. Formulas that use OR are not exported.

If Excel does not support the function, the formula cell will display a text or numeric value.

If the exported data entry form contains formulas with links to other form sheets that were not included to export, calculation of such formulas will result in a calculation error.

Chart export features:

When formulas with the Irr, TBillEq, TBillPrice, TBillYield functions are calculated, an error occurs in exported files because of the features of their implementation in Microsoft Excel documents.
Calculation results of formulas with the Rand function differ in exported files from corresponding values in the data entry form due to the features of their implementation in Microsoft Excel documents.
Formula calculation results with the functions GetSelectionEl, GetSelection, JarqueBeraStat, NormsDist, OddlPrice, OddlYield, RedemptionYield, RndPermutation, RndSample, Slope, Sum, TimeValue are exported as text.

Conditional formatting of cells is exported with the following restrictions:

Conditional formatting is supported only by Microsoft Excel 2007 or later.
Some designations in the output file may differ from designations used in the data entry form.

There are the following restrictions for the number of rows and columns during the export:

XLS. Maximum number of columns - 256, maximum number of rows - 65536.
XLSX. Maximum number of columns - 16385, maximum number of rows - 1048576.

When saving a data entry form to ODS the Export dialog box looks as follows:

Set the parameters:

Hidden Rows and Columns. When the checkbox is selected, hidden areas (if available) are exported and can be worked with using OpenOffice or LibreOffice tools.
Formulas. When the checkbox is selected, formulas on data entry form sheet will be exported. The checkbox is deselected by default, and only formula values are exported.

Chart export features:

The PercentRank function is exported without taking into account the Significance parameter.
The OddfPrice and OddfYield function return error results because of their incorrect implementation in OpenOffice documents.
When formulas with the functions NormsInv, Irr, Prob, TBillEq, TBillYield are calculated, an error occurs in exported files because of the features of their implementation in OpenOffice.
Calculation results of formulas with the MDuration, PercentRank, Price, Rand, RndPermutation, RndSample, TBillPrice, YieldF functions differ from exported files from corresponding values in the data entry form due to the features of their implementation in OpenOffice documents.
Formula calculation results with the functions Aggregate, GetSelectionEl, GetSelection, JarqueBeraStat, NormInv, NormsDist, OddfPrice, OddlPrice, OddfYield, OddlYield, RedemptionYield, RndPermutation, RndSample, Slope, Sum, TimeValue are exported as text.

Hidden pages are not exported to this format.

There are the following restrictions for the number of rows and columns during the export:

Maximum number of columns - 1024.
Maximum number of rows - 1048576.

NOTE. It is recommended to open the ODS file with data entry form export results using OpenOffice or LibreOffice packages. An attempt to open the file using Microsoft Excel may result in incorrect displaying of file contents.