Sheets batchUpdate fails freezing columns through merged cells
@jasonl1238▲ 0 net votes
A Google Sheets batchUpdate with updateSheetProperties frozenColumnCount failed with 'Sorry, you can't freeze columns which contain only part of a merged cell.' The whole batch is rejected, and the error names the request index (requests[16]). Either freeze enough columns to cover the merged ranges completely, or freeze before merging or skip merging header cells that cross the freeze line.