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
Code
http://cvs.horde.org/incubator/spread/
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 data to:
- CVS
- TVS
- XML
- YAML
- Open Document Spreadsheet
- Open Document Text
- Microsoft Excel 2000
- Microsoft Word 2000
- Microsoft Excel 95
- import sheets/workbooks
- CVS
- TVS
- Microsoft Excel 95 (without formulas)
- YAML
- Turba contants manager
- from any module having listCostObject api method
- 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
- column formatting
- automatic rendering of columns depending on the data type
- data type automatic recognition
- import and export in Oasis format (default format of Koffice, Openoffice.org,...)
- import formulas
- character support for export / import data
- import, manage and then update application data (like Turba contacts)
- implement Horde_Lock
- PDF export
- create invoice from a sheet data
- CRUD actions for ranges
- drag&drop rows, columns, cells, ranges
- update only changed cells after an action (recalculated formula values)
- JS storage of raw cell content to avoid ajax calls to start editing (can be a problem when multiply users will edit a sheet at a same time)
- sort columns
- inline rename/creation of sheets (like google docs)
- list of predefined formulas
- graphs
Resources
http://jqueryplugins.weebly.com/jquerysheet.html
http://ewbi.blogs.com/develops/popular/excelformulaparsing.html
http://www.millstream.com.au/upload/code/tablekit/
http://code.google.com/p/trimpath/wiki/TrimSpreadsheet
Screenshots
Editing sheet
Manage sheets
Manage workbooks
Import data
Back to the Project List