https://bugs.documentfoundation.org/show_bug.cgi?id=152658
Bug ID: 152658
Summary: Calc Autofilter "loses track" of entries when they are
changed, hiding them when the filter is examined
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This only occurs when the autofilter is configured to "hide" blank cells.
When an entry in an autofiltered table is amended, the new value is "inserted"
into the index BUT IS DESELECTED - the old value is removed.
If that filter has already been defined to hide empty/blank entries then merely
accessing and closing the filter dropdown will cause the new value to hide as
it is deselected.
Excel does not make the same mistake
I believe it's more severe than just a "normal" bug because it seriously
affects the integrity of subtotals.
Where a user may believe they have increased the column total by (x) they have
actually removed the entire value from the total.
Nice if you're calculating the fuel load on the next Mars missionš¤
Steps to Reproduce:
With the attached file:-
Observe the values of the subtotals on row 1
set the filter for column D to exclude empty cells and confirm
Observe the new row 1 subtotals for Columns E:G and that the rows with blank
cells in column D are hidden
Edit D4 to 75
Observe the impact on the subtotals
"open" the filter on column D
observe that 74 has disappeared and 75 is in the index but deselected
Imagine that value had been at row 3175 in the list
select OK - [Enter] to close the index
Now observe the Subtotals.
It gets better.
Undo the filter action with the ribbon control or [ctrl]+Z ensuring that 75 is
still visible but the empty cells in column D are hidden
activate the filter on Column G and exclude the empty cells
OK - [Enter]
Observe the impact and try to imagine the nightmare when adjustments have been
made on multiple columns - all set to exclude blanks
Actual Results:
Incorrect assessment of selected/deselected cells with catastrophic impact on
the subtotals
Expected Results:
Correct assessments and valid subtotals
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
