website/index.txt in roo-1.0.2 vs website/index.txt in roo-1.1.0
- old
+ new
@@ -5,12 +5,40 @@
This gem allows you to access the content of
* Open-office spreadsheets (.ods)
* Excel spreadsheets (.xls)
* Google (online) spreadsheets
-* Excel new file format .xlsx
+* Excel's new file format .xlsx
+h2. Supporting this project
+
+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 :-)).
+
+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!
+
+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 ABC GmbH" oder anonym, dann teile mir dies bitte mit!
+
+h3. Spender
+
+h4. April-Juni 2008
+
+table.
+|Betrag|Name|
+|0,00 €|Test|
+
+
+
h2. Installing
<pre syntax="ruby">[sudo] gem install roo</pre>
h2. The basics
@@ -125,11 +153,15 @@
oo.*celltype*(row,col) returns :formula if there is a formula in this cell.
oo.*formula?*(row,col) returns true if there is a formula
-oo.*formula*(row,col) returns the formula in this cell in a string variable (like "=SUM([.A1:.M13])"). You can do whatever you want with this expression.
+oo.*formula*(row,col) returns the formula in this cell in a string variable (like "=SUM([.A1:.M13])").
+ 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.
+
If there is no formula in this cell nil is returned.
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).
oo.*formulas* returns all formulas in the selected spreadsheet in an array like this:
@@ -192,10 +224,12 @@
<code>oo = Excel.new("simple_spreadsheet.xls").
</code>
</pre>
+or Google.new() or Excelx.new().
+
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>
@@ -225,11 +259,35 @@
export GOOGLE_MAIL="yourname@gmail.com"
export GOOGLE_PASSWORD="mysecretpassword"
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 ;-) ).
+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.
+Now you're getting an exception raised. Before it was was only a warning and the
+access to this file failed.
+
+Theorectically you can have a file with the extension .xls which is in fact an Openoffice spreadsheet file.
+
+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)'.
+
+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).
+
+If you completely know what you are doing you can also disable the warning with the
+parameter :ignore.
+
h3. Accessing Spreadsheet over the Web
You can even read openoffice or excel-spreadsheets from a http-address:
<pre>
<code>oo = Excel.new("http://www.somedomain.com/simple_spreadsheet.xls").
@@ -248,10 +306,10 @@
<pre>
<code>oo.remove_tmp
</code>
</pre>
-to delete the temporary local copy of the spreadsheet file. If you dont call
+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.