in

Free/Open-source Spreadsheet Programs

- - 2 comments
A computer application that replaced paper worksheets is called a spreadsheet. It shows multiple cells that together make up a grid consisting of rows and columns, each cell containing either alphanumeric text or numeric values. A spreadsheet cell may otherwise hold a formula that classifies how the contents of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated. Spreadsheets are often used for financial information because of their capacity to re-calculate the entire sheet automatically after an alteration to a single cell.

If you think that the proprietary and expensive Microsoft Excel is the only available and capable spreadsheet software, then think again because you are wrong. There are quite a number of free/open-source spreadsheet programs that are almost as good or even at par with Excel.

Here are some of the most known free/open-source software spreadsheet applications:

Gnumeric
Gnumeric is part of the GNOME desktop and has Windows installers available. It is intended to be a free replacement for proprietary spreadsheet programs such as Microsoft Excel, which it broadly and openly emulates.

Gnumeric has the ability to import and export data in several file formats, including CSV, Microsoft Excel, HTML, LaTeX, Lotus 1-2-3, OpenDocument and Quattro Pro; its native format is the Gnumeric file format (.gnm or .gnumeric), an XML file compressed with gzip. It includes all of the spreadsheet functions of the North American edition of Microsoft Excel and many functions unique to Gnumeric. Pivot tables and conditional formatting are not yet supported but are planned for future versions.

Gnumeric's accuracy has helped it to establish a niche among people using it for statistical analysis and other scientific tasks. For improving the accuracy of Gnumeric, the developers are cooperating with the R Project.


GNU Oleo
GNU Oleo is a lightweight free software spreadsheet software package. Oleo was originally designed as a text-based spreadsheet (using the curses library).

Oleo is much older than the GNU Gnumeric spreadsheet (a part of the GNOME desktop system) and has fewer capabilities. It is also not as active as a project, not having had a release since 2001.


KSpread
KSpread is part of KOffice, an integrated office suite for the KDE Desktop Environment.

Among KSpread features are multiple sheets per document, assorted formatting possibilities, support for more than 100 built-in functions, templates, chart, spell-check, hyperlinks, data sorting and scripting with Python, Ruby and Javascript.

KSpread native format is XML, compressed with ZIP. However, KSpread has the ability to import in several spreadsheet formats, including Microsoft Excel, Applix Spreadsheet, Quattro Pro, CSV and OpenOffice.org Calc.


OpenOffice.org Calc
OpenOffice.org Calc is a component of the OpenOffice.org software package.

Calc is similar to Microsoft Excel, with a roughly equivalent range of features. Calc is capable of opening and saving spreadsheets in Microsoft Excel file format. It provides a number of features not present in Excel, including a system which automatically defines series for graphing based on the layout of the user's data. Calc is also capable of writing spreadsheets directly as PDF files.

The default file format for OpenOffice.org 2.0 Calc can be set to either Microsoft Excel or the OASIS Open Document Format (ODF). Calc also supports a wide range of other file formats, for both opening and saving files.

As with the entire OpenOffice.org suite, Calc can be used across a variety of platforms, including Mac OS X, Microsoft Windows, Linux, FreeBSD and Solaris. Available under the GNU Lesser General Public License, Calc is free software.


SIAG
SIAG (Scheme in a grid) is a spreadsheet using a SIOD engine or base. The grid, siag is fast and very configurable. Suitable for small unix distributions, it was selected by DSL to provide a spreadsheet inside their fifty megabyte system footprint. Consequently, siag can be used on older PCs with their limited memory and disk space.

Language modules for C, SIOD, Guile, Python, Ruby, Tcl, etc. permit extensive control over input and output data. Any unix shell can further script siag grids to display cells in algorithmic form.


Simple Spreadsheet
Simple Spreadsheet is a web-based spreadsheet program written in JavaScript, HTML, CSS and PHP. It features formulas, charts, formats, cell/row merging, cell locking, keyboard navigation, etc. Simple Spreadsheet is released under the GNU General Public License, and is thus free software.

Custom macros can be written in Javascript. Javascript is also used as the default (human-readable) data format. Future versions will contain collaborative features to allow many people working simultaneously together on one sheet. The charts are generated on the server-side using a PHP library called JpGraph. On the client side they are referenced with a function inside a formula.

Simple Spreadsheet can be used with all common browsers like Firefox, Opera, Konqueror, and Internet Explorer. Safari may be used, but was not yet tested.


wikiCalc
wikiCalc is a web application, created by Dan Bricklin, that allows for the creation and editing of spreadsheets through a wiki-style user-editable interface. It is currently released as version 1.0 for use on Windows, Mac, Linux/Unix, and other platforms that can run the Perl language.

The product was envisioned in 2005 by Bricklin, who 27 years earlier created VisiCalc, the first commercial spreadsheet program for the personal computer. Version Alpha 0.1 was released for alpha testing in November 2005. Version 1.0 was released on January 25, 2007. wikiCalc is written in the Perl programming language.


2 comments

  1. One more for your list - Resolver One is free for personal use, or if you're willing to make your own spreadsheets open-source. (It costs money if you want to use if for commercial purposes.)


    Cheers,

    Giles

    ReplyDelete
  2. Thanks Giles for the comment. I will be checking out Resolver One soon. Thanks.

    ReplyDelete