Ubuntu - Spreadsheets



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

Calc

Once we click on the icon, the spreadsheet application will launch.

Launch Spreadsheet Application

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

Edit Cells

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 3rd column is the multiplication of the Units and Unit price column.

Formulas Added

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

Columns Dragged

Saving a Sheet

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

Save As Option

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

Click Save Button

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

Formatting Options

Inserting Charts

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

Insert Chart

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

Click Chart Option

Now, we can see the Chart in the spreadsheet.

See Chart
Advertisements