website/index.html in roo-0.2.7 vs website/index.html in roo-0.3.0

- old
+ new

@@ -31,11 +31,11 @@ <div id="main"> <h1>roo</h1> <div id="version" class="clickable" onclick='document.location = "http://rubyforge.org/projects/roo"; return false'> Get Version - <a href="http://rubyforge.org/projects/roo" class="numbers">0.2.7</a> + <a href="http://rubyforge.org/projects/roo" class="numbers">0.3.0</a> </div> <h2>What</h2> <p>This gem allows you to access the content of open-office and Excel spreadsheets (.ods/.xls).</p> @@ -135,10 +135,29 @@ <code> 4.upto(oo.last_row) do |line| </code> </pre> + <h3>Formulas</h3> + + + <p>Formulas in Openoffice-Spreadsheets can be handled.</p> + + + <p>oo.celltype(row,col) returns :formula if there is a formula in this cell.</p> + + + <p>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</p> + + + <p>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).</p> + + + <p>Please note: formulas in Excel-Spreadsheets cannot be handled (this is another gem, see: &#8220;Thanks&#8221;)</p> + + <h3>Using MS-Excel spreadsheets</h3> <p>You can also access MS-Excel spreadsheat.</p> @@ -152,10 +171,25 @@ <p>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,..).</p> + <p>Formulas cannot be handled in Excel-spreadsheets.</p> + + + <h2>Where is it used?</h2> + + + <p>How do you use roo? What are you doing with roo?</p> + + + <p>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).</p> + + + <p>If you don&#8217;t want to publish the details you can also write me an email and state, that it should not be published &#8211; i am just curious to hear, where it is used.</p> + + <h2>Documentation</h2> <p><a href="rdoc/index.html">rdoc</a></p> @@ -197,10 +231,10 @@ <li><a href="http://rubyforge.org/users/nicwilliams/">Dr Nic Williams</a> for his wonderful gem &#8216;<a href="http://rubyforge.org/projects/newgem/">newgem</a>&#8217; which makes it very convenient to create, manage and publish Ruby gems</li> <li>for the Excel-part the &#8220;spreadsheet&#8217;:http://rubyforge.org/projects/spreadsheet/ gem is used. My functions are a convenient wrapper around the functions of this gem</li> <li>Dirk Huth f&uuml;rs Testen unter Windows</li> </ul> <p class="coda"> - <a href="mailto:drnicwilliams@gmail.com">Dr Nic</a>, 18th June 2007<br> + <a href="mailto:drnicwilliams@gmail.com">Dr Nic</a>, 20th June 2007<br> Theme extended from <a href="http://rb2js.rubyforge.org/">Paul Battley</a> </p> </div> <!-- insert site tracking codes here, like Google Urchin -->