roo-rb/roo

Wrong cell retrieved in ods if subtotals are used

estani opened this issue · 0 comments

If subtotals are used:
image
image

The cells are just skipped

doc = Roo::Spreadsheet.open('test.ods');
doc.sheet(0).a5         # "a10"
doc.sheet(0).cell(5,1)  # "a10"
doc.sheet(0).a10        # nil
doc.sheet(0).column(1)  # ["a1", 1, 3, nil, "a10"]

And it doesn't matter if they are hidden or not.
test.ods.zip