Wrong cell retrieved in ods if subtotals are used
estani opened this issue · 0 comments
estani commented
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