IT Pro is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission. Learn more

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

Big data for finance

How to leverage big data analytics and AI in the finance sector

Free Download

Ten critical factors for cloud analytics success

Cloud-native, intelligent, and automated data management strategies to accelerate time to value and ROI

Free Download

Remove barriers and reconnect with your customers

The $260 billion dollar friction problem businesses don't know they have

Free Download

The future of work is already here. Now’s the time to secure it.

Robust security to protect and enable your business

Free Download

Recommended

Organisations are scaling back their open source software due to security fears – Anaconda
open source

Organisations are scaling back their open source software due to security fears – Anaconda

15 Sep 2022

Most Popular

How to secure your hybrid workforce
Advertisement Feature

How to secure your hybrid workforce

23 Sep 2022
Why collaboration is key to digital transformation
Sponsored

Why collaboration is key to digital transformation

13 Sep 2022
What your hybrid workforce needs from their laptops
Advertisement Feature

What your hybrid workforce needs from their laptops

21 Sep 2022