`worksheet[0]` and `worksheet.first` behave differently

[dunn]

Given this rows.rb:

require "spreadsheet"

book = (Spreadsheet.open "#{ENV["HOME"]}/test/spreadsheet/test.xls")

book.worksheets.each do |sheet|
  sheet.each do |row|
    row.each_with_index do |cell, i|
      next if cell.nil?
      puts "#{sheet[0, i]}: #{cell.inspect}"
      puts "#{sheet.first[i]}: #{cell.inspect}"
    end
  end
end

And the following test.xls

The expected output of bundle exec ruby rows.rb is

header: "header"
header: "header"
header: "celldata"
header: "celldata"

But the actual output is

: "header"
header: "header"
: "celldata"
header: "celldata"

[zdavatz]

What Ruby Version and what OS are you using? With what are you viewing the XLS file? Which software created the test.xls?

[dunn]

Ah, sorry.

• Mac OS 10.11.1
• Excel 2011 14.5.7
• ruby 2.2.3p173 (2015-08-18 revision 51636) [x86_64-darwin14]

[zdavatz]

Ok. Please try this with LibreOffice 5.0.x on Mac. Excel on Mac is not really supported.

[dunn]

Afraid to say I get the same result with LibreOffice 5.0.2.2.

[zdavatz]

Do you have a recommendation what there is to do as a solution?

[dunn]

Do you have a recommendation what there is to do as a solution?

I just assumed the solution would be to make them behave the same.

[zdavatz]

You mean Excel for Mac and Windows?

[dunn]

I mean for worksheet[0] and worksheet.first to do the same thing.

[zdavatz]

you want a new method for that?

[zdavatz]

I will send you an invite to Slack so we can continue our discussion there.

[dunn]

I'm not using this gem regularly anymore, so I'm not sure how much help I'll be.

[zdavatz]

ok!