https://bugs.documentfoundation.org/show_bug.cgi?id=167587
Bug ID: 167587
Summary: CALC: Erratic Filter Behaviour when colour and date
Criteria are combined into a selection
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Filters permit selection by colour and/or date in the initial drop-down.
Date parameters are also available in the [Filter by Condition] "extention
pane".
When an attempt is made to combine these filters into a date/colour selection,
the date selection is lost, with ALL dates presented, but the indication pane
still identifies them as deselected. Observe the Greens only occur after 1/4/22
- the reference date.
There is a further problem where the integrity of the "table" and formula
references are damaged by the deletion [Ctrl] + [-] [Shift cells up] of the
three cells above the array header.
This action causes the loss of the conditional formatting, creating the
reference colours
Undo returns the status quo.
Steps to Reproduce:
Using the attached file: Table at E10
No Filters active, and 145 cells are presented - CORRECT
Filter by colour and select GREEN. 19 cells are presented - CORRECT
Filter by colour and select PINK. 126 cells are presented - CORRECT
Clear the filter so all cells are displayed
Filter by date >= 1/4/22 or 22-04-01. 47 cells are displayed - CORRECT
ADD filter by colour and select GREEN. 19 cells are displayed - CORRECT
NOTE There are no "GREENS" prior to 1/4/22
ADD (which is interpreted as change) by colour and select PINK. 126 cells are
displayed - NOT SURE THAT'S RIGHT - it's presenting ALL PINKS
Libre Office Calc identifies the correct math (and error) in D5:D6 ;)
Is it obvious from the existing feature definition that the actions defined in
G3:G10 - which became apparent when I tried to give myself more "Clear Space"
above the table - should occur as a direct result of whatever the error
condition may be, or is it unrelated and another feature report?
Actual Results:
Doesn't permit combination selection criteria
Expected Results:
Either results for the chosen combination of selection criteria or the
prohibition of multiple selection criteria if the feature doesn't really exist
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: sv-SE (en_SE); UI: en-GB
Calc: threaded
AND also exists in
Version: 7.5.9.2 (x86) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 12; OS: Windows 10.0 Build 26100; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
