LuaCalc

This is a simple, extendable api+application for Spreadsheet Processing written in lua and C++. You can run the executable 'luacalc' for the graphical interface, or write lua scripts to manipulate files. It's written in wxWidgets, so should be cross platform.

Screenshot:

You can edit data using the mouse/keyboard and the following shortcuts:

Ctrl-C to copy a selection
Ctrl-V to paste
Ctrl-O to Open
Ctrl-S to Save
Ctrl-Z, Ctrl-R to undo/redo
Ctrl-T to sort (Select a row to sort by first)

or you can run the api in an interactive interpreter by doing:

lua -i luacalc.lua

Enter values by assigning them to the 2d array:

luacalc.sheet[1][1]=1 -- Lua Starts indices at 1
luacalc.sheet[1][2]="Hello "
luacalc.sheet[1][3]="World!"
-- use set instead, if you want undo/redo available:
set(1, 1, 1)
set(1, 2, "hello")

So far this doesn't look much like a spreadsheet. But we can now reference the values in a diferent way, and use them in functions:

luacalc.sheet[1][5]="=CONCATENATE(A1:A3)"

Save a file with:

luacalc.save_file('testfile.csv')

Load a file with:

luacalc.load_file('testfile.csv')

Load a (sloppy) csv file with:

luacalc.load_file_csv('testfile.csv')

Sort a sheet by a column.

luacalc.sort(4)

LuaCalc is in a very early stage of development - use at your own risk.

You can download the latest release from here but until the project matures, the svn version is generally the most stable:

svn co https://svn.sourceforge.net/svnroot/luacalc luacalc

You'll need Lua 5.1 to run it and wxWidgets.
If you download LuaCalc, please flick me an email to let me know it's getting used or if you have any questions, comments or would like to help me develop LuaCalc.