Sfairadora

  • Reference Guide

Table Data and Presentation Appearance

Inserting and Removing Rows

The easiest way to insert a row in a table is to type values into the empty row at the end of the table. This creates a new row. An empty row always remains at the end of the table – its purpose is to allow the user to insert new rows. Unless the table rows are ordered, a new row may be inserted at any desired position in the middle of the table by the Insert key.
Depending on the setting of the given table, insertion of a new row may either create a candidate row or directly insert the row into the table data. A candidate row is a fictive table row displayed in between the real rows in which values intended for insertion into the table may be typed. The row is properly inserted into the table data after you click the Insert button on the right hand side of the candidate row (or when you use the Shift+Enter keyboard shortcut). You can also cancel the candidate row without inserting it by clicking the Cancel button located just next to the Insert button.
If, for example, a table view is filtered, and the inserted row does not satisfy the filter condition, the row is inserted into the data, but is not displayed, so it may seem that it has not been inserted. However, it appears when you cancel the filter.
You can remove a row by pressing the Ctrl+Delete keys or by the tool bar button. You can use the same technique to remove multiple rows at the same time provided that the rows you wish to remove are selected.

Selecting Rows

If you need to remove, copy or move multiple rows at the same time, you must first select the rows that are to be affected by the operation. The following commands are used to select rows:
Key
Function
Shift+↑, Shift+↓
Moves across rows and selects the passed rows (more accurately: it inverts the selection status – it deselects the rows that had been selected before).
The range of selected rows begins with the last active row. To select more ranges, set a new beginning by the Ctrl+space keys or by Ctrl+mouse click.
Ctrl+↑, Ctrl+↓
Changes the row cursor position without canceling the selection.
Ctrl+space
Selects a row where the row cursor is located (or deselects it if it had been selected before).
Ctrl+mouse click
Selects the row on which you clicked (or deselects it if it had been selected before).
You must click the row label on the left (the box showing the row number).
Shift+mouse click
Inverts the selection of a range of rows between the click and the active row (if nothing has been selected yet) or the last row selected by Ctrl+space or Ctrl+mouse click.

Copying and Moving Rows

Copying and moving is described in general in a separate chapter. Table rows can be copied to the following destinations:
Target
Result
Another table
Inserts copied rows into the target table. If the two column structures differ, values in columns of the same name are copied.
Data document section
Creates a new table in the Data document section with the same columns as the source table and inserts the copied columns into the target table.
Creates a text representation of the copied data and inserts it into the text. This allows you to easily create a corresponding text table.
You can use the same technique to copy data into a text editor of another application outside Sfairadora.
Rows, just like any other data, can be copied also between documents.
You can also change the position of a single row in the table by grabbing its label on the left and dragging it to the desired position.

Column Width

Column width is set automatically according to the width of its contents (more precisely: according to the longest value in the column). Nonetheless, the required width can be manually adjusted by grabbing the boundary between columns in the table header and dragging it with the mouse to the required position. The width set this way will not change, and if the length of any cell contents exceeds the column width, only a part of its contents will be displayed. Fixed column width is indicated by a tiny square mark on the boundary between columns in the header . If you wish to release the column width so that it starts changing according to the length of its contents again, simply double-click the boundary between columns in the header.

Selecting Columns

Columns are selected similarly to rows. You can select and deselect a column by Ctrl+mouse click. A range of columns can be selected by Shift+mouse click (the first click determines one end of the range and the second click the other end). Selecting multiple columns is useful if you need to copy them, remove them, hide them, or display their properties, etc. – all at once. Some operations (such as displaying column properties) require that a cell of the column is active. If the cells do not have contents that can be made active, the column(s) must be selected.

Displaying and Hiding Columns and the “Details” Column

If a table has too many columns, its appearance may become messy, or the entire table may even not fit in the screen. In this situation it is useful to hide some columns. The easiest way to do this is through the Displayed Columns section in the context menu, which contains a list of all columns. If a column is displayed, the respective menu item is checked. You can switch between displayed and hidden condition by clicking the item. If you wish to display or hide multiple columns at once, hold down the Ctrl key while clicking and switching the check mark or use the spacebar on your keyboard. These techniques prevent the context menu from closing immediately.
All tables created automatically by Sfairadora contain a column named Details. This column is initially hidden. If displayed, you will see a Details button at the end of every row. If you click the button, a window appears, showing a comfortable overview of all elements of the row. This is particularly useful for tables with many columns, where only the most important columns are displayed – you can easily display complete information about a table row by clicking the Details button.