255 rows limit in Excel

[bandlor]

I have repeating issue with loading of XLS files that were generated by some application (I do not have technical details) where exactly first 255 rows are red.
However when I open and save this file in the Excel, all lines all loaded properly.
This must be some race condition or unexpected error in the input file, but since I want to implement automated imports I'd like to resolve the issue.

I can not share the sample excel file (contains company data) but I can try to investigate and maybe provide a fix if some will point me in a good direction.
I will investigate anyway, but any help is appreciated :-)

Regards

[bandlor]

Sorry, cancel the alarms, this in not issue of Roo but Spreadsheet library.
For unknown reason the rows are red from the file, but dimensions variable is not calculated
and .each method (using those dimensions) in Worksheet class only return first 255 records to Roo.

As workaround I have forced the dimension calculation in Roo::Excel class by adding line 248 in "read_cells"

=    worksheet = @workbook.worksheet(sheet_no(sheet))
+    worksheet.dimensions
=   row_index=1

But this is not to be fixed in Roo so I will not post any patch for that.
I will try to post proper patch directly to Spreadsheet project later.

Regards