Free spreadsheet software for linux

Simple Spreadsheet is a webbased spreadsheet program written in Javascript, HTML, CSS and PHP.

Simple Spreadsheet features formulas, charts, numeric formats, keyboard navigation, etc. Javascript is used for the default data format and for the macros and formulas.

Spreadsheet::Perl is a pure Perl implementation of a spreadsheet engine.
SYNOPSIS
use Spreadsheet::Perl;
use Spreadsheet::Perl::Arithmetic ;
my $ss = tie my %ss, "Spreadsheet::Perl"
$ss->SetNames("TEST_RANGE" => A5:B8) ;
$ss{TEST_RANGE} = 7 ;
DefineSpreadsheetFunction(AddOne, &AddOne) ;
$ss{A3} = PerlFormula($ss->AddOne("A5") + $ss{A5}) ;
print "A3 formula => " . $ss->GetFormulaText(A3) . "n" ;
print "A3 = $ss{A3}n" ;
$ss{ABC1:ABD5} = 10 ;
$ss{A4} = PerlFormula($ss->Sum("A5:B8", "ABC1:ABD5")) ;
print "A4 = $ss{A4}n" ;
...
Main features:
- set and get values from cells or ranges
- handle cell private data
- has fetch/store callback
- has cell attributes access
- has cell/range fillers (auto-fill functionality)
- set formulas (pure perl and common format)
- compute the dependencies between cells
- formulas can fetch data from multiple spreadsheets and the dependencies still work
- checks for circular dependencies
- debugging triggers
- has a simple architecture for expansion
- has a simple architecture for debugging (and some flags are already implemented)
- can read its data from a file
- supports cell naming
- cell and range locking
- input validators
- cell formats (pod, HTML, ...)
- can define spreadsheet functions from the scripts using it or via a new module of your own
- Recalculate() / AUTOCALC
- value caching to speed up formulas and volatile cells
- cell address offsetting functions
- Automatic formula offsetting
- Relative and fixed cell addresses
- slice access
- Perl scalar mapping to a cell
- some debugging tool (dump, dump table, dump to HTML, formula stack trace, ...)

Spreadsheet::WriteExcel module is can be used to create native Excel binary files.

Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesnt require any Windows libraries or a copy of Excel.

It will also work on the majority of Unix and Macintosh platforms. Generated files are compatible with Excel 97, 2000, 2002, and 2003, and with OpenOffice and Gnumeric. An older version also supports Excel 5/95.

KSpread is a scriptable spreadsheet program which provides both table-oriented sheets and support for complex mathematical formulas and statistics.
Main features:
- multiple tables/sheets per document;
- templates;
- multiple chart formats for displaying data graphically;
- headers and footers;
- over 100 formulas, including standard deviation, variance, present value of annuities and much more;
- sorting;
- scripting;
- lists;
- cell data validity checking with configurable warnings/actions;
- comments;
- series (days of week, months of year, numbers, etc.);
- conditional coloring of cells;
- hyperlinks;
- row and column customization (size, show/hide, font type, style and size, etc.);
- cell customization (data/number format, precision, border, alignment, rotation, background color and pattern, font type, style and size, etc.).

GradeL (Gradebook for Linux) is a gradebook program for teachers. Written in Gambas, this program includes some features I felt were important in a gradebook program. While still buggy and incomplete, it is functional.

GradeL requires the development version of Gambas, currently version 1.9.26. GradeL uses Gambas components gb.eval, gb.qt, gb.qt.ext, gb.qt.kde, and gb.qt.kde.html.

Although my coding technique is at times inefficient, GradeL does meet my needs. It features a spreadsheet-style main screen with vertical column headers that include the assignment name, category, and points. Assignments are grouped in categories for reporting purposes. Teachers may enter numerical scores or alpha-numeric codes for student scores.

These codes may count either zero points or excuse the student from that particular assignment. Gambas Grade provides practical reports designed to give plenty of information while conserving paper. Current reports include complete class report, single marking period progress report, and progress reports for all students. One other feature that I really like is an average row included in the spreadsheet that displays the average for the class on every assignment and for the overall marking period grade.

GradeL project is still in its infancy. The program still has bugs and incomplete features. I am making it available now as a preview for review and testing purposes. You may not want to use it as your primary grading program at this time.

Easy Funktion is 2D function plotter software with an equation solver. Easy Funktion has an office-like GUI frontend and features a built-in pocket calculator, calculating with complex numbers (with special extensions for electronics, e.g. capacitor/inductor impedance), a function to export to spreadsheet software, and an advanced formula editor with automatic formatting.
This program alternatively supports an english version of the GUI, but at this time there is no separate english language download available.
In order to activate the english language GUI, do the following:
Open the folder where the program data is installed (/usr/share/easyfunktion). Rename the subfolder de to de_. You may need the root account to do this.
Enhancements:
- Unicode support for Unix.
- An English language GUI with English online help is now available for non-German installations.

Since I am the person who manages the money for our house, I need an efficient way to keep track of our expenses and an easy way to calculate who owes what to whom at the end of the month. There are lots of good free software utilities for managing money like GnuCash, KMyMoney and the wonderful Gnumeric spreadsheet. I had been using Gnumeric to manage the money for the last 8 months, but now that we have some people staying at the house for just the summer, and other leaving and coming back in September, the spreadsheet was not able to adjust to these irregular circumstances.

The reason I decided to write my own application from scratch instead of using an already existing money management application was because my problem is multi-person orientation and most (if not all) of the money management programs I have tried are single-person oriented. For example GnuCash will let you setup accounts that show you all the money moving to and from a single person. But in my house things like food are paid by any person and shared by every other person. Thus to efficiently and easily calculate who owes how much, it must take into account the fact that one pizza may be paid for by one person, but it was eaten by 4 people. Also I dont want to have to divide up the amounts myself and put it into GnuCash with multiple accounts, because then I might as well be doing it on paper.

I could have spent my time learning to make an already existing application do exactly what I want; and I probably would have found something pretty close. But I decided that it would be faster to just program it from scratch and then I would be sure I would get exactly what I wanted. I think I was right; it took less then 2 weeks to finished writing this program.

The program is currently called Adventure Money, but if anyone can think of a better name for it let me know and Ill gladly change it.

When you first launch the program you will see it has five views, all of which can be seen in the screenshots below.