LibreOffice 3.5 review

The 'alternative' alternative open source office suite gets its second update in 16 months, but are the bug fixes and new features enough to tempt users away from OpenOffice.org? Julian Prokaza downloads and installs to find out.

What's new in Calc?

The Calc spreadsheet has always been a more rounded replacement for Excel than Writer has been for Word, and most of the changes introduced with v3.3 simply expand its usefulness rather than address shortcomings.

The most immediately obvious of these are the button next to the input bar that expands it from one line to six, giving much more room to edit complex formulas that won't otherwise fit neatly into a cell.

LibreOffice 3.5.0

Calc's optional six-line input bar makes it much easier to work with cells containing lots of text or long formulas.

Filter handling has also been streamlined and it's now possible to select multiple values when filtering data in a sheet, rather than just one.

LibreOffice 3.5.0

Filter handling is much improved in calc and data can now be filtered by two or more values.

Excel document compatibility has never been a serious issue, but Calc does handle some things in a slightly different way and these may throw confirmed Excel users for a six initially.

For example, whole row or column references in a Formula, such as SUM(E:E), are not recognised in Calc and will generate an error if used. Any instances in imported Excel documents are appropriately converted though, and instead take the form SUM(E1:E1048576).

Featured Resources

2021 Thales access management index: Global edition

The challenges of trusted access in a cloud-first world

Free download

Transforming higher education for the digital era

The future is yours

Free download

Building a cloud-native, hybrid-multi cloud infrastructure

Get ready for hybrid-multi cloud databases, AI, and machine learning workloads

Free download

The next biggest shopping destination is the cloud

Know why retail businesses must move to the cloud

Free Download

Most Popular

Best Linux distros 2021
operating systems

Best Linux distros 2021

11 Oct 2021
Veritas Backup Exec 21.3 review: Covers every angle
backup software

Veritas Backup Exec 21.3 review: Covers every angle

14 Oct 2021
HPE wins networking contract with Birmingham 2022 Commonwealth Games
Network & Internet

HPE wins networking contract with Birmingham 2022 Commonwealth Games

15 Oct 2021