search

roo-rb / roo

Roo provides an interface to spreadsheets of several sorts.
MIT License
2.8k stars 502 forks source link

Wrong cell retrieved in ods if subtotals are used #538

Open estani opened 4 years ago

estani commented 4 years ago

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