Sfairadora 0.0.83 Beta

Sfairadora 0.0.83 Beta is developed to be a helpful and beneficial program for small databases with functions of spreadsheet and text output.

If you feel that a spreadsheet is somewhat clumsy to manipulate your data, while developing a regular database would be overkill, you may like to try out Sfairadora. Sfairadora is a professional application designed to manage small databases, like list of your CD, books, customers, easy. Its aim is not to perform millions of transaction per second, but rather to be handy and flexible when working with smaller amount of data. In an intuitive way, you can group table by a column, create table with sub-tables (like list of customers with a list of orders for each individual customer), add computed columns, display summary information, filter tables in a query-by-example manner and perform other operations. 

A specific filtering, grouping and other manipulations made on a table can be stored as a view, which is then updated accordingly to changes made to the original table. In a similar way, a text output for a table can be created automatically and eventually further edited with a built-in word processor, exported to an external one or to HTML. 

Most of the operations can be done just by mouse clicking and dragging. More advanced users can find useful to control programmatically all the operations described above, which makes Sfairadora a suitable tool for quick creation of simple applications. For this purpose, Sfairadora contains powerful instruments for designing custom dialog windows and tools, a language to create formatted text templates and a language to write simple programs. 

Normally, all these things are generated automatically for the user, so that, in standard circumstances, no sophisticated user intervention is needed, yet allowing advanced users to modify standard results to accommodate their specific needs.

Major Features: 

1. Key Features of Sfairadora
2. • Intuitive data model:
   • • Tables nested in a table.
     • rdered and filtered data – intuitive definition of filter conditions.  
     • Tables can be grouped and regrouped with ease. 
     • Transparent syntax of expressions for computed items (unlike in spreadsheets, you can simply write, for example, price * count instead of E10*F11).  
     • Straightforward copying and reorganization of data.  
     • Easy modification of data structure while preserving existing data.  
     • User-friendly saving data views which are then continuously updated.  
     • Current state   can be saved as a view with a single move of the mouse.  
     • Import and export of data possible both from/to relational databases, Excel and plain text files.
   • Interaction of data and text:
   • • Creation of text output from data by mouse drag and drop. 
     • Built-in text editor editing formatted text. 
     • Loading and saving texts in the RTF format.
     • Formatting text using styles.
   • Well-arranged presentation of data:
   • • Display adjusted to   contents so that you see all you need in a clear layout.
     • Transparent error diagnostics.
     • Automatically created presentations can be modified as required.  
     • Functions for the creation of pictures.  
   • The following features allow you to use Sfairadora for the quick development of simple applications:
   • R-D/C presentation model:
   • • Easy creation of presentations at any level of complexity.
     • Concept of a presentation as a program.
     • All properties can be specified by an expression and automatically updated.
   • Enki programming language:
   • • A single language for simple expressions as well as complex programs so that the sophistication of your solution can increase according to your needs.
     • Handling of errors using the concept of non-strict value.
     • Easy syntax of data search and aggregation.
     • Functions for the manipulation with pictures and formatted texts.
   • Enkidu language templates:
   • • Easy creation of formatted text outputs.
     • The initial version of the template can be created automatically according to the data structure.
   • All properties of a document (data type, presentation definition, etc) can be referenced by programs through the definition objects.  
   • You can create your own tools and file manipulators.
3. For Experts

Enhancements:

• Added provision for editing bullets and numbering to the pargraph format dialog.
• Fixed bug in accepting n-dash as a minus sign in a line-editor.
• Fixed bug in converting a number to roman notation.
• Added option to switch off paragraph numbering.
• Added option to number paragraphs with ordinal numbers.
• Fixed bug that could cause a crash during writes to a non-inline array.
• Fixed bug in program initialization in a network installation.