https://bugs.documentfoundation.org/show_bug.cgi?id=145499
Bug ID: 145499
Summary: CALC AUTOFILTER Numerical values duplicated in the
drop down pane
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Some numerical values are being presented in duplicate when the autofilter is
activated.
If everything apart from one of the duplicated values is deselected - keeping
both the duplicates selected - then all the resultant cells contain identical
data.
I have even expanded the column width and formatted the maximum decimal places
and it is NOT the notorious anomaly where some numbers have the final digit
defined as 1 ie. 2,000000000000001 = 2
If the autofilter pane is activated when the selection has been defined as just
the duplicated entry then the display still presents two versions of the same
number but only one is activated.
Steps to Reproduce:
Utilising the attached file, autofilter on column K
Observe that some of the numbers are duplicated
Clear all and then select both entries for the value 73,6 or any other obvious
duplicate
OK
Examine all the values to satisfy yourself they are indeed identical
Activate the filter again and observe that the chosen value is duplicated but
only one version is activated
Actual Results:
Duplicated values in the selection list
Expected Results:
No duplicated values
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 19042; 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.
