index.txt in roo-0.5.0

- old
+ new

@@ -85,32 +85,47 @@
 <code>
   4.upto(oo.last_row) do |line|
 </code>
 </pre>
 
+h3. Cell Types
+
+oo.*celltype*(row,col) returns the type of a cell. Currently these types will be
+returned:
+
+* :float
+* :string
+* :date
+* :percentage
+* :formula
+
 h3. Formulas
 
 Formulas in Openoffice-Spreadsheets can be handled. 
 
-oo.celltype(row,col) returns :formula if there is a formula in this cell.
+oo.*celltype*(row,col) returns :formula if there is a formula in this cell.
 
-oo.formula?(row,col) returns true if there is a formula
+oo.*formula?*(row,col) returns true if there is a formula
 
-oo.formula(row,col) returns the formula in this cell in a string variable (like "=SUM([.A1:.M13])"). You can do whatever you want with this expression.
+oo.*formula*(row,col) returns the formula in this cell in a string variable (like "=SUM([.A1:.M13])"). You can do whatever you want with this expression.
 If there is no formula in this cell nil is returned.
 
-oo.cell(row,col) returns the computed result of the formula (as it was saved in the file, no recalculation is done in this Gem).
+oo.*cell*(row,col) returns the computed result of the formula (as it was saved in the file, no recalculation is done in this Gem).
 
-oo.formulas returns all formulas in the selected spreadsheet in an array like this:
+oo.*formulas* returns all formulas in the selected spreadsheet in an array like this:
 
+<pre>
+<code>
   [[1,2,"=SUM(.A1:.B1)"],
    [1,3,"=SIN(.C3)"],
    [1,4,"=COS(.D4)"]]
+</code>
+</pre>
 
-Each entry consists of the elements row, col, formual.
+Each entry consists of the elements row, col, formula.
 
-Note: oo.cell(row,col) is the same for ordinary cells and formulas. So you can use the computated value of a formula. If you have to distinguish if a cell is a formula use #formula? 
+Note: oo.*cell*(row,col) is the same for ordinary cells and formulas. So you can use the computated value of a formula. If you have to distinguish if a cell is a formula use #*formula*? 
 
 Please note: formulas in Excel-Spreadsheets cannot be handled (this is another gem, see: "Thanks")
 
 h3. YAML-Output
 
@@ -139,22 +154,29 @@
 </pre>
 
 All methode are the same for OpenOffice and Excel-objects. The only difference
 is the setting of the default-worksheet. OpenOffice uses the name of the worksheet whereas Excel needs the index of the worksheet (1,2,3,..).
 
+EDIT: since the release 0.4.2, default_sheet in Excel-object can be handled with names like the Openoffice-sheet.
+
 Formulas can only be handled in OpenOffice-spreadsheets.
 
 Features in OpenOffice and Excel:
 
 table(border:1px solid black).
 |feature|Open Office|Excel|
-|default_sheet|as name|as number|
+|default_sheet|as name|as number or name (>=0.4.2)|
 |formulas|yes|no|
 |to_yaml|yes|yes|
 
-Old .sxc OpenOffice files are currently not supported - please load these files and save as an "OpenDocument Spreadsheet (.ods)".
+Old .sxc OpenOffice files are currently not supported - please load these files and save it as an "OpenDocument Spreadsheet (.ods)".
 
+h3. Remote Access
+
+You can even access your spreadsheet data from a remote machine via SOAP. The examples directory shows a little example how to do this. If you like, you can extend these functions or restrict the access to certain cells. 
+Remote access with SOAP is nothing specific to roo, you can do this with every Rub object, but i thought it would nice to give an example what could be done with roo.
+
 h2. Where is it used?
 
 How do you use roo? What are you doing with roo?
 
 * The author of this gem uses roo for the generation of weekly reports which are (automatically) sent to his customers (Thomas Preymesser, Homepage: www.thopre.com, Blog: thopre.wordpress.com, email me: thopre@gmail.com)
@@ -181,10 +203,16 @@
 
 h2. Wiki
 
 "http://roo.rubyforge.org/wiki/wiki.pl":http://roo.rubyforge.org/wiki/wiki.pl
 
+h2. How to submit patches
+
+Read the "8 steps for fixing other people's code":http://drnicwilliams.com/2007/06/01/8-steps-for-fixing-other-peoples-code/ and for section "8b: Submit patch to Google Groups":http://drnicwilliams.com/2007/06/01/8-steps-for-fixing-other-peoples-code/#8b-google-groups, use the Google Group above.
+
+The trunk repository is <code>svn://rubyforge.org/var/svn/gorank/trunk</code> for anonymous access.
+
 h2. License
 
 This code is free to use under the terms of Ruby
 
 h2. Contact
@@ -192,7 +220,7 @@
 Comments are welcome. Send an email to "Thomas Preymesser":mailto:thopre@gmail.com.
 
 h2. Thanks
 
 * "Dr Nic Williams":http://rubyforge.org/users/nicwilliams/ for his wonderful gem '"newgem":http://rubyforge.org/projects/newgem/' which makes it very convenient to create, manage and publish Ruby gems
-* for the Excel-part the "spreadsheet':http://rubyforge.org/projects/spreadsheet/ gem is used. My functions are a convenient wrapper around the functions of this gem
+* for the Excel-part the "spreadsheet":http://rubyforge.org/projects/spreadsheet/ gem is used. My functions are a convenient wrapper around the functions of this gem
 * Dirk Huth f&uuml;rs Testen unter Windows