Flag Emojis in Calc appearing as letters (🇳🇴 -> NO)

[nr2014]

I’m trying to use a variety of flag emojis to represent various countries - this works fine on other programs outside of the LibreOffice domain, but for whatever reason they’re not showing up as flags as I would expect. Some appear as the black flag emoji (󠁧󠁢󠁥󠁮󠁧) while others are merely the letters of the country (NO, for example.) I’ve spent the last hour and a half scouring the internet in attempt to figure this problem out for myself, but I have no progress to report.

How can I get flag emoji’s to appear in my spreadsheet?

[Wanderer]

@nr2014

How can I get flag emoji’s to appear in my spreadsheet?

Use proper unicode-points, and a Font, wich contains them:
https://www.alt-codes.net/flags

You can create auto-correct entries to replace :NO with a flag.

[ajlittoz]

The “letters” for the ISO-3166-1 alpha 2 country codes start at U+1F1E6 (for “A”). The hexa encoding for any “letter” is thus 1F1E5+<rank_of_letter> where the rank is 1 for A, 26 for Z.

Therefore the Norwegian flag will appear after the sequence U+1F1F3 AltX U+1F1F4 AltX. I have grouped in the same cartouche keys which must be pressed simultaneously.

A summary of the combinations is also available here

[EarnestAl]

You might find a partial explanation here on EmojiOneColor page in github, Project End of Life | emojione-color-font

If you are in Windows 11 then clicking Win+. (Windows key + full stop) will open the Windows Emoji toolbar. No flags are shown in Segoe UI Emoji however