Export to XLS or XLSX filesTo export:
Dashboard. Select the Export main menu item and select the required export format.
Selected object:
Display object control buttons:
Point the mouse cursor on the top right corner of the block:
Object control buttons are displayed, for example:
Click the button and in the menu that opens select the Export item.
Select the required export format.
Available export formats:
Excel Workbook (*.xlsx).
Excel 97-2003 Workbook (*.xls).
PDF Document (*.pdf).
RTF Document (*.rtf).
Web Page (*.html).
Web Page, single file archive (*.mht).
Image (*.emf ). The format is available only in the desktop application.
Image (*.png). The format is available only in the web application. If this format is selected, a new browser window opens with a final image, which enables the user to save a report to the file.
PowerPoint Presentation (*.pptx).
Prognoz Platform Dashboard (*.ppdash).
Prognoz Platform Mobile Dashboard (*.ppmobile). The format is available if the whole dashboard is exported.
NOTE. The PPDASH, PPMOBILE formats are Prognoz Platform 9 formats and are used to load a dashboard into a local file for further work without repository connection.
A dashboard will be exported to the file of the specified format.
On exporting the whole dashboard or its block it is available to set a file name that is different from the name of the corresponding repository object.
NOTE. Export to other formats can be implemented at the application level.
Depending on the selected format the following export features can be determined:
A dashboard is exported to the *.ppdash format with the following constraint: the Time Series report cannot be exported. On the next opening of the dashboard from the *.ppdash file, the corresponding blocks will be empty.
Export to all the other formats is available only for visualizers except for the Indicator visualizer and the Express Report, Time Series reports.
All blocks are exported with elements selection defined for them.
If a block contains a title and is placed on several pages on export, the block title is used as a header.
Sparklines are exported only to the following formats: PDF, EMF, PPDASH, PPMOBILE.
On exporting a dashboard to PDF and PPTX formats, block size is adjusted according to the set page parameters.
TIP. To set up page parameters, go to the Document side panel tab.
On exporting a dashboard containing footnotes in the Table visualizer, remember that:
Footnotes are exported only to the following formats: PDF, EMF, RTF, XLS, XLSX. On exporting to RTF format footnote numbers are ordered by pages: from the first to the last.
On exporting to XLS or XLSX:
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 containing footnotes will be changed to text. In this case:
A chart look may differ from that in the original workbook.
Formulas, for which footnotes are set, are displayed as text.
Formulas, which refer to cells with footnotes, are not calculated.
See also: