Hello Vic, Sorry, I really meant the javascript one can program to modify spreadsheets (not sure what the technical term is).
Thank you for your answer, I'm a little disappointed there is no straightforward way to do "tell" the script to only consider displayed data after applying a filtre, but I'll get over it! Cheers! :D On 29 août, 12:28, Vic Fryzel <[email protected]> wrote: > Hey Rodolphe, > > Can you clarify, are you using Google Apps Script, or the Google > Spreadsheets API? > > Regardless, normally both mechanisms give all rows from a sheet, not just > the filtered ones. Thus, you'd have to "reimplement" your filters in your > script. > > Thanks, > -Vic > > > > > > > > On Thu, Aug 25, 2011 at 3:05 PM, Rodolphe G <[email protected]> wrote: > > Hello all! > > > I'm starting to use and really enjoy writing little scripts for google > > spreadsheet. > > > I'm having a problem these days days though: > > > 1) I wrote a script that takes the content of a worksheet and > > manipulates data > > 2) Now I turned on "filters" for my worksheet and start filtering > > columns > > 3) This is great > > > Problem: I'd like my script to take into account ONLY the remaining > > data (leaving out everything that has been filtered). Is that even > > possible? > > > Thanks! > > > Rodolphe
