Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

hi all,

got a solution in a german forum ...

the file attached contains a macro that does the job,

it has some difficulties with LO ver. 5.4.5 and 5.4.6.2, the filtering of date strings formatted as YY-MM-DD failed as well as numeric values formatted with trumps (leading zeroes), the problem should / shall / may result from a new 'engine' in LO since ver. 5.2.x ???

LO version 5.1.6.2 does work better, no problems with trumps, 8 byte date strings need a little tuneup, i wrote a line for that and can work for all dates formatted as YY-MM-DD in the period from 2000-01-01 till 2099-12-31.

the line is:

if isdate(content) then content = "20"&content

and needs to be inserted in the macro.

any hints and enhancements appreciated ...

thanks,

newbie-01

filter_dates_test.ods

hi all,

got a solution in a german forum ...

the file attached contains a macro that does the job,

the range of cells to be filtered must be defined as a 'database range'? under <data -="" define="" range="">,

it has some difficulties with LO ver. 5.4.5 and 5.4.6.2, the filtering of date strings formatted as YY-MM-DD failed as well as numeric values formatted with trumps (leading zeroes), the problem should / shall / may result from a new 'engine' in LO since ver. 5.2.x ???

LO version 5.1.6.2 does work better, no problems with trumps, 8 byte date strings need a little tuneup, i wrote a line for that and can work for all dates formatted as YY-MM-DD in the period from 2000-01-01 till 2099-12-31.

the line is:

if isdate(content) then content = "20"&content

and needs to be inserted in the macro.

any hints and enhancements appreciated ...

thanks,

newbie-01

filter_dates_test.ods