Report Export

When saving the report to XLS and XLSX format, 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, the list with sheets contains hidden report sheets. On exporting the entire report, hidden sheets are also 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.

• Charts as Images. When the checkbox is selected, charts are exported as EMF images. If the checkbox is deselected, they are processed as charts using Microsoft Excel tools.

NOTE. Chart types, which do not support XLS and XLSX, are exported as images. When a waterfall chart is exported to XLSX, the chart appearance will differ from the original one because of difference in settings.

• Sheets and Cells Protection. When the checkbox is selected, sheet and cell protection will also be exported.

• Formulas. The checkbox is selected by default. When the checkbox is selected, the formulas located on report sheet are exported. If the checkbox is deselected, only values are exported.

NOTE. Formulas that use OR are not exported.

If the function is not supported in Excel, the formula cell shows a text or numeric value.

If the exported report contains formulas referring to other report sheets, which have not been exported, calculation error occurs as a result of calculation.

Chart export features:

• If the range of series (points) names is defined as an open range (entire row or column), after the export, the cell located at the intersection of data range and range of the series (points) names is selected as the name of the range (point).

• Types of data series fill in the output file and in the regular report may differ.

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.

• Formula calculation results with the Rand function differ in exported files from corresponding values in the report because of 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 symbols in the output file may not coincide with those in the regular report.

There are the following restrictions on 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 report to ODS, the Export dialog box looks as follows:

Set the parameters:

• Hidden Rows and Columns. When the checkbox is selected, hidden areas (if present) are exported and can be worked with using OpenOffice or LibreOffice tools.

• Formulas. When the checkbox is selected, the formulas located on report sheet are 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 for formulas with the functions MDuration, PercentRank, Price, Rand, RndPermutation, RndSample, TBillPrice, YieldF differ in exported files from corresponding report values because of 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.

Sheet objects (charts, maps, and so on) are exported as images.

There are the following restrictions on 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 ODS file with report export results by means of OpenOffice or LibreOffice software. On an attempt to open the file by means of Microsoft Excel the report appearance may be distorted.

The report in the output PDF file looks the same as the regular report opened for preview before printing.

If maps, charts and shapes located on a report sheet do not contain settings that cannot be exported to PDF files (dashed lines, alpha-channel), they are exported to PDF as vector images, otherwise, as bitmaps.

On exporting to this format, please note that:

• Cell textures in the output file and in the regular report may differ.

• Symbols of chart data series may be displayed differently in the output file and in the regular report.

• Data series names may be displayed incomplete in the legend.

• Chinese or Arabic characters may not be displayed fully or correctly.

When saving a report to RTF, the Export dialog box looks as follows:

Use the Page Breaks checkbox to set up export of page breaks between report sheets. The checkbox is selected by default, and page breaks are exported.

On exporting to this format, please note that:

• The output file and regular report may display different font settings and line spacing.

• Maps and charts are exported to RTF as metafiles.

• Top and bottom indents in cells are not exported.

• Cell text rotation is not exported.

When saving a report to PPTX, the Export dialog box looks as follows:

Select the Charts as Images checkbox to export charts as EMF images. The checkbox is deselected by default, charts they are processed as charts using Microsoft PowerPoint tools.

NOTE. All types of regular report charts are exported as interactive objects except for secondary histogram, scatter chart and secondary pie chart.

On exporting to this format, please note that:

• Some symbols in the output file may not coincide with those in the regular report.

• If the regular report contains cell formatting, only one formatting type with the following priority will be loaded:

1. Image.

2. Conditional formatting.

3. Cell fill.

When saving a report to HTML and MHT, the Export dialog box looks as follows:

Select the Cells Auto Height checkbox to autofit cell height in accordance with the information they contain.

NOTE. Row height and column width in the output file are greater comparing with sizes in the source report, even if the Autofit Cell Height checkbox was selected on export. This feature is caused by how browsers work with text.

On exporting to this format, please note that:

• The scale selected for the report's data display is taken into account.

• Cell textures in the output file and in the regular report may differ.

• Cell text rotation is not exported.

• Text wrapping parameters in cells are not exported.

• Diagonal cell borders are not exported.

• Medium and double solid cell borders are not exported: these borders are replaced with a thin solid line.

NOTE. The following solid cell borders can be used in regular reports: thin, medium, thick and double borders.