Workbook

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.

 

Saving / Opening:

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:

  1. Running ScienceSuit first and then opening the file via Open button located at Workbook ribbon page.
  2. Using the file manager provided by OS. For this, the IPCPORTNUMBER must be set to a valid number.

 

 

Formatting Cells

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:

  1. Font: Family, size, color, style (italic), decoration (underline) and weight (bold).
  2. Color: Background color
  3. Alignment: Vertical (bottom, center, top) and horizontal (left, center, right)

The panel will automatically show the format of the active cell.

 

 

Selection of Cells

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).

 

 

Copy/Paste

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):

  1. HTML Code: Which provides convenience to embed in an HTML page.
  2. XML Code: When the data is pasted ScienceSuit parses the XML code and formats the data accordingly.
  3. Text Code: Tab separated format.

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.

Fig A

Fig B

 

Upon using the "copy" command, there are 3 paste options as seen in the following figure:

  1. Directly clicking the Paste button will paste values and format
  2. Selecting "Paste Values" will only paste the values.
  3. Selecting "Paste Format" will only paste the format. Therefore, any value entered in the pasted region's cell will have the similar format from where it was copied.

 

 

Inserting/Deleting Rows and Columns

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.