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.
Created attachment 189479 [details] Illustrated labeled image of problem
Hi Alan, Thank for your report. As you mentioned it, you have different issues, the best is to provide one bug report by issue to help contributors to answer. I suggest you provide an ods file with autofilter use case and two others bug reports about point 2 and 3. Regards, Régis
(In reply to Alan from comment #0) > #1 the filter list format does not match the column format. Numbers are > displayed as decimal and not displayed as US$ This issue is fixed in recent versions, please update to either 7.5 or 7.6. > #2 the filter list opens over top of the column and hides the column content. This is a good point. I could not find this request elsewhere, so let's focus this report on that. I can reproduce the issue in a recent master build as well as OOo 3.3, so the issue is inherited. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded