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

15,670 Reviews

# GS-Calc 10 review

\$20 (around £13)

Our Rating:

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:

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.

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

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

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.

• #### Apple Numbers '08 spreadsheet software

Slowly, but surely, Apple's iWork is turning into a full-fledged office suite, as iWork '08 gains Numbers '08, Apple's latest foray into the world of spreadsheet programs.

Best Christmas 2014 UK tech deals, Boxing Day 2014 UK tech deals & January sales 2015 UK tech...

LED vs Halogen: Why now could be the right time to invest in LED bulbs

Christmas' best ads: See great festive spots studios have created to promote themselves and clients

Why Apple shouldn't be blamed for exploitation in China and Indonesia