hello and tia for any help,
while working with calc and ‘autofilter’ one can either define a ‘database-range’ and apply filters to that, or, if having a ‘top row’ with non empty cells, choose data - autofilter and calc will automatically create a - temporary? - range covering all connected cells up to full-empty columns left and right and full-empty rows below and above that range. right? for that range one can set autofilter or even standard and advanced filters, they are saved with the file and active on reload.
(it’s only possible to have one such range at a time, when applying autofilter to another range not defined as a database range the first ‘virtual’ one disappears. right?)
i’d like to know if it’s possible to ‘detect’ and use / manipulate this range and it’s criteria from a macro in a similar manner as one can do with ‘~databaseranges.getbyname(xx)’ and ‘~.getfilterfields’ and so on.
i’ve seen a ‘__Anonymous_Sheet_DB__0’ range defined in the ods file, but
… Databaseranges.getByName(__Anonymous_Sheet_DB__0) produced:
“BASIC runtime error.
An exception occurred
is evaluated but triggers ‘on error goto’, thus evaluates to error.
anybody here who knows a way to access that structure?
pls. don’t tell me ‘just define a range’ … i know i can do that, my target is to have macros which work on any filtered range even on files from other people where i don’t know about strutures and definitions, and always having to look manually ‘is this a defined range, or a “virtual”/temporary one?’ is … not very comfortable …