Next: 10.2.3 Exporting Data in
Up: 10.2 Exporting Data from
Previous: 10.2.1 Exporting Data in
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:
- 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
- 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.
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:
- Select Export from the File menu. NExS displays the
Export Data dialog box as shown in
Figure 10.3.
- Select Cells for the File Format.
- In the Selection entry box, enter a name for the
intermediate export file.
- 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: 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