The Excel export creates Microsoft Excel® documents. The creation is independent of any installed version of this product, i.e. the export is native. Depending on your needs, the full layout can be conserved during export, or only the data from table objects is exported unformatted.
Limitations
The following limitations should be considered:
▪ Excel renders texts with an increased height compared to the standard output. Thus, all fonts are scaled down by an optional factor. You may set this factor using the Font scaling option.
▪ Excel does not accept any objects on the non-printable area of your printer. This results in a wider printout.
▪ RTF texts are exported without formatting.
▪ Tabs will be replaced by blanks.
▪ The option 'Separators fixed' in the table object is not supported.
▪ The option 'Fixed size' in the table object is not supported.
▪ Fill patterns are not taken into account.
▪ Chart and HTML objects are exported as pictures and thus cannot appear transparently.
▪ The print order of lines and rectangles is disregarded, lines and rectangle frames always appear in the foreground.
▪ The print order of texts and rectangles is disregarded, text always appears in the foreground.
▪ Texts partially overlapping filled rectangles are filled completely.
▪ Overlapping text and picture objects are ignored.
▪ Lines that are neither horizontal nor vertical are ignored.
▪ Picture objects are rendered with a white frame.
▪ Large filled areas in projects with many different object coordinate values can decrease the speed remarkably.
▪ Line widths are ignored.
▪ Rectangle shadows cannot be exported.
▪ If coordinates of different objects are very close to each other but not identical, frame lines may become invisible because Excel cannot display them anymore.
▪ Rotated RTF objects and pictures are not supported.
▪ Objects that are exported as pictures must not extend out of their object frame. Therefore, for example, barcode objects with a fixed bar width must be designed in the Designer in such a way that the content always finds room in the object rectangle.
▪ If the coordinates of two objects are only slightly different (i.e. a fraction of a millimeter), frame lines might become invisible as Excel is not capable of displaying them correctly.
▪ Gradient fills are not supported.
▪ Texts rotated by 180° are not supported and are displayed with 0° rotation.
▪ Paragraph spacing is not supported.
▪ Negative values for spacing are not supported.
▪ The maximum number of Excel columns is limited to 256.
▪ Issue print is not supported.
▪ Shadow Pages are not supported.
▪ The wrapping option 'Minimum Size' in the crosstab object is not supported.
▪ Expandable Regions for crosstabs are not supported.
▪ Frame inner offsets are not supported.
▪ Background color of the report container is not supported.
▪ For the security option "Protect spreadsheets" no Unicode characters and a maximum length of 29 characters are supported for the password.