lynnesmith1122
Aug 23, 2023Copper Contributor
Status:
New
Need Excel API to detect ANY merged cells in a range
We need a way to detect if there are any merged cells in a range before we insert content into them. Currently, there is no API that will do that. We need this support to provide an optimal experience for our users when inserting content.
I thought we could use getMergedAreasOrNullObject, but that only returns areas whose top left cell are in the range. I added a github issue that the developer marked as not a bug - https://github.com/OfficeDev/office-js/issues/3611 because they said that getMergedAreasOrNullObject is only supposed to return areas whose top left cell is in the range. The developer suggested I do a feature request.
No CommentsBe the first to comment