Ubuntu - Spreadsheets

Ubuntu - Spreadsheets with LibreOffice Calc

Ubuntu includes LibreOffice, a powerful and free office suite. The spreadsheet application in this suite is called LibreOffice Calc, which is a capable alternative to Microsoft Excel.

To launch Calc, click the ‘Show Applications’ icon, search for ‘Calc’ or ‘LibreOffice Calc’, and click its icon. It’s often found in the dock by default as part of the LibreOffice suite launcher.

Once launched, LibreOffice Calc presents a familiar spreadsheet interface with cells, rows, columns, and a toolbar for various functions.

Basic Operations

You can enter text, numbers, and dates into cells just like in other spreadsheet programs. Navigate between cells using arrow keys or the mouse.

Adding Formulas

LibreOffice Calc supports a wide range of formulas and functions, similar to those in Microsoft Excel.

To enter a formula, select a cell and type = followed by your calculation. For example, to sum cells A1 and B1, you would type =A1+B1 in cell C1.

Consider a simple example: Column A has ‘Item’, Column B has ‘Units’, Column C has ‘Unit Price’, and you want Column D to show ‘Total Price’ (Units * Unit Price).

In cell D2, you would enter the formula =B2*C2. You can then drag the fill handle (the small square at the bottom-right of the selected cell) down to apply this formula to subsequent rows, automatically adjusting cell references (e.g., B3C3, B4C4).

Saving a Sheet

To save your work:

Step 1: Go to ‘File’ > ‘Save As…’ or ‘File’ > ‘Save’.

Step 2: Choose a location, enter a filename, and select the file format. The default format is OpenDocument Spreadsheet (.ods), but you can also save in Microsoft Excel formats (.xlsx, .xls) for compatibility.

Step 3: Click ‘Save’.

Formatting Options

LibreOffice Calc provides extensive formatting options available through the toolbar or the ‘Format’ menu. You can change font styles, colors, cell borders, number formats (currency, percentage, date), alignment, and more.

Inserting Charts

Visualizing data with charts is straightforward.

Step 1: Select the data range you want to include in the chart.

Step 2: Go to ‘Insert’ > ‘Chart…’ or click the chart icon on the toolbar.

Step 3: The Chart Wizard will appear. Choose the chart type (e.g., bar, line, pie), set data ranges (usually pre-filled from your selection), customize chart elements (titles, legend, axes), and click ‘Finish’.

The chart will be embedded in your spreadsheet and can be moved and resized. It will also update automatically if the source data changes.

LibreOffice Calc is a feature-rich application suitable for both simple and complex spreadsheet tasks, offering excellent compatibility with other office suites.