Can't Repro
Status Update
No update yet.
Comments
jp...@google.com
Generated Metadata
- Summary: The user reports that
getActiveCell()andgetSelection()in Apps Script always return cell A1, regardless of the actual active cell or selection. This is impacting their script's functionality and development time. - Tags:
Additional resources:
https://stackoverflow.com/questions/.../getactivecell-always-returns-1-1 https://stackoverflow.com/.../getting-the-row-and-column-of-active-cell-do... https://stackoverflow.com/questions/.../google-apps-getcurrentcell-not-work... https://stackoverflow.com/.../google-app-script-getactivesheet-returns-leftm... https://developers.google.com/apps-script/reference/spreadsheet/sheet
You can
bl...@google.com
Automated by Blunderbuss job workspace-devrel-public-issue-tracker-blunderbuss-autoassigner for config assign for component 191640.
Description
Before opening a new issue, please
+1to vote.Description
this is a simple line in a simple function dealing with a simple file yet it simply does not work. whether i use getActiveCell() or GetSelection() all that is retrieved is cell A1 period. I search the internet and your sight and all I get is the same BS. Here's the line with active cell: var currRangeTest = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Files To Load").getActiveCell();
Impact
Hours wasted, a need to rewrite the algorithm, and a fast growing lack of respect for google scripts.