NExS can read and write the WKS and WK1 file formats commonly supported in other spreadsheet applications. When exporting a spreadsheet in WKS or WK1 format, much of the internal information is preserved, including formulas, named ranges, cell formats, and column widths. However, some features of NExS can not be represented in WKS/WK1 format; therefore, those features are lost when exporting in these formats.
Information which is lost when exporting a NExS spreadsheet in WKS or WK1 format includes:
\n
) characters in multi-line text strings.
When a NExS formula can not be exported properly due to limitations of the WKS/WK1 file format, the formula is exported as text so that the intent of the formula can be seen and understood by the user of the application into which the WKS/WK1 file is imported.
To export an NExS spreadsheet in WKS or WK1 format:
Remember that NExS exports the entire spreadsheet during the WKS/WK1 export operation.
To export only part of a spreadsheet, create a temporary spreadsheet that contains only the desired data, and export this file instead of the full original.
Figure 10.3: Export Data Dialog Box