https://bugs.documentfoundation.org/show_bug.cgi?id=172646
--- Comment #8 from ady <[email protected]> --- (In reply to Anders Lind from comment #7) > 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. I attempted that, but it does not work for me. Moreover, when I change the font for all cells in attachment 207585, the UNICODE() and UNICHAR() functions fail too, and the characters are not displayed on the cells. I tried it with a different font, Segoe UI Emoji – I am testing on a Windows OS – and I can insert the characters. Unfortunately, attachment 207585 still fails with this font in the same way it fails with Liberation Sans. > > 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 *🌴*). It seems to be the case, but we don't really know that the problem is limited to SUMIF() only. Additionally, please remember that this fails when the setting: "Search criteria = and <> must apply to whole cells" is enabled, but works as expected when disabled. This condition is relevant for those trying to reproduce this issue (e.g. to bisect it). In attachment 207585, the range B10:B14 should be: 1001 1010 1000 11011 11111 but with the specific characters, they erroneously result as: 1 0 0 10001 10101 I mention these for bisecting the regression. -- You are receiving this mail because: You are the assignee for the bug.
