I have a very simple sheet – 10 columns by 80 rows, no hidden rows/columns.
I have a simple filter over the entire spreadsheet allowing me to sort on any column.
Once sorted, the row # shown in my filtered view is of course not the same as the unfiltered row #.
The data shown in each cell in the filtered view is from the unfiltered view as it should be.
So somewhere there is a mapping of my filtered rows to the unfiltered rows.
Let’s say row 15 in the filter/sorted view is mapped to row 21 in the unfiltered view.
I have an onSelectionChange script that gets invoke when I select a cell on the filter/sorted view.
Let’s say I select E15 (ie column 5, row 15).
Using getActiveCell() it shows row 15 and column 5. That’s correct.
Using getValue(), it returns the value in the unfiltered view from row 15, not the unfiltered mapped row 21.
The value I see in my script from getValue() does not match the value seen in the filtered/sorted spreadsheet.
How can I retrieve the value from the mapped cloud row?
In sheets apps script, unable to fetch correct cell contents in filtered view
60 Views Asked by Steve Palmer At
0
There are 0 best solutions below
Related Questions in GOOGLE-APPS-SCRIPT
- How to use custom font during html to pdf conversion?
- parameter values only being sent to certain columns in google sheet?
- AppScript to replace image in google slides
- Email Sent Using AppScript Appears in Sent Box, but does not appear in Recipient's Inbox
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Would like the script to return the PDF letter via email with the sheet name not the spreadsheet name
- App script to prevent duplicate form submission
- Redirect Users to another website using GAS
- How do I create a Line Graph on App Script?
- Error (Status of 500) and X-Frame-Options with google apps script redirect function
- How do I add the Luxon library google sheet script
- AppScript For Google Form
- google sheet script to convert the Scientific notation in the selected area to number
- onEdit() 'row is not defined' error using checkboxes
- Regex expression not working on Google Form
Related Questions in GOOGLE-SHEETS
- google sheets, search and replace for next colum
- AppScript to replace image in google slides
- Regex to match repeated substring in Google Sheets
- How to append row to specific columns with gspread?
- Find a value in a range of cells (multiple rows and columns)
- Create date column based on range
- Look up a value using month of the date
- Data recovery based on other data
- Gsheet - Automatically send an email using a date & time in a Cell
- google sheet script to convert the Scientific notation in the selected area to number
- How can I limit the number of dropdown entries in a column in Google Sheets
- Parse tag in html via Google Sheets (importxml)
- Why is the background color of my google sheet web app not being applied?
- Google Sheets script that automatically locks a sheet 24 hours after a cell is edited
- My Google Sheets formulas mysteriously break as time passes, fix themselves when refreshed
Related Questions in FILTER
- Producing filtered random samples which can be replicated using the same seed
- Using uBlock to hide a parent element that includes a child element that contains a specific string
- How change product price in cart on woocommerce?
- How to use extracted path params in filters in warp / rust?
- Cpanel filter encoding utf-8?
- Google sheets formula based upon a unique identifier and a date match (in between two dates)
- Copy the result of a filter from 2nd line
- Filtering posts within a page that displays a single category php
- How do I add tags to HTML web pages and sort them with a filter?
- Loader / Spinner infinite | Filter Everything Pro
- Nextflow filter entire tuple based on one value
- Filter a CSV file that has text above column names that must be maintained after the filter process
- Filtering dataset with multiple conditions for monotherapy
- Autocomplete search filter not working for dynamically added input fields in angular
- How to type filtered list?
Related Questions in GETVALUE
- 1) Loop through array of sheet/file IDs 2) Use DriveApp to getLastUpdated for each file 3) setValues in adjacent column
- Get attribute value and set as variable
- I need to receive email if any cell in column H =1 with subject include the data from A,B and h. From the same raw
- get_value() method is not returning value of the node,the type of the node is ExtensionObject
- How to get Value by Id from List in another Class
- unable to dynamically set a value in react-hook-form
- Trying to conditional format Google sheet that uses a Google form for data entry
- Script not getting the actual value of a cell with App Script in Google Sheets
- In sheets apps script, unable to fetch correct cell contents in filtered view
- Use of Enum.GetValues give me a compilation error
- how to get column name if that column has value for each row in excel
- How to get innerText of child div
- Hy i want to get value in the base of onclick dropdown and show in input using jquery
- Retrieving the Nth value of a given column in a table
- how to get value from a range with last row and set value last row in different sheet?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?