.. highlightlang:: us .. index:: Data Editor .. index:: y^data-editor .. _the-data-browser: .. _data-editor: The Data Editor =============== If the Data-Browser is active, the ``Edit`` button opens the following dialog box: .. image:: S:/uniplot-obj/images/dateneditor-menu-dlg-2-en.* Load ^^^^ To load a dataset, select the appropriate type, choose the channels and press the *Load* button. See :ref:`file-import-data`. .. _the-shortcut-menu: The Shortcut Menu ----------------- To display the shortcut menu, right-click on the data grid: .. image:: S:/uniplot-obj/images/dateneditor-menu-dlg.* 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: .. list-table:: :header-rows: 1 * - 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 :ref:`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 :kbd:`Shift`-key to select a range of records. Hold down the :kbd:`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: :kbd:`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-missing-value-channels: Remove all "Missing Value" channels ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The command removes all channels in the NC file which contain only missing values. .. _remove-all-marked-cells: 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: .. image:: S:/uniplot-obj/images/FileDataImport_Warning-en.* 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 :ref:`remove-delete-flag`. .. _remove-delete-flag: Remove Delete Flag ^^^^^^^^^^^^^^^^^^ This command removes the delete flag from all selected records and channels. .. add-channel: Add Channel ^^^^^^^^^^^ This command adds a new channel to the active NC file. The channel name can be specified in following dialog box: .. image:: S:/uniplot-obj/images/FileDataImport_AddChannel-en.* .. _insert-records: 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: .. image:: S:/uniplot-obj/images/FileDataImport_InsertRecords-en.* 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 :ref:`formula-interpreter-1---introduction`. Add Attribute ^^^^^^^^^^^^^ This command adds a channel attribute or a global attribute to a NC file. .. image:: S:/uniplot-obj/images/FileDataImport_AddAttrib-en.* Delete Attribute ^^^^^^^^^^^^^^^^ This command deletes a channel attribute or a global attribute. .. image:: S:/uniplot-obj/images/FileDataImport_DeleteAttrib-en.* Rename Channel ^^^^^^^^^^^^^^ Renames a channel. .. image:: S:/uniplot-obj/images/FileDataImport_Rename-en.* 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. .. image:: S:/uniplot-obj/images/FileDataImport_Goto-en.* (Short Cut: :kbd:`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 :ref:`browser-add-files`. Export ^^^^^^ An NC file can be saved in the following data formats: .. list-table:: :header-rows: 1 * - 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 :file:`.xls` oder in the Excel 2007 file format :file:`.xlsx`. * - Excel-UTX - Data is saved as Biff 2.1 :file:`.xls` (maximum of 16834 rows) or in the Excel 2007 file format :file:`.xlsx` (maximum of 1,000,000 rows). In :file:`.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 :ref:`file-import-data`. Sort ^^^^ See :ref:`browsersort`. Classify Data ^^^^^^^^^^^^^ See :ref:`browserclassify`. Configuration ^^^^^^^^^^^^^ Configuration can be set in the following dialog box: .. image:: S:/uniplot-obj/images/FileDataImport_Options-en.* See :ref:`browseroptions`. Undo/Redo ^^^^^^^^^ The Undo command can undo changes to cell values. Short cut for undo: :kbd:`Alt+Backspace` Short cut for redo: :kbd:`Ctrl+Backspace` Comment ^^^^^^^ The source code of the functions in the shortcut menu are located in the :file:`mn_grid.ic` and :file:`netcdf.ic` files. :sub:`id-1242969`