[cvs] [Wiki] changed: Project/Spread

[Duck]

duck  Sat, 21 Jun 2008 05:41:17 -0400

Modified page: http://wiki.horde.org/Project/Spread
New Revision:  1.5
Change log:  import / export excel

@@ -12,33 +12,40 @@
  Duck [mailto:duck at obala.net duck at 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)).
+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)).

-Attached is a experimental try formula calculation. Actually is able to:
+Attached is a experimental module. 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
+* export to excel workbooks
+* import excel workbooks (without formulas)

-Next things todo
-* add/remove sheets
+++ TODO
  * references across workbooks
  * column types (selection list etc)
-* import / export
+* import and export opendocumetn and oasis format
+* import formulas
+* charset support for export / import
  * implement Horde_Lock
+* pdf
+* create invoice from a sheet data
+* column names

  ++ 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))