For what it's worth, the JavaScript one you were referring to is called Google Apps Script.
http://code.google.com/googleapps/appsscript/ -Vic On Mon, Aug 29, 2011 at 5:03 PM, Rodolphe G <[email protected]> wrote: > 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 >
