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,103 Reviews

GS-Calc 10 review

$20 (around £13)

Manufacturer: Citadel5

Our Rating: We rate this 4 out of 5

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

The GS-Calc 10 also has some imperfections that are at least partially mitigated by the low price. Developer Citadel5 packs GS-Calc full of interesting features, including a large work area (4094 columns by 12 million rows),  pivot tables, robust charting, and a nice interface for dealing with multiple worksheets in a single project. GS-Calc has an unusual, and welcome, take on multi-page spreadsheets. See all: PC Advisor software downloads.

Rather than a row of tabs along the bottom to handle multiple sheets, which becomes problematic when a workbook grows beyond four or five pages, GS-Calc offers a hierarchical, folder-based view supporting multiple levels of folders. This makes it  easier to create a workbook consisting of many smaller, more-focused sheets, a boon to navigation and debugging.

GS-Calc also offers an interesting method of generating multiple values.

A single formula can fill several cells with calculated values. These "array formulas" work with most of GS-Calc's functions. For example, entering "=SQRT(4)+{1;2;3;4;5}" will produce the numbers 3 through 7, in five cells, beginning with the one in which the formula was entered. If the data in one of the "generated" cells is overwritten or changed, it is refreshed as soon as the worksheet recalculates itself.

By using references to worksheet ranges as part of the array, an array formula in a single cell can fill many cells with data. It's much easier to correct errors in that single formula than to do so in many cells, even with features like Excel's auto-copy to make the job easier.

GS-Calc is loaded with functionality, but hides the full list and all descriptions in the dialog box you can use to enter a function. The description and examples contained for each function in this dialog is thorough, but this is the kind of information that should be in the Help file. Having it in the dialog is a very helpful addition to having it in the Help, but it isn't a replacement for it.

Version 10 of GS-Calc corrects one of the flaws of Version 9: The screen redraw and interface responsiveness is much better, without the flicker effect sometimes seen before. It still retains some of the interface oddities, such as numerical overflow going to the left by default, rather than the right, or the workable, though non-standard, use of the Ctrl key to select cell addresses while entering a formula.

Other improvements to GS-Calc 10 include a compressed, proprietary save format, in addition to the ODF (Open Document) format, and the ability to add a note file to each document, which can be displayed in the bottom or left panes. The notes are linked to the entire document, not to any individual sheet or cell. Cell deletion has been made more flexible, as well. These are "quality of life" improvements, small changes that enhance the application without massively changing the user experience or basic functionality.

GS-Calc also features support for pivot tables, allowing for the easy creation of summary reports and breaking down data into various categories. Charting, both 2-D and 3-D, is also supported. While it doesn't contain any revolutionary breakthroughs, the charting function has options for user control and styling of the information presented, and the interface is generally clear despite there being many possible values to adjust.

GS-Calc offers a great deal of functionality for a very low price, and version 10 is an incremental upgrade. Nothing in version 10 makes GS-Calc radically different from version 9, but it shows a commitment to frequent improvements and fixes.

GS-Calc 10 Expert Verdict »
XP/Vista/7/8
  • Overall: We give this item 8 of 10 overall

GS-Calc is especially useful for working with data best broken into multiple pieces, but it does have the capacity to handle large quantities of information as well, making it a good tool to grow with. The 30-day trial should be sufficient to evaluate its performance on whatever tasks you might need it for.

There are currently no price comparisons for this product.
  • OpenOffice Calc

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

  • ThinkFree Office Online productivity suite

    ThinkFree Office Online productivity suite

    ThinkFree has three main components - Write (a word processor), Calc (a spreadsheet), and Show (presentation software) - all of which are listed on the site's My Office page, along with your most recently edited files.

  • OpalCalc review

    OpalCalc

    OpalCalc is a unique and free software calculator that lets you use natural language for day-to-day calculations.

  • Google Spreadsheets free online spreadsheet application

    Google Spreadsheets free online spreadsheet application

    If you carry around a laptop so you can show clients your latest marketing forecasts, you can save yourself the bother by using Google Spreadsheets.

  • 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.


IDG UK Sites

LG G Watch release date, price and specs: Hands-on and pictures

IDG UK Sites

Apple financial results: iPhones, iPads & Macs sales for Apple's Q2 2014, plus shares to split

IDG UK Sites

Twitter - not news

IDG UK Sites

See Moo Studios' new animated advert for Blue Moon beer