Attachments

import.png

sheet.png

sheets.png

workbooks.png

Spreadsheets

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 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 mathematical operations, 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)).

Features

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
- export to excel workbooks, cvs and tvs
- import excel workbooks (without formulas), cvs and tvs
- Key navigations: TAB moves left, RETURN saves, ESC cancels, UP/DOWN. If we are on the beginning/end of a row we automatically moves to the first/last cell in the column above/belove.
- Context Menu to insert, delete, copy, cut and paste a cell and entire row or column (AJAX calls)

TODO

references across workbooks
- column types (selection list etc)
- column names
- import and export opendocumenr and oasis format
- import formulas
- charset support for export / import
- implement Horde_Lock
- pdf export
- create invoice from a sheet data
- crud actions for ranges
- drag&drop rows, columns, cell ranges
- update only changed cells after range actions, to recalculate formula values
- js storage of raw cell content to avoid ajax calls to start editing
- sort columns
- inline rename/creation of sheets (like google docs)
- list of predefined formulas
- automatic rendering of columns depending on the data type (automatic recognition)
- sheets under the table (like excel)