We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Office software Reviews
15,669 Reviews

OpenOffice Calc


Manufacturer: OpenOffice.org

Our Rating: We rate this 3.5 out of 5

Calc is OpenOffice's spreadsheet application and, as with Writer, compares very well to its Microsoft Office equivalent.

Calc is OpenOffice's spreadsheet application and, as with Writer, compares very well to its Microsoft Office equivalent. Treated as a standalone product, Calc is efficient and comprehensive in terms of its features.

Click here to read our analysis of the free alternatives to Office 2007.

Anyone who has used Excel will be familiar with the Calc interface: although it isn't as slick as the latest Office release, it's certainly as usable as previous versions. Calc is reported to struggle with particularly complex Excel files and formulae, although we encountered no problems - and it does support a wide range of file formats.

Calculated success

Calc uses a range of functions to create formulae for data calculations. The Function Wizard simplifies this task, but you need a good mathematical understanding. While documentation is extensive, it can be quite technical and difficult to navigate.

As in Excel, spreadsheets can have multiple worksheets for building up complex arrays of data, what-if calculations and creating dynamic charts. And most of Excel's advanced features, such as Pivot Tables - DataPilot in Calc; used to analyse large amounts of data - or the ability to link to an external HTML data source, are available.

There are a few areas where Calc is outdone by Excel. If you appreciate Excel's charting options for creating all kinds of scatter diagrams, pie charts and bar graphs, you could be disappointed with Calc's slightly curtailed range of options. However, the vast majority of Excel users are simply confused by its excess and can afford to stick to the more limited, albeit logical, selection in Calc.

OpenOffice additions

Writer and Calc are the most important components of the OpenOffice suite, but we should mention how the other applications compare to their Microsoft equivalents. Impress is far inferior to PowerPoint in terms of templates and guidance, but is much improved in version 2.0. Base is a complex but sophisticated relational database.

The other two applications, Draw and Math, do not have an exactly matched equivalent in standard versions of Microsoft Office. Despite its name, Draw is better thought of as a charting tool equivalent to Visio than as a competitor to CorelDraw or Illustrator. Math enables users to create complex equations, which is traditionally very difficult using word processors, but Microsoft does provide an add-on for Word.

For a free application, Calc comes highly recommended. OpenOffice 2.1 is incredibly useful and feature-rich, especially when you consider that it requires no financial outlay. Compatibility with Microsoft applications is good and performance has been greatly improved. However, it's not as feature-rich as Microsoft's Office suite, particularly if you require collaborative tools.

OpenOffice Calc Expert Verdict »

Web connection
  • Ease of Use: We give this item 6 of 10 for ease of use
  • Features: We give this item 8 of 10 for features
  • Value for Money: We give this item 7 of 10 for value for money
  • Overall: We give this item 7 of 10 overall

Calc is not quite as effective as Writer and experienced users will probably prefer to stick with Excel, but it remains the best free spreadsheet around.

  • OpenOffice 2.2

    OpenOffice 2.2

    OpenOffice 2.2 is the latest update of the open-source rival to Microsoft Office 2007. Our OpenOffice 2.2 review shows that there is plenty to recommend the free alternative.

  • Star Office 8.0

    Star Office 8.0

    In recent years, thousands of corporate desktops have begun to adopt either StarOffice or OpenOffice. Our review of Star Office 8.0, the latest version of Sun's low-cost Microsoft Office-killer, shows why.

  • Google Docs & Spreadsheets

    For those seeking an alternative to Office, OpenOffice is comprehensive. But Google offers a very different approach.

  • OpenOffice 3.0 beta review

    OpenOffice 3.0 beta

    OpenOffice 3.0 shows that you don't have to pay a bundle for a great office suite - in fact, you don't even have to pay a penny.

  • GS-Calc 10 review

    GS-Calc 10

    GS-Calc 10 is an inexpensive spreadsheet program that isn't an Excel clone. Here's our GS-Calc 10 review.

IDG UK Sites

Sony Xperia Z3+ release date, price and specs: The Xperia Z4 for the UK

IDG UK Sites

Why Intel’s vision of the future is a future I want to live in

IDG UK Sites

10 amazing, creative uses of tech – and the brands behind them

IDG UK Sites

Jony Ive 'semi-retired' into new role: kicked upstairs as Chief Design Officer