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.
TDF’s rapid pace of development over the last year or so has swept away any concerns about the future of this forked OpenOffice.org project and while it still isn’t in the same league as Microsoft Office, it is still a very solid open source alternative for most users — or at least will be once v3.5 reaches a stable state.
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.
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.
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).
Get the ITPro daily newsletter
Sign up today and you will receive a free copy of our Future Focus 2025 report - the leading guidance on AI, cybersecurity and other IT challenges as per 700+ senior executives
-
Kaseya targets IT efficiency with new AI-powered tools
The cyber security firm unveiled its new Kaseya 365 Ops and Kaseya SIEM offerings at its Connect 2025 event in Las Vegas
By Daniel Todd Published
-
AWS to give AI skills to 100,000 people in the UK by 2030
Cloud giant wants to inspire the next Charles Babbage and Ada Lovelace with an AI-training initiative that pulls government, business, and education together
By Bobby Hellard Published
-
Cyber defenders need to remember their adversaries are human, says Trellix research head
There's a growing overlap between nation-state actors and cybercriminals, but these attackers are real people who make mistakes
By Rene Millman Published