Assigned
Status Update
Comments
dg...@gmail.com <dg...@gmail.com> #2
[Comment deleted]
dg...@gmail.com <dg...@gmail.com> #3
[Comment deleted]
gk...@google.com <gk...@google.com> #4
Thanks for reporting this issue. I've been able to reproduce it and have raised it internally.
ko...@gmail.com <ko...@gmail.com> #5
It was noted offline that this is also a problem for the methods:
.setBackground
.copyTo
.copyFormatsToRange
.setValidations
and other style-manipulating method.
.setBackground
.copyTo
.copyFormatsToRange
.setValidations
and other style-manipulating method.
ch...@exosphereapps.com <ch...@exosphereapps.com> #7
Note: Because there is no way to tell in GAS whether a row in data returned by .getDataRange() etc is visible to the user or not (see Issue 36752184 : Provide API to get the show/hide status of a row) then this 'bug' is actually very handy as by using the .copyTo method you can copy only those rows displayed to the user e.g. to another sheet
Please do not fix this 'bug' without also providing a way of telling if a row is displayed to the user or not :)
Please do not fix this 'bug' without also providing a way of telling if a row is displayed to the user or not :)
ak...@gmail.com <ak...@gmail.com> #8
Any news on this issue? I stumbled into this today noticing that .deleteRow() fails to work when the sheet is filtered.
mi...@gmail.com <mi...@gmail.com> #11
Agreed with exosphereapps...
It would be useful to be able to work on filter items, or not.
It would be useful to be able to work on filter items, or not.
ek...@google.com <ek...@google.com>
ek...@google.com <ek...@google.com>
am...@gmail.com <am...@gmail.com> #12
Any news about this? Would be great if this could be fixed.
Description
1) Create a data set in a spreadsheet and filter on one of the columns, concealing some rows in the sheet.
2) Use sheet.getRange and build a 2-D array of strings matching the range dimensions.
3) Use .setNotes(array) method to put the notes into the range.
What you will observe: Only the visible rows get the notes applied. Removing filter from sheet will show rows that were not visible during script operation do not have notes applied.
This spreadsheet will allow for replication: