Created attachment 186391 [details] It shows all states in country In LibreOffice Calc, The Currency Icon displays All the States in a country with their native language. It supposed to display country with currency symbol. No need to show the states as the money values are remain same all over the country.
-Verified that the Currency icon does display the native language and the currency symbol next to it -Scrolling down the Currency icon list also displays separate currencies without the icons. Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5e193d854596db714ca786c2a676b5ac9684d5eb CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Thank you for reporting the bug. I can confirm that the bug is present in Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
That is because the formats may differ and the locale (language+country+...) is encoded in the generated number format code. E.g. EUR € Dutch (Netherlands) [$€-413] #,##0.00;[RED][$€-413] #,##0.00- EUR € German (Austria) [$€-C07] #,##0.00;[RED]-[$€-C07] #,##0.00 EUR € German (Germany) #,##0.00 [$€-407];[RED]-#,##0.00 [$€-407] EUR € Irish [$€-83C]#,##0.00;[RED]-[$€-83C]#,##0.00 You see that the position of the currency symbol is different, the position of the minus hyphen is different, whether blanks or not are used is different.. So, not a bug. But yes, this is a tad confusing, and the differences are only visible in the full number formatter dialog with its format code and preview.