Although in the figure only one workbook is shown, ScienceSuit supports to work with many workbooks simultaneously. Each workbook can contain many worksheets and each worksheet can contain several ranges.
Except the deletion of a worksheet, the workbook supports undo/redo for all other operations.
The data in a workbook can be saved, as .sswb format, which is a collection of XML files bundled into a zip container, to be opened later on. When opening an .sswb file, there are two possible approaches:
As shown above, data in a worksheet can be formatted and the formatted data can be copied to MS Excel. The formatting panels are shown below:
Following are the possible formatting options:
The panel will automatically show the format of the active cell.
Once a valid data range is selected, the dimension of the selection and some essential measures of the data is immediately shown to the user at the status bar.
Depending on dimension of the selection selection (compare Fig A with B) clicking the right button of the mouse will show a menu to allow the user to create variables (such as Vector, Matrix, Array, Range) which can be manipulated by command-line. This feature brings a significant convenience when working with data sets (for more details).
Although, within a Worksheet, the selection can be moved/copied to another location using the mouse, the selected data set in the worksheet can also be carried to a different location or to a different worksheet using copy-cut/paste options. Regardless of the dimension of the data, if "Copy/Cut" is selected, 3 different formats are loaded to OS's clipboard (Free Clipboard Viewer is a useful tool to inspect the available formats of the data in the clipboard):
Besides the "regular" copy command, Workbook also supports copying a range as bitmap using "Copy As Image" as shown in the following figure:
Copying a range such as shown (Fig A) in the following figures will produce an image similar to Fig B. It is seen that the format and alignments are preserved.
Upon using the "copy" command, there are 3 paste options as seen in the following figure:
By default, a Worksheet contains 1000 rows and 100 columns. In order to insert or delete rows or columns, at least 1 row or 1 column must be selected. Right-clicking with the mouse will show the following menu:
For example, if n rows are selected, then n rows will be inserted or deleted. Similar rational holds for columns as well.