gilt/rubyXL — Issue #10: error parsing docs saved with open office
Author: hoguej
Created: 2011-12-18 02:47:45+00:00
State: open

I took a document made with MS Excel, that was saved as .xlsx

I opened in open office, then saved (as .xlsx).

I started getting this error:

1) Error:
test_get_file_header(TestSpreadsheet2Cloud):
TypeError: can't convert Symbol into Integer
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/cell.rb:32:in `[]'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/cell.rb:32:in `block in is_date?'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/cell.rb:32:in `select'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/cell.rb:32:in `is_date?'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/cell.rb:21:in `value'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/worksheet.rb:31:in `block (2 levels) in extr
act_data'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/worksheet.rb:31:in `map'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/worksheet.rb:31:in `block in extract_data'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/worksheet.rb:31:in `map'
/home/hoguej/.rvm/gems/ruby-1.9.2-p180/gems/rubyXL-1.1.12/lib/rubyXL/worksheet.rb:31:in `extract_data'
/home/hoguej/dev/Spreadsheet2Cloud/lib/spreadsheet_2_cloud.rb:25:in `headers'
test/unit/test_spreadsheet_2_cloud.rb:46:in `test_get_file_header'

If I skip the is_date? function, everything works fine.