The Excel export module creates documents in the Microsoft Excel® format. The creation of these documents is independant of an existing installation of MS Excel. The export module is thus native. The choice is to either export the file including all layout elements or to export the unformated data only to the new file.

 

The following limitations and notes are valid when using the Excel export module:

 

•Texts run slightly higher in Excel than in other standard outputs. Therefore fonts are scaled by an adjustable factor. This factor can be set by using the option NTPOPTION_XLSEXP_XLSFONTSCALING.

 

•The printable area cannot be adjusted in Excel to include the non-printable margin. Therefore projects seem slightly wider. This can be compensated by using NTPOPTION_XLSEXP_XLSPRINTINGZOOM when printing.

 

•RTF texts are - if the option is set - embedded as JPEG files. This slows the export process down considerably and increases the file size. We recommend to not use RTF text if at all possible respectively to reduce the image file size (see below). RTF text is exported without formatting by default.

 

•Tabstops in text objects are replaced by spaces.

 

•The table object option "extend separators" is not supported.

 

•The table option "fixed size" is not supported.

 

•Background patterns are not supported. The fill will always be a color. The HTML and chart objects are exported as images and can therefore not be displayed in a transparent form.

 

•The printing sequence line/rectangle is not supported; lines are always shown in front. This is also true for rectangle borders.

 

•The printing sequence text/rectangle is not supported; text is always shown in front.

 

•Lines that cut text objects will be interrupted.

 

•Text objects that overlap a filled rectangle only half will not be partially filled.

 

•Overlapping text respectively graphics objects are ignored.

 

•Lines that are neither vertical nor horizontal are ignored.

 

•Image objects have a white border.

 

•Large filled areas in projects with many coordinates may slow the speed considerably.

 

•Line width cannot be exported, lines are always displayed in the standard width.

 

•Rectangle shadows cannot be exported.

 

•If ccordinates of different objects are close together but not identical, border lines may disapear as Excel can no longer display these.

 

•Rotated RTF objects and images are not supported.

 

•Borders of text objects are not supported.