Duncan Garmonsway

Thanks for the suggestion. ## Notes to self Docs are in ECMA part I, from page 1819. Each worksheet has a file in `xl/worksheets/_rels`, e.g. `xl/worksheets/_rels/sheet1.xml.rels`. This points to any...

That's correct, and is the reason why I haven't thought of a need for this yet. It might still be useful to know when a cell is part of a...

@ianmoran11 thanks for commenting here. I've skimmed https://github.com/ianmoran11/tidyABS/commit/d34fd3f3f0aeed052df74f6e28529ed2890b0a50 to try to understand the use of unmerging cells, but I don't understand yet. Is it part of guessing which cells are...

I see. Could tidyABS use NNW every time? N is a convenient way to filter out cells that are outside the table (they don't have any headers), but otherwise it...

Excellent example. I'm persuaded. I had a go at this last night and it's just fiddly, not actually difficult.

Thanks @bedantaguru and @dmcalli2 for the suggestions. What do you think about: * not having an `is_merged` column, and * having both `merged_cell_sheet` and `merged_cell_address` columns to store the full...

Oh yes, I meant to ask what value you would expect merged cells to have (other than the top-left). I had assumed they ought to be pre-populated with the value...

@bedantaguru you are right, `merged_cell_sheet` is not necessary. @dmcalli2 and @rpsoft thank you for offering to help with the implementation, which will be as follows (suggestions still accepted though!): 1....

Hi @awdursun, thanks for explaining how you would use this feature. I haven't implemented conditional formatting before, because it is based on cell values, so I thought it would be...

I see, there isn't really a rule for the conditional formatting, so you need to be able to read conditional formatting back into tidyxl. From a quick read of the...