Suggest a feature: keep contents of hidden cells when merging cells

Docs
1

Would like to suggest to add an option for keeping the contents of hidden cells when merging cells. See the attached screenshot for how Libre does this:

merging-cells-in-libre
merging-cells-in-libre745×411 26.6 KB

This is helpful when people filter vertically merged cells, in which case . For the background, please refer to How to Filter Merged Cells in Excel (Easiest Way in 2024) - Spreadsheet Panda.

Thank you.

3

Hello @yangjianhui
It sounds interesting. We need some time to check it out.
I will update this thread once we have something to share.

4

Okay. Thanks.

5

Hello @yangjianhui
We have added your suggestion to internal tracksystem. We have started working on it.
We will update this thread once we have something to share.

7

Thanks you, Alex. @Alexandre

1 Like