website/index.html in roo-1.11.2 vs website/index.html in roo-1.12.0
- old
+ new
@@ -93,14 +93,14 @@
<p>You can now process this spreadsheet with the following sample code.</p>
<pre>
<code>
1 require 'rubygems'
2 require 'roo'
- 3
+ 3
4 HOURLY_RATE = 123.45
- 5
- 6 oo = Openoffice.new("simple_spreadsheet.ods")
+ 5
+ 6 oo = OpenOffice.new("simple_spreadsheet.ods")
7 oo.default_sheet = oo.sheets.first
8 4.upto(12) do |line|
9 date = oo.cell(line,'A')
10 start_time = oo.cell(line,'B')
11 end_time = oo.cell(line,'C')
@@ -176,11 +176,11 @@
oo.set_value(row, col, value)
</code>
</pre>
<p>There is an example in the examples folder which illustrates write access.</p>
<h3>Formulas</h3>
-<p>Formulas in Openoffice- and Google-Spreadsheets can be handled.</p>
+<p>Formulas in OpenOffice- and Google-Spreadsheets can be handled.</p>
<p>oo.<strong>celltype</strong>(row,col) returns :formula if there is a formula in this cell.</p>
<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]"><span class="caps">SUM</span></acronym>”).<br />
You can do whatever you want with this expression. Please note that the syntax of<br />
formulas might vary between different sort of spreadsheets. There is no conversion<br />
@@ -222,11 +222,11 @@
</code>
</pre>
<p>to write to a file.</p>
<h3>Using MS-Excel spreadsheets</h3>
<p>You can also access MS-Excel spreadsheat.</p>
-<p>Replace Openoffice with <br />
+<p>Replace OpenOffice with <br />
<pre><br />
<code>oo = Excel.new("simple_spreadsheet.xls").</p>
<p></code><br />
</pre></p>
<p>or Google.new() or Excelx.new().</p>
@@ -280,19 +280,19 @@
<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 write 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 <br />
changed.<br />
Say you’re trying to open a spreadsheet file with the extension .xls, which is normally<br />
an Excel file <br />
-with the Openoffice.new() call. This cannot work, if the file is really an excel file – instead <br />
+with the OpenOffice.new() call. This cannot work, if the file is really an excel file – instead <br />
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<br />
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<br />
+<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<br />
override the parameter ‘file_warning’ in the new method: <br />
-‘Openoffice.new(’myfile.xls’, false, :warning)’ or<br />
-‘Openoffice.new(’myfile.xls’, false, :ignore)’.</p>
+‘OpenOffice.new(’myfile.xls’, false, :warning)’ or<br />
+‘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 <br />
the ‘false’ extension, but the <br />
program will try to handle the file with this class (of course this will fail, if the file<br />
is really of the false type).</p>
<p>If you completely know what you are doing you can also disable the warning with the<br />
@@ -305,35 +305,35 @@
ROO_TMP was introduced in releases >1.1.0.</p>
<h3>Accessing Spreadsheet over the Web</h3>
<p>You can even read openoffice or excel-spreadsheets from a http-address:<br />
<pre><br />
<code>oo = Excel.new("http://www.somedomain.com/simple_spreadsheet.xls").
-oo = Openoffice.new("http://www.somedomain.com/simple_spreadsheet.ods").
+oo = OpenOffice.new("http://www.somedomain.com/simple_spreadsheet.ods").
</code><br />
</pre></p>
<p>or a zipped file:<br />
<pre><br />
<code>oo = Excel.new("http://www.somedomain.com/simple_spreadsheet.xls.zip",:zip).
-oo = Openoffice.new("http://www.somedomain.com/simple_spreadsheet.ods.zip",:zip).
+oo = OpenOffice.new("http://www.somedomain.com/simple_spreadsheet.ods.zip",:zip).
</code><br />
</pre></p>
<p>after working with a spreadsheet from the web you have to call <br />
<pre><br />
-<code>oo.remove_tmp
+<code>oo.remove_tmp
</code><br />
</pre></p>
<p>to delete the temporary local copy of the spreadsheet file. If you don’t call<br />
this method you will have subdirectories names ‘oo_xxxxx’ which you can remove manually.<br />
Calling remove_tmp is not the best solution to clean temporary files – i will <br />
provide a better solution in the next releases.</p>
<h3>Remote Access</h3>
<p>You can even access your spreadsheet data from a remote machine via <span class="caps">SOAP</span>. The examples directory shows a little example how to do this. If you like, you can extend these functions or restrict the access to certain cells. <br />
Remote access with <span class="caps">SOAP</span> is nothing specific to roo, you can do this with every Rub object, but i thought it would nice to give an example what could be done with roo.</p>
-<h3>Excel spreadsheets / Openoffice spreadsheets / Google spreadsheets with Ruby on Rails</h3>
+<h3>Excel spreadsheets / OpenOffice spreadsheets / Google spreadsheets with Ruby on Rails</h3>
<p>There is a simple helper method to display a spreadsheet at your application page:</p>
<ul>
- <li>in your controller, add “require ‘roo’” and “@rspreadsheet = Openoffice.new(”numbers1.ods")" or<br />
- “@rspreadsheet = Openoffice.new(”http://www.somehost.com/data/numbers1.od s")" to get access to your spreadsheet file</li>
+ <li>in your controller, add “require ‘roo’” and “@rspreadsheet = OpenOffice.new(”numbers1.ods")" or<br />
+ “@rspreadsheet = OpenOffice.new(”http://www.somehost.com/data/numbers1.od s")" to get access to your spreadsheet file</li>
<li>use it in any view of your application with “<%= spreadsheet @rspreadsheet, [”Tabelle"] %><br/>" or one of the following formats</li>
</ul>
<p><img src="Roo_Spreadsheets_Rails.png"></p>
<h2>Where is it used?</h2>
<p>How do you use roo? What are you doing with roo?</p>