website/index.html in roo-1.0.2 vs website/index.html in roo-1.1.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">1.0.2</a>
+ <a href="http://rubyforge.org/projects/roo" class="numbers">1.1.0</a>
</div>
<h2>What</h2>
<p>This gem allows you to access the content of</p>
@@ -43,14 +43,56 @@
<ul>
<li>Open-office spreadsheets (.ods)</li>
<li>Excel spreadsheets (.xls) </li>
<li>Google (online) spreadsheets</li>
- <li>Excel new file format .xlsx</li>
+ <li>Excel’s new file format .xlsx</li>
</ul>
+ <h2>Supporting this project</h2>
+
+
+ <p>Die Programme dieses Projekts sind kostenlos erhältlich und verwendbar.
+Du kannst jedoch die weitere Entwicklung dieses Projekts mit einer finanziellen
+Zuwendung unterstützen (ansonsten müßte ich mich verstärkt anderen Projekten
+widmen, die mehr finanziellen Ertrag einbringen, damit ich auch morgen noch
+für meine Katzen das Futter kaufen kann :-)).</p>
+
+
+ <p>Am bequemsten kannst du per Paypal an die Email-Adresse thopre@gmail.com
+bezahlen.
+Falls du per Überweisung zahlen willst, frage bitte nach meiner Kontoverbindung!</p>
+
+
+ <p>Ich werde, aufteilt pro Quartal, eine Liste der Spender mit Namen und Betrag,
+sortiert nach Spendenhöhe hier veröffenlichen. Wenn von dir nichts anderes
+mitgeteilt, werde ich dich nach deinem Namen, soweit aus der Email-Adresse
+ersichtlich, in der Liste veröffenlichen. Falls etwas anderes gewünscht wird,
+z. B. “Firma <span class="caps">ABC</span> GmbH” oder anonym, dann teile mir dies bitte mit!</p>
+
+
+ <h3>Spender</h3>
+
+
+ <h4>April-Juni 2008</h4>
+
+
+ <table>
+ <tr>
+ <td>Betrag</td>
+ <td>Name</td>
+ </tr>
+ <tr>
+ <td>0,00 €</td>
+ <td>Test</td>
+ </tr>
+ </table>
+
+
+
+
<h2>Installing</h2>
<pre syntax="ruby">[sudo] gem install roo</pre>
@@ -191,14 +233,19 @@
<p>oo.<strong>formula?</strong>(row,col) returns true if there is a formula</p>
- <p>oo.<strong>formula</strong>(row,col) returns the formula in this cell in a string variable (like ”=<acronym title="[.A1:.M13]">SUM</acronym>”). You can do whatever you want with this expression.
-If there is no formula in this cell nil is returned.</p>
+ <p>oo.<strong>formula</strong>(row,col) returns the formula in this cell in a string variable (like ”=<acronym title="[.A1:.M13]">SUM</acronym>”).
+ You can do whatever you want with this expression. Please note that the syntax of
+formulas might vary between different sort of spreadsheets. There is no conversion
+of the formula syntax.</p>
+ <p>If there is no formula in this cell nil is returned.</p>
+
+
<p>oo.<strong>cell</strong>(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>oo.<strong>formulas</strong> returns all formulas in the selected spreadsheet in an array like this:</p>
@@ -276,10 +323,13 @@
<code>oo = Excel.new("simple_spreadsheet.xls").
</code>
</pre>
+ <p>or Google.new() or Excelx.new().</p>
+
+
All methode are the same for OpenOffice-, Excel- and Google-objects.
<strike> 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,..).
</strike>
@@ -346,10 +396,41 @@
<p>This gem does not check if you are allowed to access a specific google spreadsheet. If it’s not your own spreadsheet or you are not allowed to read or wwrite to a spreadsheet the behaviour is not defined (but it will not work ;-) ).</p>
+ <p>The default behavior at opening a spreadsheet with a certain extension has been
+changed.
+Say you’re trying to open a spreadsheet file with the extension .xls, which is normally
+ an Excel file
+with the Openoffice.new() call. This cannot work, if the file is really an excel file – instead
+you have to open it with the Excel.new() call.</p>
+
+
+ <p>Now you’re getting an exception raised. Before it was was only a warning and the
+access to this file failed.</p>
+
+
+ <p>Theorectically you can have a file with the extension .xls which is in fact an Openoffice spreadsheet file.</p>
+
+
+ <p>It’s possible to open such a file with the Openoffice class, but you have have to
+override the parameter ‘file_warning’ in the new method:
+‘Openoffice.new(‘myfile.xls’, false, :warning)’ or
+‘Openoffice.new(‘myfile.xls’, false, :ignore)’.</p>
+
+
+ <p>If you set it to :warning you get a warning if you try to use a spreadsheet file with
+the ‘false’ extension, but the
+program will try to handle the file with this class (of course this will fail, if the file
+is really of the false type).</p>
+
+
+ <p>If you completely know what you are doing you can also disable the warning with the
+parameter :ignore.</p>
+
+
<h3>Accessing Spreadsheet over the Web</h3>
You can even read openoffice or excel-spreadsheets from a http-address:
<pre>
@@ -369,11 +450,11 @@
<pre>
<code>oo.remove_tmp
</code>
</pre>
- <p>to delete the temporary local copy of the spreadsheet file. If you dont call
+ <p>to delete the temporary local copy of the spreadsheet file. If you don’t call
this method you will have subdirectories names ‘oo_xxxxx’ which you can remove manually.
Calling remove_tmp is not the best solution to clean temporary files – i will
provide a better solution in the next releases.</p>
@@ -483,10 +564,10 @@
<li>for the Excel-part the <a href="http://rubyforge.org/projects/spreadsheet/">spreadsheet</a> 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>
<li>Thanks to davecahill for a bug-fix patch within the google part</li>
</ul>
<p class="coda">
- <a href="mailto:thopre@gmail.com">Thomas Preymesser</a>, 28th May 2008<br>
+ <a href="mailto:thopre@gmail.com">Thomas Preymesser</a>, 17th July 2008<br>
Theme extended from <a href="http://rb2js.rubyforge.org/">Paul Battley</a>
</p>
</div>
<!-- insert site tracking codes here, like Google Urchin -->