LibreOffice: Spreadsheets
Linux Format|December 2017

Whether you’re puzzling out pivot tables or building bar charts, Bobby Moss is determined to make you a cell-wrangling ninja.

Bobby Moss
LibreOffice: Spreadsheets

Whether you’re tracking your finances, your game collection or the progress of your favourite sports team, spreadsheets are a ridiculously useful tool to have in your computing arsenal. Since the invention of VisiCalc and the rise of Microsoft Excel, these powerful tools have matured to include a whole host of features, most recently those we’d typically see in word processing applications like automatic formatting wizards and tools to generate attractive-looking reports.

We last covered spreadsheets back in LXF140, which was long before LibreOffice forked from OpenOffice.org, its parent project. We opted for the former over the latter on the grounds that it’s now bundled by default with most mainstream Linux distros, and is arguably better-maintained.

In theory, you could use this tutorial for either package, but LibreOffice’s user interface has changed dramatically since version 5 and it now uses Extended ODF as its file format by default, so OpenOffice.org users may find their mileage varies.

Here we’ll cover the bare basics of how to use LibreOffice spreadsheets, then move through ways to automate data entry, generate pivot tables and create attractive-looking charts. It may not be as exciting as spinning up your own cloud storage service in AWS (that’s next month), but hopefully these tips will help you reclaim some leisure time.

Off the grid

The first thing you’ll see when you open up LibreOffice’s

Calc module is a giant grid with letters across the top and numbers down the side. Excel and Gnumeric users will feel perfectly at home: much like those packages. if you select a cell you should see the address for it highlighted towards the top-left of the screen.

Diese Geschichte stammt aus der December 2017-Ausgabe von Linux Format.

Starten Sie Ihre 7-tägige kostenlose Testversion von Magzter GOLD, um auf Tausende kuratierte Premium-Storys sowie über 8.000 Zeitschriften und Zeitungen zuzugreifen.

Diese Geschichte stammt aus der December 2017-Ausgabe von Linux Format.

Starten Sie Ihre 7-tägige kostenlose Testversion von Magzter GOLD, um auf Tausende kuratierte Premium-Storys sowie über 8.000 Zeitschriften und Zeitungen zuzugreifen.

WEITERE ARTIKEL AUS LINUX FORMATAlle anzeigen
Create your first WebSocket service
Linux Format

Create your first WebSocket service

Mihalis Tsoukalos explains how to use the Go programming language to work with the WebSocket protocol.

time-read
9 Minuten  |
April 2023
Fantastic Mr Firefox
Linux Format

Fantastic Mr Firefox

Nick Peers takes a trip down memory lane to reveal the story behind the rise - and slight fall - of Mozilla's popular web browser.

time-read
9 Minuten  |
April 2023
Set up your terminal and email like it's 1983
Linux Format

Set up your terminal and email like it's 1983

Jump in the hot terminal time machine with Mats Tage Axelsson who emails from the command line using the latest technology.

time-read
8 Minuten  |
April 2023
Universal layer text effects with GIMP
Linux Format

Universal layer text effects with GIMP

Posters use them, films and presentations are hard to imagine without them: text effects. Attract attention with Karsten Günther and GIMP.

time-read
8 Minuten  |
April 2023
Jump to a federated social network
Linux Format

Jump to a federated social network

Nick Peers reveals how you can get up and running with this free, decentralised and non-profit alternative to Twitter.

time-read
9 Minuten  |
April 2023
Free our SOFTWARE!
Linux Format

Free our SOFTWARE!

Taking anything for granted is dangerous, so Jonni Bidwell and Mike Saunders revisit how the free software movement got started to help free us from proprietary tyranny!

time-read
4 Minuten  |
April 2023
Master RPI.GPIO
Linux Format

Master RPI.GPIO

Les Pounder goes back to the early days of the Raspberry Pi - and his career with this classic library! -

time-read
5 Minuten  |
April 2023
Waveshare Zero to Pi3
Linux Format

Waveshare Zero to Pi3

Transform your Pi Zero into a Pi 3, they promised Les Pounder, but it's more like adding on go-faster stripes.

time-read
2 Minuten  |
April 2023
The Best OPEN SOURCE Software Ever!
Linux Format

The Best OPEN SOURCE Software Ever!

In an attempt to trigger controversy, Michael Reed and Neil Mohr unequivocally state these are the greatest free software apps ever. Probably. We’re just trying to be helpful.

time-read
10+ Minuten  |
April 2023
Linux-Mandrake 7
Linux Format

Linux-Mandrake 7

Simplicity and a wide range of applications make this a great distribution for all Linux users.

time-read
2 Minuten  |
April 2023