next up previous contents index
Next: 10.1.7 Importing Text Files Up: 10.1 Importing Data into Previous: 10.1.5 Importing Data from

10.1.6 Setting Import/Export Options

       

NExS gives you additional control on importing or pasting text into the spreadsheet using the Import Options dialog window. These options determine how the contents of the text file is parsed and placed in cells.

To change import/export options:

  1. Select Import/Export Options... from the Options menu to display the Import Options dialog box as shown in Figure 10.1.

  2. Select from the following options:
    One Word Per Column -
    Allows you to import a text file where blank spaces in the file are used as delimiters. Text strings are imported as text and numbers are imported as numeric values. A string or a value is placed in each corresponding cell.
    Whitespace Threshold -
    This option allows you to indicate what percent of all lines must have a blank in the exact same location for that location to be recognized as a field delimiter. The extreme cases (0 and 100) have the following properties:

    0 -
    The import creates only one column; the entire text of the line goes into the cell.

    100 -
    In order for a column to be defined, a blank must be in the same relative position in every row.

    Auto-escape LaTeX special characters -
    When enabled, characters embedded in text strings which are special to LaTeX, such as ``$'' and ``%'' will automatically be converted to their proper escape sequences when cells are exported in LaTeX tabular format. This mode will produce correct LaTeX translations for most ISO-Latin1 character codes, as well. When disabled, the user is responsible for embedding the proper escape sequences in the cells' text strings. (The disabled mode is generally only useful for producing LaTeX-specific content in an exported cell, such as a mathematical formula.)
    Reset to Defaults -
    Restore default settings.

   figure3265
Figure 10.1: Import Options Dialog Box


next up previous contents index
Next: 10.1.7 Importing Text Files Up: 10.1 Importing Data into Previous: 10.1.5 Importing Data from

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