Quattro Pro X4 vs. Excel 2007: How Close is the Competition?

Written by:  • Edited by: Tricia Goss
Updated Dec 8, 2009
• Related Guides: Microsoft | Excel
4

More than just an Excel alternative, Quattro Pro is a spreadsheet application that deserves some recognition for its own unique features and functionality. In this review, we’ll take a look at just how well this program measures up.

Quattro Pro Overview

Quattro Pro X4 is the spreadsheet application that comes bundled with Corel’s WordPerfect Office X4 suite. Just like its sister product, WordPerfect, its biggest competition on the market today comes from Microsoft. How does it compare in terms of functionality and ease of use? And, how compatible is Quattro Pro with other applications of its type?

Ease of Use
Rating Excellent

Just as with other products in the WordPerfect Office X4 suite, Quattro Pro allows you several choices for the workspace look and feel. This is a big bonus to new users of the software who are defecting from other spreadsheet applications. In particular, you can make the choice of working in standard Quattro Pro Mode, Microsoft Excel Mode (based on Excel 2003 and earlier), or Lotus 1-2-3 Mode.

Customize the Quattro Pro Workspace
click to enlarge

If you have any familiarity with spreadsheet applications at all, you should find Quattro Pro’s user interface and on board help system easy to navigate. To benefit the true spreadsheet novice, an instructional CD containing an excellent collection of video tutorials comes free with the purchase of the WordPerfect Office X4 suite.

Features
Rating Excellent

While I am a fan of templates in other types of office applications, I rarely use them in spreadsheet programs. In most cases, I generally find it quicker to create my own layout than spend hours browsing through predesigned documents that don’t look anything like what I had in mind. With that being said, I found the project templates included with Quattro Pro, ones that might actually be of use, especially to those looking for items to help analyze their personal finances.

Quattro Pro Template Example
click to enlarge

One thing that particularly caught my attention in Quattro Pro was the large number of chart options available, many of which are not found in Excel. Although it is possible to create items like histograms and Gantt charts in Excel, it can’t be done with the click of a button or easy use of a chart picker, as it can in Quattro Pro. (See Creating Quattro Pro Gantt Charts for more details.)

Another nice feature in Quattro Pro’s Chart Expert is the Advisor’s Choice button. If you don’t know what type of chart would best represent your data, you can click this button and Quattro Pro will make a recommendation for which type of chart to use.

Quattro Pro Chart Expert
click to enlarge

In general, the fundamental capabilities of Quattro Pro are very much in line with other major spreadsheet programs today. As in Excel, there are a multitude of pre-defined functions with sometimes less than obvious names, but the Functions dialog box makes it easy to find and pick the one you want.

Quattro Pro Function List
click to enlarge

Continue on to the next page, where we look at the compatibility and overall rating of Quattro Pro X4.

Showing page 1 of 2

Comments

Showing all 7 comments
 
William J. Woods Jun 26, 2010 7:09 PM
saving cell colors
I thank all of the writers who attempted to help me in my Quattro Pro 4x problems. When I downloaded QP4x, it over ride all my Quattro Pro speadsheets I devolped and all the cells that were color coded also went down the drain, maybe its time the writer of this program should be aware and correct it.
Hey,,,Michele McDonough,,, please bring up a speadsheet and put a color in the 1 or 2 cell and close and open your PC, did the color in cell show up? If it did.. please let me know thanks
Michele McDonough Jun 26, 2010 6:19 PM
Running in Vista
Hi Gene - Yes, I had no problems running Quattro Pro in Vista.
Gene Shiber Jun 26, 2010 2:00 PM
Quattro Pro X4
Can Quattro Pro X4 be run in Windows Vista?
Michele McDonough Jan 13, 2010 11:11 PM
Re: CAN NOT CHANGE CELL COLORS
Hi William -

Ugh, that sounds extremely frustrating. I wish I had some advice, but I haven't encountered that before - hopefully one of our other readers will have some insight.

Michele
William j Woods Jan 13, 2010 6:58 PM
CAN NOT CHANGE CELL COLORS
I have tried everything possible to change my cells in different colors. i went to format>selection properties and followed all instructions. it shows the differnt colors and i would save it. now is the problem.
when I open the spreadsheet all my colors in the cells have disappeared and none of colored cells have color, they are all blank or white. i am refering to single cell color change, thanks for all help going crazy with QP-x4
Michele McDonough Sep 26, 2009 8:18 PM
Re: Quattro Pro X4
John,

Do you know the directory the files are located in and just are not seeing them when you try to open them in Quattro Pro or can you not find them at all?
John M Mulligan Sep 26, 2009 7:46 PM
Quattro Pro X4
I am puzzled, I have used Quattro since 1995
and I now need to re-visit one or two of my files
created in 1995 and 1998.
How do I access them? I cannot find any archives
or files containing them which I know were created
in the past.
Thank you for any help you can give me.
 
blog comments powered by Disqus
Email to a friend