Description: A column of special characters, e.g. Wingdings, shows as all blank in the pick list. Steps to Reproduce: 1. Enter special characters in a column 2. Enable auto filter on the column 3. Activate pick list Actual Results: Selections are all blank Expected Results: Items should be shown Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded {{Ya otts to update the Open GL checking page as the graphic don't match the current Open GL exe}}
No repro with € ∞ π symbols in Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d140817428cdbb519efa496f578bf6c054c94361 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL Please attach your file with the problem
Created attachment 177967 [details] list of spileberg films
(In reply to Ian Eales from comment #2) > Created attachment 177967 [details] > list of spileberg films Still no repro. In which column with autofilter do you have the problem in your file?
I select the filled area C3:G40, hit AutoFilter and then try to filter on Rating.
Created attachment 177970 [details] AutoFilter blank selection
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Ian Eales from comment #4) > I select the filled area C3:G40, hit AutoFilter and then try to filter on > Rating. I see items in Autofilter window in 7.2 and in 7.4. But it isn't the same symbols (and it's another problem) Try reset your user profile using Safe mode dialog (menu Help->Restart in Safe mode) and then try retest your problem
(In reply to Roman Kuznetsov from comment #7) > (In reply to Ian Eales from comment #4) > > I select the filled area C3:G40, hit AutoFilter and then try to filter on > > Rating. > > I see items in Autofilter window in 7.2 and in 7.4. But it isn't the same > symbols (and it's another problem) > > Try reset your user profile using Safe mode dialog (menu Help->Restart in > Safe mode) and then try retest your problem Makes no difference in Safe Mode
Not reproducible in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 49746f40b06eaf1f61bb54454408a06a49d73c5e CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: x11 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
The list is not blank for me. Ian: is the list still blank for you in 7.4? Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9b46020c262045aed0beace4708565235c2523cc CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded Jumbo Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fa5cc6c6e7ce89d6d9972d8ad2f9469b9bd5bf9a CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 13 December 2022 Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Created attachment 184137 [details] image of filter auto filter blank from smiley symbol font characters
Wingdings is a notoriously bad font choice as it does not map to Unicode. I'd recommend using another font that includes smileys / emojis, and then AutofFlter lists should display the characters (even if it's a slightly different font). I reproduced the different black characters in 7.4.7.2, 7.5.8.2, 7.6.3.1 and a recent trunk build, as in comment 7. But that's just the characters you get when changing the font from Windings to whatever font the UI uses. Could using a different font and the following widely-supported characters be a good enough workaround for you? U+1F642 🙂 U+1F610 😐 U+1F641 🙁
The problem with the other fonts is do not display as well in the workbook. 🙂 This pasted from the email sent and shows "Liberation Mono;Courier New;DejaVu Sans Mono" as the fonts in the font box Inserting from Insert Characters and needing scroll through all the available fonts and characters to find something usable is a non-starter. Searching Help I did not find how to insert U+XXXX codes I was able to copy and paste an emoji from TBird. It shows in the Pick list Functional, but inelegant. Only some are pasteable Only a single character can be pasted 'in cell'. Sequential characters can be pasted in the formula bar Once all the above hoops are jumped, Standard filter works a treat
I was unable to reproduce this same behavior in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded or Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 193676 [details] Characters In a different workbook on Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 193677 [details] Auto Filter filter of the Characters