Created attachment 52401 [details] Output after data detective has finished validating. Enter data in a spreadsheet in range A1:A4 10:59:00 PM 11:59:00 PM 12:01:00 AM 01:00:00 AM Select range A1:A4 Data->Validity Allow: Time between Minimum: 11:58:00 PM Maximum: 12:02:00 AM Tools->Detective-Mark Invalid Data 11:59:00 PM and 12:01:00 AM are marked invalid. 10:59:00 PM and 01:00:00 AM are regarded as valid. This is the reverse of the true situation.
Ok, I think I know why that happens. We need to take care of Between and Not Between with time and dates in a different way than we do now. We translate the date to a double value and sort them after that and look if that value is between these two. Since 11:59 PM is bigger than 12:01 AM we inverse our valid range. I think about a clean way to fix that.
some code pointers: http://opengrok.libreoffice.org/xref/core/sc/source/core/data/validat.cxx#468 http://opengrok.libreoffice.org/xref/core/sc/source/core/data/conditio.cxx#IsValid
Markus: I'm freeing this bug. Just re-assign if you still plan on working on this.
Back to NEW as this bug lost owner.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.