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: “Thanks”)</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’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.</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 ‘<a href="http://rubyforge.org/projects/newgem/">newgem</a>’ which makes it very convenient to create, manage and publish Ruby gems</li>
<li>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</li>
<li>Dirk Huth fü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 -->