next up previous contents index
Next: 10.2.3 Exporting Data in Up: 10.2 Exporting Data from Previous: 10.2.1 Exporting Data in

10.2.2 Exporting Data in NExS Format

     

It is sometimes useful to export a range of cells from one NExS spreadsheet for import into another, preserving cell data and formulas but not altering all of the sheet characteristics such as column width, row height, and grid lines. NExS supports this type of cell import and export through two methods:

  1. using the Export/Cells operation, which exports a range of data or the entire spreadsheet to an intermediate file for later import to another spreadsheet using the Import/Cells operation, and

  2. using the Paste operation, which transfers a selected range of data between two active spreadsheets.
Both methods transfer formats, fonts and formulas. For both methods, NExS updates cell references as appropriate. However, if the exported range contained references to cells outside the range, it will create error messages when imported into another spreadsheet.

Exporting Data using the Export Cells Operation

The Export/Cells operation creates an export file of the data in a selected range. This file (with the extension .xc3) can be imported into another NExS spreadsheet using the Import/Cells operation described in section 10.1.3, earlier in this chapter.

To export data using the Export/Cells operation:

  1. Select Export from the File menu. NExS displays the Export Data dialog box as shown in Figure 10.3.

  2. Select Cells for the File Format.

  3. In the Selection entry box, enter a name for the intermediate export file.

  4. Click OK or press [Return]. NExS creates the export file in the specified format. You can import this file into another spreadsheet program in a separate operation.


You can also export NExS formulas and values to another active spreadsheet using the Paste operation, which involves only a few simple mouse actions. For more information about pasting data, see section 10.1.4, Importing Data Using the Paste Operation, earlier in this chapter.


next up previous contents index
Next: 10.2.3 Exporting Data in Up: 10.2 Exporting Data from Previous: 10.2.1 Exporting Data in

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999