Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread
Message: 62816
BY: Samsonov Ivan (kronos)
DATE: 2008-12-05 12:35
SUBJECT: Strange behavior when I'm changing a cell

 

puts sheet.row(0).inspect
puts sheet.row(1)[1] = '123'
puts sheet.row(0).inspect
# in the console:
#<Spreadsheet::Excel::Row:0x00000000903df0 @formats=#<Spreadsheet::Format:0x1255de0>#<Spreadsheet::Format:0x1255de0> @worksheet=#<Spreadsheet::Excel::Worksheet:0x12417b4> ...
123
nil

Why row(0) became nil?
When I'm trying to save the document I got:
/Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/worksheet.rb:101:in `strings': private method `select' called for nil:NilClass (NoMethodError)
from /Library/Ruby/Site/1.8/rubygems/custom_require.rb:31:in `inject'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/worksheet.rb:98:in `call'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/worksheet.rb:98:in `each'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/worksheet.rb:97:in `upto'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/worksheet.rb:97:in `each'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/worksheet.rb:33:in `each'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/worksheet.rb:100:in `inject'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/excel/writer/worksheet.rb:100:in `strings'
... 8 levels...
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in `open'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/writer.rb:13:in `write'
from /Users/kronos/.gem/ruby/1.8/gems/spreadsheet-0.6.1.9/lib/spreadsheet/workbook.rb:107:in `write'
from script.rb:19


Thread View

Thread Author Date
Strange behavior when I'm changing a cellSamsonov Ivan2008-12-05 12:35
      RE: Strange behavior when I'm changing a cellSamsonov Ivan2008-12-05 12:38
            RE: Strange behavior when I'm changing a cellHannes Wyss2008-12-05 15:31
                  RE: Strange behavior when I'm changing a cellHannes Wyss2008-12-11 18:00

Post a followup to this message