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).