Spreadsheet modifications

<< Savon | Index | Yardoc >>

1.12.2011

Outstanding issues:

1. https://groups.google.com/forum/#!topic/rubyspreadsheet/EtdRvXDN5rc
   • We have to use Alt+0160 to have the same space in excel
2. Timon added these changes: released in 0.6.7
3. https://github.com/timon/spreadsheet/commit/e5906f3b81a1da4c6f34c99d3eedcaa717269896
4. then Johan Lunds added this change ontop of that of Timon. Not released, to trivial.
5. https://github.com/johanlunds/spreadsheet/commit/165a08d36619793a6c835b6504e177b34a963fe7
6. and then there is this change from Clemens Park
7. https://github.com/nulogy/spreadsheet/commit/121eb6b415f65713b9dedf7004fd6dabeca4e5b9
8. Vitalys first patch: http://rubyforge.org/tracker/download.php/678/2679/29432/5312/url_zero_fix.patch named here released in 0.6.6
9. Vitalys second patch: http://rubyforge.org/tracker/download.php/678/2679/29431/5311/xls_colors.patch named here released in 0.6.6
10. All tests for the above changes will have to pass.

Patch by Moo Yo Spreadsheet 0.6.5.1 to 0.6.5.0

 Attach:Patch_Moo_Yu_Spreadsheet_0.6.5.1_0.6.5.0.txt

Issue reported on Rubyforge

 http://url.ba/7fbg

The same File will opens perfectly well in OpenOffice.

 http://rubyforge.org/tracker/download.php/678/2677/28007/4901/test.xls

testing code

 require 'rubygems'
 require 'spreadsheet'

 Spreadsheet.client_encoding = "GBK"

 book = Spreadsheet.open 'test.xls'
 sheet = book.worksheet 0
 sheet.each do |row|
	puts row[0]
 end