• Reference Guide

Data Document Section

This section contains information constituting the actual contents of the document (tables, texts …). When you start working with a new document, you first need to create the required data in this section. In a newly created document this section contains only one table as an example without practical use. You will therefore need to edit it by inserting or removing desired columns or remove it completely (by the Delete button), and create desired tables or other data from scratch.
New data is created using the new data item located at the bottom of the Data section list in the left pane of the document main window. You can use the new data item in the Data Type section to the same effect. If the latter is the case, the data type editor is displayed in the right pane, in which you define the name and structure of the newly created data item. In the former case, the editor is opened in a separate window. Both cases are identical – if new data is created in the Data Type section, you can open the data type editor in a separate window by a double click and display the created item in the right pane by a single click in the Data section. This allows you to monitor the realization of the data type while modifying it.
The most common type of document data is Table or Formatted text. The Formatted text type allows you to use general text in the document. However, if you want to use Sfairadora only for texts, you can create a text document by the File|New|Formatted text menu command.
You can also define analytic data types (computed data items etc.) in the Data section, however, we recommend that they are reserved for views created from the data. From a technical point of view the Data section is not different from the View section – it can contain the same data items. However, it is advisable to separate the actual data from their views in order to preserve a certain system; this is why documents have these two sections.
An automatic presentation is created in the right pane of the document main window for items in the Data section. This is done internally by the universal dispel (which you can also use elsewhere when creating your own presentations). This automatically created presentation does not necessarily need to capture all user requirements, and therefore you can modify it by the Edit presentation command from the context menu or tool bar. You can save an automatically created and, if applicable, modified presentation to the Presentation section, where you can modify it further or use it as it is. Changes of the presentation can be revoked by the Reset presentation context menu command.
In the (typical) case when the Data section item is a table, no manipulations with the table view, such as row ordering, deduplication, filtering, grouping, or ungrouping, change the actual data, but only the local view of the data underlying the table presentation is changed. You can save these changes in the local view to the View section at any time by the context menu command or by copying (as described further on). You can also revoke them by the Reset presentation context menu command. This restores the view of the data to the form in which they are actually stored in the document.
Properties of individual items in the Data section can be found in the Data Type section.

Copying items to the Data section

Data section
Creates a copy of the data. You can also transfer data between documents.
View section
Creates data reflecting the instant state of the view.
(This is useful only in very special applications, such as when you need to create source data of an indirect dispel).
Outputs section
Saves the instant state of the source text. A text thus saved can be further modified.
Data Type or View Type section
(Not essential for common usage.)
(Not essential for common usage.)
Rows of a data table
Creates a new table with the same columns and inserts copied data into it.
Part of text
Creates an item of the Text or formatted text (Rich_text) type. This is useful for saving clippings from a processed text.
Picture or text from an application outside Sfairadora
Creates an item of the adequate type and inserts the copied value into it.

Copying items from the Data section

Data section
Creates a copy of the data. You can also transfer data between documents.
View section
Creates a view of the data. This operation makes sense mainly for tables because only tables have a non-trivial view. If a table has a view in the Data section (is ordered, filtered, etc.), the view created is identical to that one. This is useful for a quick save of a prepared view.
Presentation section
Creates a new presentation of the data. The presentation is the same as the presentation used in the Data section, so you can use this operation to easily create an initial presentation, which you can further modify, or, if you have already modified the presentation that had been automatically created in the Data section, your modifications are saved to the newly created presentation.
The presentation created this way has a universal dispel at its top level so that changes to data types are applied also to the structure of this presentation. If this behavior is undesirable, you can remove this root universal dispel in the dispel definition editor using the Remove intermediate dispel context menu command. The dispel definition editor is invoked, for example, by the context menu command of the respective item in the Presentation section.
If you preserve the root universal dispel, you can still modify the instant state of the presentation – the modifications made this way are preserved even if the type of the underlying data (and consequently also the appearance of other parts of the automatically created presentation) is changed.
Outputs section
Creates a text output template and hence also an output based on the presentation used in the Data section. If you, for example, copy a table, the output contains the columns that were currently displayed. Applied filters and table summaries are also reflected in the text output.
Creates a text representation of the data and inserts it into the text. This is especially useful for tables – you can easily create a corresponding table in the text.
Moreover, you can use this technique to copy data to an external text editor outside Sfairadora.
You can also use this technique to copy to the text only several selected table rows instead of the entire table.

Context Menu

For the Data section items in the left pane:
Menu Item
Edit Data Type
Displays a window with the data type. The command is equivalent to what you see in the right pane of the respective item in the Data Type section.
Create Output Template
Creates a text output template for the data. In case of a table, the instant state of the view (filter, ordering …) as well as the presentation state are reflected. The actual text output is then available in the Outputs section. A window asking you to enter the template name appears before saving. Text output reflects changes of source data. Changes of the source table view or presentation do not affect the text output.
Create Output Text
Creates output text based on the instant state of the data. You can either save the resulting text to the Data section or create a new text document. Before the text is created, a window appears, in which you can specify the name of the saved text or its location. The created text is independent of changes of the source table data or view.
Open in Window
Opens a separate window and displays in it the respective data, which would otherwise be displayed in the right pane. The same is achieved by double-clicking the item.
Reset Presentation
If modifications to the data presentation have been made, they are revoked, and the original automatically created presentation of the data is restored.
Edit Presentation
Opens the dispel definition editor to edit the automatically created data presentation.
Save Presentation
Saves the presentation to the Presentation section. This operation is equivalent to copying the item to the Presentation section.
The context menu of the right pane contains some of the commands listed above. If the right pane displays a table, which is the most common case, most of the context menu commands refer to the table.