Cellarium

Cellarium is a Spreadsheet created by Alessandro Gobbetti and Laurenz Ebi in the frame of the Programming Fundamentals 2 class of 2021, at USI.

Content

1. Informations
   1. Supported formats
   2. Supported operations
2. Cellarium TUI
   1. How to run
   2. Controll the TUI
3. Cellarium GUI
   1. How to run
   2. Controll the GUI
4. Status of the repo

Informations

Cellarium was build during the second semester of the bachelor of inforamtics at USI.

We build our spreadsheet such that we have a TUI (text user interface) as well as a GUI (graphical user interface).

Supported formats

Its IMPORTANT to point out that we have a own representation to back up our Cellarium spreadsheet. We created an optimized formatting named .cellarium where you can store your build spreadsheet in. It only stores the Cells who have a content and are essential for the calculations, thus we avoid storing unnecessary Cells and we save save memory.

Nevertheless it is also possible to import and export CSV files.

Supported Operations

Here we listed the operations you can compute with our spreadsheet.

Unary

Operation	Example
SQUARE ROOT	SQRT(9)
SINE	SIN(9)
COSINE	COS(9)
TANGENT	TAN(9)
LOGARITHM	LOG(9)
NEGATION	-A1

Binary

Operation	Example
ADDITION	A1 + A2
SUBTRACTION	A1 - A2
MULTIPLICATION	A1 * A2
DIVISION	A1 / A2

Ranges

Operation	Example
SUM	SUM(A1:C10)
AVERAGE	AVERAGE(A1:C10)
MAXIMUM	MAX(A1:C10)
MINIMUM	MIN(A1:C10)
COUNT	COUNT(A1:C10)

 

Cellarium TUI (Text User Interface)

How to Run

To run the programm you have to open your terminal, go in the project-cellarium directory and type:

java tui/Main

Controll the TUI

No matter capitalization.

Command	Description
PRINT	Prints the enire spreadsheet
PRINT NAMEOFTHECELL	Prints one single cell
SET NAMEOFTHECELL VALUE	To set or change a cell
CLEAR NAMEOFTHECELL	To clear a certain cell
CLEAR	To clear the spreadsheet
UNDO	Undos the last command
REDO	Redos the last undone command
SAVE NameOfTheFile	Saves the spreadsheet in the given directory with the given name, as a .cellarium file
OPEN path	Imports a given .cellarium file in Cellarium
EXPORT NameOfTheFile	Saves the spreadsheet in the given directory with the given name, as a .csv file
IMPORT path	Imports a given .csv file in Cellarium
EXIT	Closes the programm
HELP	To open Help terminal with the commands

Examples

To change a Cell:

SET C2 7

or

SET A1 = C2 + G7

To cancel one cell:

CLEAR C2

 

Cellarium GUI (Graphical User Interface)

How to Run

To run the programm you have to open your terminal, go in the project-cellarium directory and type:

java gui/Main

if the size of the window and the font is to small you can handle it by adding the following command:

GDK_SCALE=2 java gui/Main

you can change the scale as you prefer.

Controll the GUI

Select a cell and edit it.

You can edit a cell by selecting the cell with the mouse and writing the formula directly in it.

Another way is to control the spreadsheet directly from the expression bar. Here you can also run the commands similar to the ones of the TUI.

Use scrollbars to move the Spreadsheet.

Use the menu bar to use some additional features.

 

Features	Hotkey	Description
CLEAR ALL	ALT + X	To clear the entire spreadsheet
UNDO	CTRL + Z	Undos the last command
REDO	CTRL + Y	Redos the last undone command
SAVE	CTRL + S	Saves the spreadsheet in the given directory with the given name, as a .cellarium file
OPEN	CTRL + O	Imports a given .cellarium file in Cellarium
EXPORT	CTRL + E	Saves the spreadsheet in the given directory with the given name, as a .csv file
IMPORT	CTRL + I	Imports a given .csv file in Cellarium
QUIT	CTRL + Q	Closes the programm
ABOUT	CTRL + H	Shows iformation about Cellarium

 

Status of the repo

Cellarium is finished and ready to use.

Have fun!