Workbook Export

On exporting to the XLS or XLSX format the Options of Export to XLS or Options of Export to XLSX dialog box opens. The dialog boxes look identically:

Export options:

• Charts as Images. By default, the checkbox is selected, and charts are exported as images in the EMF format, they can be edited as images by means of Microsoft Excel. If the checkbox is deselected, charts are exported as objects that can be edited as charts by means of Microsoft Excel.

NOTE. The charts that do not support XLS and XLSX formats are exported as images. When exporting waterfall chart to the XLSX format, chart appearance will differ from the source format due to mismatching settings; when exporting to the XLS format, the system suggest using the XLSX format.

• Whole Report. By default, the radio button is selected, and all workbook sheets are exported.

• Selected Sheets. To export selected sheets, select this radio button and select checkboxes that correspond to the required sheets.

Each data view in the output file is located in a separate sheet.

Features of export to Excel:

• Cell texture in the output file may not match with that set up in the workbook.

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

• If the table contains footnotes:

• By default footnotes are not exported. Footnote numbers are exported if the appropriate setting is determined by means of the Fore language. Footnote text is not exported.

• Format of the cells with footnotes is changed to text. Consequently:

• Chart appearance may differ from the chart appearance in the source workbook.

• Formulas with defined footnotes are shown as text.

• Formulas that refer to footnote cells are not calculated.

On exporting a workbook containing cell formatting, only one formatting type is loaded into PowerPoint presentation with the following priority:

1. Image.

2. Conditional formatting.

3. Cell fill.