Here you can edit spreadsheet rows. Some of these menu functions are also available in the document window's toolbar.
This function adds a new row at the end of the document.
Use this function to insert one or more rows to the document, at its beginning or end, or in front of or behind the currently selected row, respectively. A form sheet will be opened where you can define the number of rows and its insert position.
This menu item can only be selected when at least one row of the document has been selected. After a (suppressable) security alert, the selected rows will be removed. This delete function is undoable.
Remove Deselected Row(s). Using the alternate menu item acts accordingly and removes all deselected rows.
This menu entry can only be selected when exactly one row of the document has been selected. When you choose this function, the currently selected row will be used as header row. The cell contents of this row are the column header titles then and the row will be removed from the document.
Use this menu item to sort all rows alphabetically in ascending or descending mode. CSVEditor supports both the common alphabetical sort order and the natural sort order. The natural sort order depends on your settings in the Language & Region pane of the System Preferences. A form sheet will be shown where you define the sort criteria.
Hint: You can also sort single rows by drag and drop with your mouse pointer.
This powerful function shows all duplicate rows, where you can choose whether all columns contents or just the contents of a certain column should be considered. A form sheet will be shown where you define the relevant criteria for content comparison.
Then a Overview of Duplicate Rows
view will be shown in the
document window. Some edit functions for the document are now
disabled. Use this mode to visually decide which duplicate rows you
want to remove or keep.
To return to the normal document view, click the [Done] button afterwards.
This function basically conforms to the previously function
Show Duplicate Rows
. But here CSVEditor removes all duplicate
rows immediately and automatically after you have defined the
criteria. From each duplicate row group one row will be kept.
With these functions you can shift (move) the content of all selected rows to the left or to the right.
Important: These functions delete data field contents,
when they are moved from the first column further to the left or from
the last column further to the right. If you want to move data field
contents from first to the last column instead, better choose the
function group Rotate Content to ...
. All these functions are
undoable, of course, so you will not really have to fear data loss.
These functions rotate the content of all selected rows to the left or right. Hereby no data will be deleted because e.g. data cell contents which rotate out of the document to the left, will be inserted again in the last cell at the right.