Head to Head: Microsoft Office 2010 vs Open Office 3.3

For many an office suite is just as essential as the computer it runs on. But should you continue investing in Microsoft Office or choose the free OpenOffice instead? Karl Wright gets down to business and finds out in our review.

The chart features in OpenOffice Calc allow you to create fairly sophisticated charts easily and quickly. The range of charts

The chart features in OpenOffice Calc allow you to create fairly sophisticated charts easily and quickly. The range of charts available isn't as comprehensive as that in Microsoft Office though.

Minor changes include the ability to shade the tabs of your worksheets different colours, to aide navigation and an increase in the number of decimal places the "general number" format can display. As before, these are all useful changes, but they hardly make a huge difference to the user experience for most people.

Advertisement - Article continues below

The most obvious difference between Calc and Excel is Excel's Ribbon interface. As with the word processors, we prefer the Ribbon to lots of menus. It makes it easier and quicker for users to interact with and manipulate data and that's something of a theme when comparing Excel to Calc. Often, things which are complex, multi-stage tasks in Calc, can be achieved with a single click in Excel 2010.

For instance, with Excel's Format as Table function, you can instantly add filters to data columns and apply alternating colours to each data row. Calc makes you perform both operations separately and many filters don't have the same range of options as those in Excel.

Excel's also better at error checking, displaying a warning symbol in the corner of a cell when it thinks a formula has been incorrectly entered or a data range poorly defined. Excel 2010, like Excel 2007, also allows you to have more than three conditional formats in a range of cells, whereas Calc 3.3 is still stuck on just three. Anyone who uses conditional formats knows how infuriating this limitation is.

Advertisement
Advertisement - Article continues below
Advertisement - Article continues below

Microsoft Excel is generally easier to use, gets the job done quicker and is much more flexible when working with data. That doesn't mean that Calc's a bad product it definitely isn't; for most users it will do everything they need of it. But for more demanding users, Excel just has the edge.

Winner: Microsoft Excel Calc is good enough for most users but Excel delivers a better user experience, making it easier to quickly format and work with large amounts of data.

Featured Resources

Staying ahead of the game in the world of data

Create successful marketing campaigns by understanding your customers better

Download now

Remote working 2020: Advantages and challenges

Discover how to overcome remote working challenges

Download now

Keep your data available with snapshot technology

Synology’s solution to your data protection problem

Download now

After the lockdown - reinventing the way your business works

Your guide to ensuring business continuity, no matter the crisis

Download now

Most Popular

How to find RAM speed, size and type
Laptops

How to find RAM speed, size and type

3 Aug 2020
How to use Chromecast without Wi-Fi
Mobile

How to use Chromecast without Wi-Fi

4 Aug 2020
How to move Windows 10 from your old hard drive to SSD
operating systems

How to move Windows 10 from your old hard drive to SSD

3 Aug 2020