https://bugs.documentfoundation.org/show_bug.cgi?id=153057
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stephane.guillou@libreoffic | |e.org Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Blocks| |108440 --- Comment #3 from Stéphane Guillou (stragu) <[email protected]> --- Can confirm that in the spreadsheet, the standard filter can use an equality condition with "00:01:58" on column E (which contains numeric data formatted as time). Whereas in the database, the TITLES table has a Duration field of type TIME, formatted by default "HH:MM:SS", but the time range filter in the Filtered Titles form does not work as expected. After applying a time range filter, it can't be reset and the form shows the error: The data content could not be loaded. at /home/[...]/connectivity/source/commontools/dbtools.cxx:746 Incorrect type for setString at /home/[...]/connectivity/source/commontools/dbexception.cxx:462 Tested with: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d04c197b436094844abfa5fb7c12e095165d2bca CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108440 [Bug 108440] [META] Database form bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
