Attachments

 import.png
 sheet.png
 sheets.png
 workbooks.png

[[toc]]

• Spreadsheets

Online spreadsheets Horde module.

++ Bugs

List any tickets on http://bugs.horde.org/ that cover this issue or are relevant to it.

++ People

Duck [mailto:duck@obala.net duck@obala.net]

++ Description

A module to allow edit and share spreadsheets. It not need to be a full featured like spreadsheet application but just a simple table editing functionality (no merged cells, graphs etc) and with some basic math opertions, range functions: COUNT, SUM, AVERAGE, MIN, MAX and php build in muth functions (SIN, COS, TAN, ATAN, PI, SQRT, EXP, LN, LOG10, ABS, ATAN2, ASIN, ACOS, TRIM, SINH, COSH, TANH, ASINH, ACOSH, ATANH, LN (as PHP LOG), LEN (as PHP STRLEN)).

Attached is a experimental try formula calculation. Actually is able to:

• create and share workbooks

• edit, add, rename, delete sheets

• duplicate or better copy sheets to desired workbook

• parse spread sheet formula

• basic calculation of spredsheet formula

• support functions listed in the description above

• cell references (inside the same workbook)

• store sheet data in VFS and sheet parameters in SQL

Next things todo

• add/remove sheets

• references across workbooks

• column types (selection list etc)

• import / export

• implement Horde_Lock

++ Resources

http://ewbi.blogs.com/develops/popular/excelformulaparsing.html

http://www.millstream.com.au/upload/code/tablekit/

http://code.google.com/p/trimpath/wiki/TrimSpreadsheet

++ Sheet

[[image spread.png]]

Back to the ((Projects|Project List))