Bugs: Browse | Submit New | Admin

[#29086] write_workbook triggers 'can't convert nil into Integer' worksheet.rb:write_cell

Date:
2011-03-15 20:09
Priority:
3
Submitted By:
Kevin Lin (wild0kl)
Assigned To:
Nobody (None)
Category:
biffwriter
State:
Open
Summary:
write_workbook triggers 'can't convert nil into Integer' worksheet.rb:write_cell

Detailed description
Hello, I have a very basic program that creates a new workbook, sheets, and fills in cells in those sheets. The program
works normally for some input data, but gives this error for others. I am trying to track down more details ATM.

/usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:182:in `pack': can't convert
nil into Integer (TypeError)
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:182:in `write_cell'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:618:in
`write_labelsst'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:222:in `block
in write_cellblocks'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:197:in `each'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:197:in
`each_with_index'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:197:in
`write_cellblocks'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:780:in `block
in write_rowblock'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:779:in `each'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:779:in
`write_rowblock'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:785:in `block
in write_rows'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:784:in `each'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:784:in `write_rows'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/worksheet.rb:486:in
`write_from_scratch'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/workbook.rb:444:in `block
in write_from_scratch'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/workbook.rb:444:in `each'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/workbook.rb:444:in
`write_from_scratch'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/excel/writer/workbook.rb:620:in
`write_workbook'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/writer.rb:15:in `block in write'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/writer.rb:14:in `open'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/writer.rb:14:in `write'
	from /usr/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.2/lib/spreadsheet/workbook.rb:106:in `write'
	from ./spreadsheet_renderer.rb:142:in `write_workbook'

Add A Comment: Notepad

Please login


Followup

Message
Date: 2011-08-04 11:43
Sender: Zeno R.R. Davatz

Please report any further issues to:

http://groups.google.com/group/rubyspreadsheet

with your sample file and sample code posted on github and linked
to above mailing list.

Best
Zeno

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

No Changes Have Been Made to This Item