Excel Export

Whether you export excel from designer or browser, you can choose to export as full page, unaltered and page to sheet export.

This article will briefly introduce the differences of these three export methods.

Take the example of  %FR_Home%\webapps\webroot\WEB-INF\reportlets\demo\Report\Title Repeated, Total In-page and Conditional Warning.cpt  template to see the effect of the following three kinds of export.

Title Repeated, Total In-page and Conditional Warning.cpt

1. Full page export

During full page export, if the report template is paginated, it will be exported in the form of paginated results, and the repeated titles will also be repeated.

2. Unaltered export 

When unaltered exporting, even if the report template is paginated, it will not be paginated and will be exported continuously. If there are duplicate titles, the title will only be displayed once.

3. Page to sheet export

Each page of the report result is saved as a sheet in Excel file when the report is exported in pages and sheets.

Note 1: after the row-based engine is started, it does not support to export excel by page to sheet.

Note 2: the length of the sheet name in Excel should not be too long. If you need to export to excel, you should simplify the sheet name as much as possible.

Users can customize the report toolbar and add the required export button according to their needs. Please refer to Pagination Preview settings for details.

1. Exported content is inconsistent with the preview

Problem Description: after exporting excel, the header position of print preview is completely different from that of template preview.

Cause analysis: the upper and lower margins of template page settings are inconsistent with those of Excel page.

Solution: select menu template > page setup > page, and set the top and bottom margins to 12.7mm. As shown in the figure below:

2. if the exported data exceeds 15 bits, it will be displayed as 0

Problem Description: when the cell data exceeds 15 bits, only the first 15 bits are normally displayed in the exported excel, and the rest are displayed as 0, as shown in the following figure:

Cause analysis: Excel's own logic causes this problem. Only the first 15 digits can be recognized, and the ones after 15 digits will be displayed as 0.