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 &euro;|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.