Sfairadora

  • Reference Guide

Column Properties

Column properties can be explored and modified in the Column Properties window. The window is invoked by the Column Properties command in the context menu of a table. The same command is located also in the Table menu and in the tool bar. The window displays the properties of the column in which a cell is currently active. If one or more columns are selected, it displays their properties. The window is not a “modal window”, that is, you can continue working with the table as you wish while the window stays open. The contents of the window change as you switch between cells or selected columns.
Three levels of column properties are displayed in the window under each other: data properties, view properties, and presentation properties. The view properties of columns that copy data are usually hidden because they largely follow the data properties. The simplified editor option near the top of the window is used to hide the view properties. If it is checked, the view properties are not displayed. The view properties are always displayed only for those columns that have been inserted to the table view by the user.

Data

In the data properties section, you can rename a column and change its type. The data type editor is used to change the type. If table data is stored in the Data document section, which is the most common case, a change of a column name or type is equivalent to a change made in the Data Type section.

View

The view properties section should be used only for columns that have been inserted to the view by the user. It is not advisable to change the view of the columns that have been automatically created by Sfairadora to reflect the values of the data columns. Again, you can change the name and type of the table view columns that have been created by the user (mostly computed columns). The data type editor is used to change the type. The most useful feature of the computed columns is probably the possibility to easily modify the expression by which they are computed. In the case of a table creating a local view of data (such as tables created to display records in the Data document section), a change of the view changes only the appearance of the table and is not reflected anywhere else. By contrast, in the case of a table displaying records in the View section, a change made in this window is equivalent to a change in the View Type section.

Presentation

The presentation properties section is used to edit appearance and specify further information. This section contains both properties of the actual column (see the table below) and definition of the controls included in the column cells. Presentations are modified by means of the dispel definition editor. If the presentation of a cell is realized by a line editor, which is the most common case, users will probably often take advantage of the option to set the precision (number of decimals) of columns of the real number type (Real).
Column presentation items:
Operation
Description
Column width
Required fixed length of the column. Setting the width here is equivalent to setting the width by dragging the column boundary with the mouse. If no value is set, the width is adjusted automatically according to the width of the contents.
Reference of column data
Reference to data displayed in the column. The reference is relative to the table row, so in the simplest situation the reference to a simple column called name will be just name.
Data reference is important for the possibility to order the table by clicking a column header. This reference determines the data by which the table should be ordered.
Furthermore, it determines the data referenced by the cell_data identifier.
Title
Text displayed in the column header.
Alignment
Alignment of the title.
Fully displayed
If the option is checked, the column width is set so that the entire title is visible. If not, the width may be smaller – so only a part of the title with three dots at the end is displayed.
Icon
Icon displayed to the left of the title. See the icon editor.
Column family
The column family determines whether the column can be ordered, which operations are available for the column filter, or that a special column type is concerned.
The following options are available:
simple
the simplest column setting. The column cannot be used for ordering and available filter is limited to equal, not equal, data present, and data not present.
ordered
table can be ordered by the column, and filter options include also the comparison of values.
string
column values are strings. Same as the ordered column, plus the filter options also include tests for a substring.
array
column values are arrays.
sequence
column values are subordinate sequences/tables.
column group
the column has no own data, it only serves as a common header for other subordinate columns.
Horizontal alignment
Determines the horizontal alignment of cell contents. The options are: left, center, right, and auto. Auto determines alignment according to the column data type: numbers are aligned to the right while all other values to the left.
If a line editor is present in the column, its alignment is also specified. If you leave the auto option in place, its alignment is inherited from the column setting, otherwise the editor setting overrides the column setting, and the column setting is suppressed.
Other
Vertical alignment
Vertical alignment of the control in the column cell used when the row is higher than the column control. The options are: top, center, bottom, in block, and auto. The in block option spans the control in the vertical direction over the entire height of the row provided that the given control allows it. The position of the actual contents of the control depends on its particular properties.
Vertical indent
Indentation of the control in pixels. If aligned to the top, the control is shifted from the top margin downwards. If aligned to the bottom, the control is shifted from the bottom margin upwards. If aligned to the center, the control is shifted relative to the cell axis – negative values cause an upward shift and vice versa.
Identifier
Column identifier. It must be unique for the given column group. It is used to identify the column in the table state object. Initially, its value is set equal to the object name of the column. Usually there is no need to change this setting.
Required minimum width
Minimum width in pixels. It prevents the automatically determined column width from exceeding this value.
Required maximum width
Maximum width in pixels. The automatically determined column width must not exceed this value.
Space before column
The space (in pixels) left between the left border of the column and the control contained within.
Space after column
The space (in pixels) left between the right border of the column and the control contained within.
Column initially hidden
This option indicates, in the table definition editor, that the column shall be hidden when the table is displayed for the first time. It has no significance here.
Separator before column
The column is separated from the preceding column by a marked line.
Background
You can select the column background color that will be applied to the cell areas outside the control (e.g. when the row is higher than the cell control).
Summary exceptions
Allows you to enter specific expressions (summary exceptions) for the calculation of particular summary types in the given column.
Name of the built-in tool: column_properties_tool