TOC : Basic features > Save the report > Save as a XLS file | Top Previous Next

Click the Save icon on the toolbar. Select the file format to Microsoft Excel 97-2003 File(*.xls), click the [Option] button.
Auto Select : | Auto Selected : "Fit to" option of Excel's Page Setup dialog box. Width : "page(s) wide by" option of Excel's Page Setup dialog box. Height : "tall" option of Excel's Page Setup dialog box.
Display option : | Show gridlines : Show gridlines on a Excel's worksheet.
Text control : | Shrink to fit : "Shrink to fit" option of Excel's Format Cells dialog box.
Ratio : | Zoom In/Out : Sets a worksheet magnification.
Freeze panes : | Row : Sets "Freeze Top Row" option of a worksheet. Column : Sets "Freeze First Column" option of a worksheet.
Save mode : | Keep the report form : Save the report keeping original forms and properties as much as possible. Ignore color, border, merge cell :Save the text of label as a simple list, but ignore label color, border, and merge condition. At this time all blanks between pages are automatically removed. Remove adjacent cell after dividing : Remove adjacent cells after spliting the merged cell. For example, if a merged label in the report is divided into four cells in the Excel, the only one cell on the left top remains and all the other cells will be removed. The cell on the right side of the removed cell moves to where the removed cell was located.
Save type : | Column pages per sheet : If crosstab or chart have multiple vertical pages on the same column, these vertical pages are saved into the same sheet. Page per sheet : Create one sheet per page. Column first : One sheet per page in column direction. Row first : One sheet per page in row direction.
Page : | Remove blank lines between pages : Remove blank lines between pages.
Font : | Size : Font size for all cells in excel to be created. If not set the font, every label is saved using its own font size.
Line : | Remove line: Specify lines or range of line to be removed and not saved. Except first page : Remove lines from the second page to the last page. Only first page : Remove lines from only the first page. All pages : Remove lines from all pages.
Format : | Numeric type text convert to number : Specify the display format for numeric string. The format string entered in the text box will be applied to display format of cells in excel. The category in display format will be determined by the excel program. For example, the category can be "user defined" or "currency" for the format "#,###.00". If open an excel file saved not checking this option, the cell with numeric text shows error correction icon(). Apply to numeric format label only : Apply the display format to only the numerical type labels. Uncheck this option to apply the format to all types of label. Convert general(cell format) : Set cell display format to "general".
Minimum Cell Size : | Width : Minimum cell width. When save a report label into an Excel’s cell, and if the cell width is smaller than this value it will merge with the cell on right side. Height : Minimum cell height. When save a report label into an Excel’s cell, and if the cell height is smaller than this value it will merge with the lower cell.
Save format : | Save as mht : Save report in mht format of Excel.