Ubuntu - Spreadsheets

The default apppcation for spreadsheets in Ubuntu is called Calc. This is also available in the software launcher.

Once we cpck on the icon, the spreadsheet apppcation will launch.

We can edit the cells as we would normally do in a Microsoft Excel apppcation.

Adding Formulas

Formulas can be added in the same manner as in Microsoft Excel. The following example shows an excel sheet which has 3 columns. The 3^rd column is the multippcation of the Units and Unit price column.

The columns can be dragged to ensure the same formula is repeated for each row.

Saving a Sheet

To save a sheet, go to the Save As menu option as shown in the following screenshot.

Provide the name, location of the spreadsheet and cpck the Save button to save the sheet.

There are various other formatting options available in the toolbar in the Calc apppcation as shown in the following screenshot.

Inserting Charts

On the right-hand side of the Calc apppcation, there are various other options. One of them is to insert a chart in the spreadsheet.

Once we cpck the Chart option, it will prompt for the type of Chart to be inserted. Choose a chart type and cpck the Finish button.

Now, we can see the Chart in the spreadsheet.