Bug 164382 - STANDARD FILTER: Filtering of decimal values won't work with "<", ">" and all other except "="
Summary: STANDARD FILTER: Filtering of decimal values won't work with "<", ">" and all...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency tree / graph
 
Reported: 2024-12-19 17:16 UTC by Robert Großkopf
Modified: 2024-12-20 06:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2024-12-19 17:16:34 UTC 
Download
https://bugs.documentfoundation.org/attachment.cgi?id=198179
Open the only table in this database.
Click "Standard Filter".
A dialog with 3 rows will appear.
Choose "Tax" and a condition, which is different to "=". 
Execute the filter.
Nothing has been filtered by the filter.
Open the filter again.
Condition has been lost.

It is only possible to set a filter for a decimal value by AutoFilter. This will filter all values, which are the same. Filtering by "=". But you can't get the same filtering by Standard Filter.

By the way: Filtering of Time and DateTime couldn't be filtered at all. This is already reported in bug 164381 for Autofilter.
Comment 1 Pit Zaclade 2024-12-19 18:48:47 UTC 
This problem is true!
In the referred database or in my own it is impossible to work with standard filter by decimal fields in tables (LO 24.2.7.2 (X86_64).
Comment 2 Robert Großkopf 2024-12-19 20:19:56 UTC 
Following comment1 I will set this one to new.