website/index.txt in roo-0.2.7 vs website/index.txt in roo-0.3.0
- old
+ new
@@ -85,10 +85,23 @@
<code>
4.upto(oo.last_row) do |line|
</code>
</pre>
+h3. Formulas
+
+Formulas in Openoffice-Spreadsheets can be handled.
+
+oo.celltype(row,col) returns :formula if there is a formula in this cell.
+
+oo.formula(row,col) returns the formula in this cell in a string variable.
+If there is no formula in this cell nil is return
+
+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).
+
+Please note: formulas in Excel-Spreadsheets cannot be handled (this is another gem, see: "Thanks")
+
h3. Using MS-Excel spreadsheets
You can also access MS-Excel spreadsheat.
Replace Openoffice with
@@ -99,9 +112,19 @@
</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,..).
+Formulas cannot be handled in Excel-spreadsheets.
+
+
+h2. Where is it used?
+
+How do you use roo? What are you doing with roo?
+
+If you have an interesting application where you use roo then write me a short description of your project and i will publish it here (write, if your email-address should be published or not).
+
+If you don't want to publish the details you can also write me an email and state, that it should not be published - i am just curious to hear, where it is used.
h2. Documentation
"rdoc":rdoc/index.html