My favorites | Sign in
Project Home Wiki Issues Source
New issue   Search
  Advanced search   Search tips   Subscriptions
Issue 5617: Search/find function
8 people starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----

Sign in to add a comment
Reported by, Jul 25, 2011
What new or enhanced feature are you proposing?
I think Google Apps Script should have some function that can search a given range for a string and return the cell or an array of cells that contain the string. It would look something like this. 

var sheet = SpreadsheetApp.getActiveSheet();
var cells = sheet.getRange("A1:C3").find("text to be found");

What goal would this enhancement help you achieve?
When I have a table sorted by one column on the left, it's not too hard to create a search function for that instance but when I want to search the entire spreadsheet for something, it's pretty much impossible or too slow. 
Sep 22, 2011
Sign in to add a comment

Powered by Google Project Hosting