title: Split (break apart) merged table cells in google spreadsheet with an apps script
body: <p>When operating (copying/moving) ranges containing merged cells, I always get the error “Your paste overlaps with merged cells. Please unmerge the cells and try again”. But when trying to unmerge the cells in the range using <code>Range#breakApart</code>, I get another error: “The selected cells cannot be merged.”, which is even more confusing since I’m not trying to merge anything, I’m only trying to break the cells apart.</p>