Apache OpenOffice Community Forum

Is it possible to make a formula that steps through the sheets in it or another file without knowing each sheets name?

I know scripting can do it, but I was wondering if there was a way to define sheets by an number or something... So if I wanted to do a vlookup on say sheet number 3 and have the formula read the 3rd sheet in the file regardless of it's name.

Regretfully it doesn't appear to be possible, as there's no function (that I can find) that will return the name(s) of the sheets, without actually having to refer to the specific sheet name, or have some reference in each sheet that returns something that includes the sheet name.

ok thanks guys, I didn't think there was. I'll toss the idea up on the dev forums, maybe it will get added later.