Free spreadsheets software for linux

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::ParseExcel is a Perl module to get information from an Excel file.

This module allows you to get information from Excel file.

This module can handle files of Excel95, 97 and 2000. (and now supports Excel4)

The module will work on the majority of Windows, UNIX and Macintosh platforms.

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

Spruce is an X11 mail user agent (commonly known as an email client) written with the Gtk+ widget set. It is extremely small and fast and has all the common features of an usual user.
Spruce supports MIME (Multipurpose Internet Mail Extensions), an Internet Standard for representing multipart and multimedia data in email. Spruce allows you to save MIME objects to files. Spruces message composer does not currently have integral multimedia capability, but any type of data file (including multimedia) can be attached to a text message and sent using MIMEs encoding rules. This allows any group of individuals with MIME-capable mail software (e.g. Spruce, Kmail, Pine, or many other programs) to exchange formatted documents, spreadsheets, image files, etc, via Internet email.
At the present time, spruce uses its own SMTP interface to send mail. Future versions may support the ability to have an external program like Sendmail send messages as an alternative.
Spruce currently supports several different methods of mail retrieval. Currently supported are: POP (POP3, APOP, and POP with CRAM-MD5 Authentication), IMAP (also supports CRAM-MD5 Authentication) and mbox (mbox is the standard UNIX mail format. These mailboxes are commonly found in /var/spool/mail and/or in the users home directory: ~/mbox).
Main features:
- View, Save, Delete, Expunge, Print, Copy/Move between mailboxes, Reply and Forward messages
- Compose messages in a simple editor with word-wrap. Allows inserting text files into the editor to save composition time through a menu option. Supports adding file attachments via toolbar button
- Easy manipulation of mailboxes and messages using both menus and drag-and-drop technology
- Address book to keep a list of long or frequently used addresses
- New mail checking at the press of a button or on a set timer

FreeWERM (short for "Free Web-based Employee Reporting Module") is an easy-to-use software system for creating, maintaining, and reporting on employee profiles for any sort of business. It has a time clock feature similar to other pieces of software currently on SourceForge, but FreeWERM is also much more than that. FreeWERM stores all employees that have worked for a company, along with their personal information, hours worked, company-defined payroll departments, and even user accounts.

It runs on Linux-based operating systems (I used Ubuntu) and uses PHP, Perl, and some light JavaScript, along with a MySQL database to store its information. It was developed by me to help my companys HR department deal with the problems of managing and reporting for an employee roster with several hundred names on it and an extremely high turnover rate (i.e. telemarketing firm), although it works just as well for a company with 10 employees.

FreeWERM stores personal information (name, address, phone, etc), but it also keeps track of individual Human Resources-related data for each employee, such as how many days absent (and what kind of absence - vacation, sick, bereavement), salary information, and FreeWERM is also capable of keeping track of which employees have been hired, fired, and re-hired by the same company and on what date(s). Also, whenever an employee is added to FreeWERMs database or when an existing employees profile is modified, FreeWERM creates a PDF document version of the new/updated employees profile. The employees data can be used to generate HR reports - users can create reports showing new hires or new terminations for a certain department for a certain date range, or reports can be generated that show payroll information, to name a few. FreeWERM is even capable of creating PDF documents containing employee names and addresses in a format suitable for printing to sheets of label stickers for envelopes.

The most-often used feature of FreeWERM is the time clock. Its a very simple interface that only requires the employee to enter in their unique employee ID number (which is assigned at the time the employee is entered into the system). If the employee is not clocked in, the system clocks them in under the department listed on their profile. If the employee is already clocked in, they are clocked out and the information for the shift they worked is then stored in a table of time clock records. FreeWERM can take these records and make complete, organized Excel spreadsheets that not only display hours worked by employees, but also can calculate how much money the employee is owed for the hours worked.

FreeWERM can be used to create user accounts so only certain employees can use the module. There are over a dozen different privileges that can be granted to users, from manually inserting time clock records for employees to allowing the user to grant/modify permissions to other users. User privileges can also be refined to the point where users may only be allowed access to records/employees belonging to specific payroll departments. Also, FreeWERM logs user activity to a special access_log table in its MySQL database. Any changes, additions, or removal of information through FreeWERM is stored along with the date and time of the action and ID number of the user who performed it.

Whats New in This Release:

New files:

./import_info.pl **
./import_rowdisplay.pl **
./includes/import_info.inc **

Altered files:

./hr_excel_reports.pl
./printable_report.php
./includes/absence_form.inc
./includes/access_log_query.inc
./includes/employee_access.inc
./includes/hr_reports.inc
./includes/new_employee.inc
./includes/payroll_dept.inc
./includes/search_form.inc
./includes/time_clock.inc **
./includes/time_clock_rpt.inc

Simple Groupware is a complete groupware package written in PHP, XML, SQL, HTML, CSS and sgsML.
Unlike other groupware software, Simple Groupware contains the new programming language sgsML. It enables the quick creation of powerful web applications.
Simple Groupware is Free Software, released under the GNU GPLv2 License.
Main features:
- A 100% web-based application (no special client applications or plugins required). Optional a client for Windows is available to make downloads/uploads easier
- Complete secure communication using SSL
- Easy and intuitive user interface
- One platform for managing, controlling and developing business processes
- Autonomy: Simple Groupware is fully driven with open technologies
- Individuality: All hierarchical organization structures and responsibilities can be represented and managed in the application
- Intelligent knowledge management: e.g. find everything faster using phonetic search algorithms and automatic file / content indexing
- Notifications: get notified when data changes by using RSS feeds
- Unicode: Simple Groupware fully supports Unicode characters using UTF-8
Modules included:
- Calendar
- Contacts
- E-mails
- Tasks
- Files
- Notes
- Passwords
- Bookmarks
- Portal
- Chat
- FAQ
- News
- Forum
- Gallery
- Projects
- Statuses
- Templates
- Inventories
- Resources
- Brands
- Locations
- Distributors
- Device types
- Offices
- Positions
- Companies
- Departments
- Contact groups
- Contact activities
- Spreadsheets
- Users
- Groups
- Events
- Backups
- Rights
- Search
- Statistics
- iCalendar
- IMAP
- POP3
- SMTP
- RSS
- vCard
- LDAP contacts