Google Script - Function to unmerge cells?

Question

I'm in the process of automating one of my weekly reports - however part of this process involves the merging of cells and unmerging - currently unmerging is done seperatly however im just wondering if such a method exists to find cells that are merged and unmerge them?

Many thanks.

Answer 1

My answer to this question will be "clear formatting" Option in Format menu.

Answer 2

GAS has a method to unmerge cells but unfortunately there is no way to know which cells are merged. Some users have suggested a few workarounds, the one I prefer is described in this post: Split (break apart) merged table cells in google spreadsheet with an apps script

There is also an enhancement request and interesting suggestions mentioned in this post: How do I know if spreadsheet cells are merged using google apps script