search

roo-rb / roo

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

expand_merged_ranges not work for ODS files #561

Open PsychoPhobic opened 3 years ago

PsychoPhobic commented 3 years ago

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