test merged cells

[phonixor]

• what happens currently?
• what should happen?

[chainsawriot]

Tested. A merged cell can jam the parsing and produce incorrect data.

http://postimg.org/image/5tsbqyb8t/

Need to look into that or notes it in the documentation.

[py-b]

Hello,
Would be nice if that feature is implemented.
So, what should happen? Top-left cell takes the value of the merged cell, others remain empty?

[DataStrategist]

Something especially evil happens with merged cells + mult-row headers + skip rows, it seems to shift column headings over. Take a look at:

file_to_get <- "https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1039305/Main_Tables_Q2_2021_22.ods"
download.file(file_to_get, destfile = "oh_no.ODS")
names(readODS::read_ods("oh_no.ODS", sheet = "S_1", skip = 3))

It seems like the third column is "Immigration and Asylum", which isn't the case. I feel there should at least be a visible warning specifying that there MIGHT be a problem.