Free formulas for excel software for linux

KFormula can be used to create and edit mathematical formulas that can be included in other KOffice documents. KFormula provides simple input facilities and supports the functionality you expect from a KOffice application.
Main features:
- Easy Greek letter insertion
- Intelligent cursor movement
- Advanced syntax highlighting
- Multi-level undo support
- LaTeX export (copy and paste into a text editor)
- MathML import
KFormula uses the KOffice formula drawing library. If you have to deal with many formulas you may wish to use a KFormula object embedded in KWord or KSpread.

XML::Excel is a Perl extension converting Excel files to XML.

SYNOPSIS

use XML::Excel;
$excel_obj = XML::Excel->new();
$excel_obj = XML::Excel->new(%attr);

$status = $excel_obj->parse_doc(file_name);
$status = $excel_obj->parse_doc(file_name, %attr);

$excel_obj->declare_xml(%attr);
$excel_obj->declare_doctype(%attr);

$excel_obj->print_xml(file_name, %attr);

XML::Excel is a new module which is going to be upgraded very often as my time permits. For the time being it uses Spreadsheet::ParseExcel module object default values to parse the (*.xls) document and then creates a perl data structure with xml tags names and data. At this point it does not allow for a write as you parse interface but is the first upgrade for the next release. I will also allow more access to the data structures and more documentation.

I will also put in more support for XML, since currently it only allows a simple XML structure. Currently you can modify the tag structure to allow for attributes. No DTD support is currently available, but will be implemented in a soon coming release. As the module will provide both: object and event interfaces, it will be used upon individual needs, system resources, and required performance. Ofcourse the DOM implementation takes up more resources and in some instances timing, its the easiest to use.

App::ErrorCalculator is a Perl module that contains calculations with Gaussian Error Propagation.

SYNOPSIS

# You can use the errorcalculator script instead.

require App::ErrorCalculator;
App::ErrorCalculator->run();

# Using the script:
# errorcalculator

errorcalculator and its implementing Perl module App::ErrorCalculator is a Gtk2 tool that lets you do calculations with automatic error propagation.

Start the script, enter a function into the function entry field, select an input file, select an output file and hit the Run Calculation button to have all data in the input field processed according to the function and written to the output file.
Functions should consist of a function name followed by an equals sign and a function body. All identifiers (both the function name and all variables in the function body) should start with a letter. They may contain letters, numbers and underscores.

The function body may contain any number of constants, variables, operators, functions and parenthesis. The exact syntax can be obtained by reading the manual page for Math::Symbolic::Parser. Arithmetic operators (+ - * / ^) are supported. The caret indicates exponentiation. Trigonometric, inverse trigonometric and hyperbolic functions are implemented (sin cos tan cot asin acos atan acot sinh cosh asinh acoth). log indicates a natural logarithm.

Additionally, you may include derivatives in the formula which will be evaluated (analytically) for you. The syntax for this is: partial_derivative(a * x + b, x). (Would evaluate to a.)

In order to allow for errors in constants, the program uses the Math::SymbolicX::Error parser extension: use the error(1 +/- 0.2) function to include constants with associated uncertainties in your formulas.

The input files may be of any format recognized by the Spreadsheet::Read module. That means: Excel sheets, OpenOffice (1.0) spreadsheets, CSV (comma separated values) text files, etc.

The program reads tabular data from the spreadsheet file. It expects each column to contain the data for one variable in the formula.

a, b, c
1, 2, 3
4, 5, 6
7, 8, 9

This would assign 1 to the variable a, 2 to b and 3 to c and then evaluate the formula with those values. The result would be written to the first data line of the output file. Then, the data in the next row will be used and so on. If a column is missing data, it is assumed to be zero.

Since this is about errors, you can declare any number of errors to the numbers as demonstrated below:

a, a_1, a_2, b, b_1
1, 0.2, 0.1, 2, 0.3
4, 0.3, 0.3, 5, 0.6
7, 0.4, 0,1, 8, 0.9

Apart from dropping c for brevity, this example input adds columns for the errors of a and b. a has two errors: a_1 and a_2. b only has one error b_1 which corresponds to the error a_1. When calculating, a will be used as 1 +/- 0.2 +/- 0.1 in the first calculation and b as 2 +/- 0.3 +/- 0. The error propagation is implemented using Number::WithError so thats where you go for details.

The output file will be a CSV file similar to the input examples above.

Java2Excel is a library that allows the generation of simple excel files using objects of type java.util.Collection.
The current verison of Java2Excel contains a lot of limitations. You can only write the collection in excel files using an xml file as a descriptor of what properties you want in the excel file. In the current state, there is not much error checking.
Example
The following is an example of an xml file used to configure the output to excel.
Please, note that this is a preliminary version and this file may not be compatible with future versions
< ?xml version="1.0" encoding="ISO-8859-1"?>
< !DOCTYPE java2excel PUBLIC
"-//epere4/DTD Java2Excel mapping file//EN"
"http://java2excel.sourceforge.net/dtd/java2excel-mapping.dtd">
< java2excel>
< header>
nothing for now
< /header>
< body>
< properties>
< property name="text">
< description>
This is a text property.
< /description>
< /property>
< property name="integerNumber" />
< property name="date" />
< property name="calendar" />
< property name="boolValue" />
< property name="internal.integerNumber" />
< /properties>
< /body>
< /java2excel>
The name attributes are ognl expressions that are applied to each element in the collection.
For example, integerNumber will be traduced to something like elementInCollection.getIntegerNumber() (with elementInCollection being the name of the variable for each element in the collection, of course). A more complex expresion like internal.integerNumber is equivalent to elementInCollection.getInternal().getIntegerNumber() (watch for NullPointerExceptions, here; there will be some protection for this in future releases)
The following is the code used in ar.com.epere4.java2excel.excelWritter.ExcelWritterTest .
The getMockCollection(5) method, not shown here, will just generate a java.util.Collection with 5 elements that will have all the properties requested by the XML file previously shown.
Parser parser = new Parser();
Java2ExcelDtd java2ExcelDtd = parser.parse(this.getClass()
.getResourceAsStream("/ar/com/epere4/java2excel/excelWritter/ExcelWritterTest.xml"));
ExcelWritter excelWritter = new ExcelWritter();
excelWritter.addReport(getMockCollection(5), java2ExcelDtd);
excelWritter.saveTo(new File("anExcel.xls"));
Enhancements:
- The "Too many different cell formats" error message in Excel was fixed.
- An id was added for properties.
- If not specified, it will continue to be the expression, as before.
- The setIncludeExtraLevel method was added to the BodyDtd interface.
- Maven 2.0 is now used.
- Maven 1.0 support should be considered deprecated.
- It will be maintained only for code dependencies, but the site will be generated using Maven 2.0 from now on.

php_writeexcel is a port of John McNamaras excellent Spreadsheet::WriteExcel Perl package to PHP. It allows you to generate Microsoft Excel documents on your PHP enabled Web server without any other tools.
Ive included six example PHP scripts which are also taken out of the
Spreadsheet::WriteExcel package and ported to PHP:
- example-simple.php
- example-merge2.php
- example-stocks.php
- example-textwrap.php
- example-demo.php
- example-bigfile.php
All you have to do is to tar xzvf the package to a directory accessible via a web server. Then fetch any of the example scripts with your favourite web browser and Excel should come into place and show you a sheet.
Basically all features of Spreadsheet::WriteExcel are supported and thanks to a lot of people (see CHANGELOG) who contributed code and bug fixes, most things seem to work. However, please remember that its still in beta stage, so there are probably some bugs left.
Spreadsheet::WriteExcel uses the Parse::RecDescent package for formula support. Andreas Brodowski has imported and changed the PEAR::Spreadsheet Parser.php file, so formulas are supported since version 0.2.2.
Spreadsheet::WriteExcel uses the OLE::Storage_Lite package for supporting Excel files bigger than approx. 7 MB. I have ported this package already and called it php_ole. But I really dont know how reliable it is, so use it with care!
Enhancements:
- PHP5 compatibility has been added.
- Several bugs have been fixed.

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.

Table2Clipboard is a Mozilla applications allow to select rows and columns from a table simply pressing Control key and picking rows/columns with left mouse button.

The selection can be copied to clipboard but the original table disposition is lost making ugly results when you paste the text on datasheet applications (eg excel).

If you want to paste data in Microsoft Excel on OpenOffice Calc with correct disposition simply use Table2Clipboard.

Pasting in plain text editors is also supported as CSV file (but you can change rows and columns separators from option dialog)