https://bugs.documentfoundation.org/show_bug.cgi?id=172646
--- Comment #7 from Anders Lind <[email protected]> --- Thanks for the clarification! I checked Insert -> Special Character again. With the default "Liberation Sans" font the emojis are indeed not available, as you observed. However, if I select Noto Color Emoji as the font, searching for terms such as "palm", "crown" or "banknote" finds 🌴, 👑 and 💶 respectively, and they can be inserted into the sheet. Since the characters display correctly in Calc, UNICODE()/UNICHAR() work correctly, and SUMIF("🌴*") also works, it seems to me that the regression is limited to wildcard matching when the wildcard precedes these characters (for example *🌴 and *🌴*). -- You are receiving this mail because: You are the assignee for the bug.
