Value of a range consisting of several cells

[Thomas008]

The Value method of a range containing multiple cells causes an ArrayIndexOutOfBoundsException.

For example:

excel = WIN32OLE.new("Excel.Application")
workbook = excel.Workbooks.Open(File.expand_path("workbook.xls")
worksheet = workbook.Worksheets.Item(1)
range = worksheet.Range(worksheet.Cells(1,1), worksheet.Cells(3,4))
range.Value
=> ArrayIndexOutOfBoundsException

[Thomas008]

I have published this issue in the jruby github already, since I did not know where the best place might be
(issue 5755).