Yes, now you can use isPartOfMerge
to check.
And for anyone wants to get the value of merged cell:
var value = (cell.isPartOfMerge() ? cell.getMergedRanges()[0].getCell(1,1) : cell).getValue();
Hope it help.
More Related Contents:
- Refresh data retrieved by a custom function in Google Sheet
- How do you create a “reverse pivot” in Google Sheets?
- How to protect the Apps Script code in a Google spreadsheet?
- Create Google Calendar Events from Spreadsheet but prevent duplicates
- ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
- Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
- Retrieving Google Sheets cell border style programmatically
- Determining the last row in a single column
- Cannot find method getRange(number,number)?
- How do I add formulas to Google Sheets using Google Apps Script?
- Deleting rows in google sheets using Google Apps Script
- Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
- Single Google Form for multiple Sheets [duplicate]
- Adding Buttons To Google Sheets and Set value to Cells on clicking
- Custom function throws a “You do not have the permission required to setValue” error
- Margins parameters for Google spreadsheet export as PDF
- Google Apps Script: Dynamically creating spreadsheet menu items
- Script to convert .XLSX to Google Sheet and move converted file
- Hidden field in a Google Form
- onEdit() doesn’t catch all changes
- Apply multiple font colors to the text in a single Google Sheets cell
- Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
- Use script in all spreadsheets
- Iterate over range, append string to each
- Can the google spreadsheet ‘query’ function be used in google apps script?
- How to pause App Scripts until spreadsheet finishes calculation
- Custom Functions and Recalculation
- How to create INDIRECT array string of multiple sheet references in Google Sheets?
- Can the google spreadsheet ‘query’ function be used in google apps script?
- google script openById : You do not have permission to perform that action