https://bugs.documentfoundation.org/show_bug.cgi?id=157177
Bug ID: 157177
Summary: Calc Auto filter list hides filtered column when
opened and filter list formatting does not match
column formatting
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
AutoFilter pick list does not display column values as formatted and, when
open, hides the column it is used to filter.
Makes using AutoFilter with calculated columns difficult.
Please refer to attached marked up image for additional detail.
Steps to Reproduce:
1.Create a sheet with a calculated column
e.g.
Col A - quantity
Col B - price
Col C - price each = price / quantity, format US$
Row 1 - columns labels as above
Row 2 and subsequent - numbers in Col A and Col B, formula in Col C
2.Populate two or three rows with values in Col A & B and formula in Col C =
B/A
3.Format Col C as US$
4.Create AutoFilter for table
5. Open filter for Col C.
TWO ISSUES with the filter
#1 the filter list format does not match the column format. Numbers are
displayed as decimal and not displayed as US$
#2 the filter list opens over top of the column and hides the column content.
Actual Results:
per steps to reproduce
Expected Results:
expect column format to be preserved in filter list so desired values can be
identified and filtered.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
should have displayed the filter list with the same formatting as the column
AND
when US$ formatting makes different decimal values display the same, the
DISPLAY value should be shown only once in the filter AND selecting it should
filter EVERY value that displays per the selected filter format.
e.g.
row values in calculated column are 0.85, 0.849, 0.847
column formatting is US$
all values display as $0.85. It appears in each formatted row even though the
underlying values are different.
AutoFilter pick list should display $0.85 only once.
If $0.85 selected from pick list then display of all rows with display format
that matches should be operated on.
--
You are receiving this mail because:
You are the assignee for the bug.
