The Data Editor¶

If the Data-Browser is active, the Edit button opens the following dialog box:

../../_images/dateneditor-menu-dlg-2-en.png

Load¶

To load a dataset, select the appropriate type, choose the channels and press the Load button. See File=>Import Data.

Copy¶

This command copies the selected range in text format into the clipboard. The channel name and unit will be written above the data values. A tab character (\t) is used to separate the columns and a new line character \n to separate the records.

If the range contains multiple selections, the bounding range will be calculated and used as the copy range.

The number of cells that will be copied is limited to 100000.

Freeze Columns/Unfreeze Columns¶

With this command the selected columns can be frozen. The frozen columns will be displayed with a gray background color at the left edge of the grid. The frozen columns will stay in their position when you scroll.

Mark Records as Deleted¶

This command marks the selected records as deleted. A new channel with the name ___Delete_XXX___ will be created. XXX stands for the dimension name. The channel values have the following meaning:

Value	Meaning
0	Record not marked as deleted
1	Record marked as deleted

The values can be edited manually (set to 0 or 1).

To remove the selected records once and for all, choose Remove All Marked Cells. As long as the records and channels are not finally removed UniPlot will ignore the delete flag, e.g. the load function will also load the records that are marked as deleted.

Mark Channels As Deleted¶

This command will mark all selected channels (columns) as deleted. The cells will be displayed in red on white background.

Remove Records¶

This command will remove all selected records. The records will be removed from the NC file. The command cannot be undone.

To delete records, select one or more rows by clicking on the record number button. Hold down the Shift-key to select a range of records. Hold down the Ctrl-key to select another record or deselect a record.

Remove Channels¶

This command will remove the selected channels (columns). The command cannot be undone.

To delete channels select one or more channels by clicking on the channel name button.

Shortcut: Ctrl+DEL

Remove all Formula Channels¶

This command removes all channels from the NC file which where calculated by the formula interpreter. A formula channel contains a channel attribute _channel_type with the value “formula”.

Remove all “Missing Value” channels¶

The command removes all channels in the NC file which contain only missing values.

Remove All Marked Cells¶

This command can be used to remove marked as deleted records and channels. The command cannot be undone. Records and channels which are marked as deleted are displayed in red on white background. Because the action cannot be undone, the following message box will be displayed:

../../_images/FileDataImport_Warning-en.png

This message is also displayed if you want to load a dataset, to close the data browser or if you want to specify a record filter.

To remove the delete flag choose Remove Delete Flag.

Remove Delete Flag¶

This command removes the delete flag from all selected records and channels.

Add Channel¶

This command adds a new channel to the active NC file. The channel name can be specified in following dialog box:

Insert Records¶

This command inserts new records (rows) into the active NC file.

The number of records and the insert position can be specified in the following dialog box:

../../_images/FileDataImport_InsertRecords-en.png

Cell values for the float and double data types will be initialized as missing. Cells of all other types will be initialized with the value 0 or an empty string.

Add Formula Channel¶

See Formula Interpreter 1 - Introduction.

Add Attribute¶

This command adds a channel attribute or a global attribute to a NC file.

../../_images/FileDataImport_AddAttrib-en.png

Delete Attribute¶

This command deletes a channel attribute or a global attribute.

../../_images/FileDataImport_DeleteAttrib-en.png

Rename Channel¶

Renames a channel.

../../_images/FileDataImport_Rename-en.png

The name must begin with an alphabetic character or an underscore, followed by zero or more alphanumeric characters including underscores (_) or digits. Case is significant.

The name must be unique within the NC file.

Go To Record¶

Goes to the specified record.

../../_images/FileDataImport_Goto-en.png

(Short Cut: Ctrl+G)

Save As¶

This command saves the active NC file as a new file and displays it in the browser.

Add Data¶

This command adds data from one or more files to the active NC file. Data will only be added if at least one channel name matches a channel name in the active file. All added channels must have the same number of data points.

The data of missing channels will be set to value missing.

See Browser=>Add Files.

Export¶

An NC file can be saved in the following data formats:

Type	Description
Text	Data is saved in a text file.
Text-UTX	Data is saved in a text file with UTX format key words.
TDM	Data is saved in the National Instruments TDM DIAdem format.
Excel	Data is saved in the Biff 2.1 `.xls` oder in the Excel 2007 file format `.xlsx`.
Excel-UTX	Data is saved as Biff 2.1 `.xls` (maximum of 16834 rows) or in the Excel 2007 file format `.xlsx` (maximum of 1,000,000 rows). In `.xlsx` files one sheet is created for each dimension in the nc file. The created file can be imported using the UTX import filter.

Open¶

Opens a new data file. See File=>Import Data.

Sort¶

See Browser=>Sort.

Classify Data¶

See Browser=>Classify.

Configuration¶

Configuration can be set in the following dialog box:

../../_images/FileDataImport_Options-en.png

See Browser=>Options.

Undo/Redo¶

The Undo command can undo changes to cell values.

Short cut for undo: Alt+Backspace

Short cut for redo: Ctrl+Backspace

Comment¶

The source code of the functions in the shortcut menu are located in the mn_grid.ic and netcdf.ic files.

_id-1242969