[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-03 UTC."],[[["\u003cp\u003e\u003ccode\u003eDeveloperMetadataLocation\u003c/code\u003e provides access to information about the location of developer metadata within a spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eIt offers methods to retrieve the location type, which can be a spreadsheet, sheet, row, or column.\u003c/p\u003e\n"],["\u003cp\u003eYou can get the specific Spreadsheet, Sheet, or Range associated with the metadata, depending on its location type.\u003c/p\u003e\n"],["\u003cp\u003eAll methods require authorization with either \u003ccode\u003ehttps://www.googleapis.com/auth/spreadsheets.currentonly\u003c/code\u003e or \u003ccode\u003ehttps://www.googleapis.com/auth/spreadsheets\u003c/code\u003e scopes.\u003c/p\u003e\n"]]],[],null,["DeveloperMetadataLocation\n\nAccess developer metadata location information. \n\nMethods\n\n| Method | Return type | Brief description |\n|-----------------------------------------|------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| [getColumn()](#getColumn()) | [Range](/apps-script/reference/spreadsheet/range) | Returns the [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.COLUMN`. |\n| [getLocationType()](#getLocationType()) | [DeveloperMetadataLocationType](/apps-script/reference/spreadsheet/developer-metadata-location-type) | Gets the type of location. |\n| [getRow()](#getRow()) | [Range](/apps-script/reference/spreadsheet/range) | Returns the [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.ROW`. |\n| [getSheet()](#getSheet()) | [Sheet](/apps-script/reference/spreadsheet/sheet) | Returns the [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.SHEET`. |\n| [getSpreadsheet()](#getSpreadsheet()) | [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) | Returns the [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location type is not `Developer``Metadata``Location``Type.SPREADSHEET`. |\n\nDetailed documentation \n\n`get``Column()` \nReturns the [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.COLUMN`.\n\nReturn\n\n\n[Range](/apps-script/reference/spreadsheet/range) --- The [Range](/apps-script/reference/spreadsheet/range) for the column location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.COLUMN`.\n\nAuthorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n`get``Location``Type()` \nGets the type of location.\n\nReturn\n\n\n[DeveloperMetadataLocationType](/apps-script/reference/spreadsheet/developer-metadata-location-type) --- The location type.\n\nAuthorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n`get``Row()` \nReturns the [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.ROW`.\n\nReturn\n\n\n[Range](/apps-script/reference/spreadsheet/range) --- The [Range](/apps-script/reference/spreadsheet/range) for the row location of this metadata, or `null` if the\nlocation type is not `Developer``Metadata``Location``Type.ROW`.\n\nAuthorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n`get``Sheet()` \nReturns the [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is\nnot `Developer``Metadata``Location``Type.SHEET`.\n\nReturn\n\n\n[Sheet](/apps-script/reference/spreadsheet/sheet) --- The [Sheet](/apps-script/reference/spreadsheet/sheet) location of this metadata, or `null` if the location type is\nnot `Developer``Metadata``Location``Type.SHEET`.\n\nAuthorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`\n\n*** ** * ** ***\n\n`get``Spreadsheet()` \nReturns the [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location\ntype is not `Developer``Metadata``Location``Type.SPREADSHEET`.\n\nReturn\n\n\n[Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) --- The [Spreadsheet](/apps-script/reference/spreadsheet/spreadsheet) location of this metadata, or `null` if the location\ntype is not `Developer``Metadata``Location``Type.SPREADSHEET`.\n\nAuthorization\n\nScripts that use this method require authorization with one or more of the following [scopes](/apps-script/concepts/scopes#setting_explicit_scopes):\n\n- `https://www.googleapis.com/auth/spreadsheets.currentonly`\n- `https://www.googleapis.com/auth/spreadsheets`"]]
