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,670 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.

  • OpenOffice.org 3.0 review

    OpenOffice.org 3.0

    Whether OpenOffice 3.0 is right for you comes down to this decision: can you live without the latest features in Microsoft Office 2007?

IDG UK Sites

Best camera phone of 2015: iPhone 6 Plus vs LG G4 vs Galaxy S6 vs One M9 vs Nexus 6

IDG UK Sites

In defence of BlackBerrys

IDG UK Sites

Why we should reserve judgement on Apple ditching Helvetica in OS X/iOS for the Apple Watch's San...

IDG UK Sites

Retina 3.3GHz iMac 27in preview: Apple cuts £400 of price of Retina iMac with new model