Status Update
No update yet.
Comments
de...@jobhunt.co.il
There is not enough information here to be actionable. Please open a new issue with additional information.
tu...@gmail.com
You are right, the get range.getvalues it does, unfortunately sheet.deleteRow(cell.getRow()+i); does work differently which it makes it even more problematic.
At least is what I'm experiencing, please let me know if there is a way to delete a row when it is hidden
P.S. in the function cell is pointed to A2 and i is the offset of the row that I found I need to delete.
At least is what I'm experiencing, please let me know if there is a way to delete a row when it is hidden
P.S. in the function cell is pointed to A2 and i is the offset of the row that I found I need to delete.
de...@jobhunt.co.il
You can delete any row/column in GAS, but unfortunately you don't know if row/column visible/hidden.
Their is a feature request for long long time.
https://code.google.com/p/google-apps-script-issues/issues/detail?id=195
Their is a feature request for long long time.
Description
There is no way to check if any filter is active so the script is going to run and it will process the data as is which it can be a problem. Plus there is no way to avoid a user that has access to the sheet uses a filter.