roo-rb/roo

expand_merged_ranges not work for ODS files

PsychoPhobic opened this issue · 0 comments

Steps to reproduce

expand_merged_ranges does not work in this code:

- file = File.join(Rails.root, 'db', 'Delta_motors.ods')
- ods = Roo::OpenOffice.new(file, {:expand_merged_ranges => true})
- sheet = ods.sheet('Tabelle1')
- motors = sheet.parse(motor_model_name: 'Motor Model Name')

Issue

expand_merged_ranges does not work like in tutorial:

If you open a document with merged cells and do not want to end up with nil values for the rows after the first one.
xlsx = Roo::Excelx.new('./roo_error.xlsx', {:expand_merged_ranges => true})

System configuration

ruby version : 3.0.1
rails version : 6.1.4
roo version : 2.8.3