Spreadsheets
Bugs
People
Code
Description
Features
TODO
Resources
Screenshots



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