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