Summary: | Calc and Base can not filter time values | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Andreas Säger <villeroy> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | balazs.varga991, iplaw67, kelemeng, stephane.guillou, zcrhonek |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 7.2.0.0 alpha1+ | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=142402 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | Balazs Varga | |
Bug Depends on: | |||
Bug Blocks: | 108440, 109326 | ||
Attachments: |
database document with 2 forms
Spreadsheet with list range |
Description
Andreas Säger
2023-01-17 06:55:39 UTC
Created attachment 184702 [details]
database document with 2 forms
Test the form/subform filtering and the built-in filters. Everything works properly unless you filter by time values in "Duration".
Created attachment 184703 [details]
Spreadsheet with list range
menu:Data>filter>Standard filter...
Works with a selected time
Fails with entered time or with operator other than =
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 Confirming on macOS with both the spreadsheet and the database form Version: 7.4.4.2 / LibreOffice Community Build ID: 85569322deea74ec9134968a29af2df5663baa21 CPU threads: 8; OS: Mac OS X 13.0.1; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded This seems to work correctly in Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Despite not having saved any changes to the database or the form, once that error message is displayed, there seems to be no way of recovering the original behaviour. I systematically get the setString error message (on macOS) on opening even in a different version of LO. bisected to 5bee333e16cc9879991346f7d6ee49e0b9b11315 is the first bad commit commit 5bee333e16cc9879991346f7d6ee49e0b9b11315 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Tue Jun 15 19:25:40 2021 -0700 source 1f755525189884e4b2824889a6b9dea8933402db https://gerrit.libreoffice.org/c/core/+/116115 CC to Balazs Varga The filter field of a valid filter looks like: IsNumeric boolean True NumericValue double 0.0013310185185185187 StringValue string 00:01:55 FilterType long 0 ColorValue long 0 The failing filters have NumericValue 0.0. |