Custom oNumberFormats is now using , as decimal separator when it didn't before [FIXED]

[Toby1]

Every month I export my transactions from my Dutch bank as an xls sheet.
When I load this xls sheet into LibreOffice, the amounts are displayed as “220.90”
I wrote a macro to change the format to “€ 220.90”, using this code:

	oLocalSettings.language = "uk"
	oLocalSettings.country = "uk"
	oNumberFormats = thiscomponent.numberFormats
	lKey = oNumberFormats.queryKey("[$€-413] #,##0.00;[RED]- [$€-413] #,##0.00", oLocalSettings , true)
	If lKey = -1 then 
		lKey = oNumberFormats.addNew("[$€-413] #,##0.00;[RED]- [$€-413] #,##0.00", oLocalSettings)
	endif
...
	oSheet.getCellByPosition(3,i).NumberFormat = lKey
	oSheet.getCellByPosition(3,i).HoriJustify = "3"

It used to work, but after my profile got reset, and I upgraded to 7.4.4.2, it doesn’t work any longer.
Now it displays the values as “€ 220,900.00”.
Obviously it’s getting confused because in Holland “,” is the decimal separator and “.” is the thousands separator, but the original value is using . as the decimal separator, and my locale settings are set to UK:

Locale setting is “Default - English (UK)”
Default currency is “Default - GBP”
Decimal separator key is ticked same as locale setting (.)

I’m not sure if something’s changed in my profile, or in LO.
Can anybody help please?

(by the way if I replace “[$€-413]” with “x” it still changes the format to 220,900.00)
(and manually formatting the data as Euros does not change the format)

[Toby1]

I have found that if I remove

oLocalSettings.language = "uk"
oLocalSettings.country = "uk"

It works. So either that was always wrong, and I was lucky it worked at all, or something’s changed.

[Zizi64]

Please upload a prepared ODF type sample file with the embedded macro code

[Lupp]

“uk” never was a valid language designator for English. That’s “en”. In fact “uk” means Ukrainian when used for a language.
For the United Kingdom of… as the country “GB” should work.

BTW:
Avoid “Thousands Separators” generally. They have a high potential of messing up things as soon as “formatted” data need to be communicated. The respective ISO standard explicitly deprecates the point and the comma as well for this special use. Spreadsheet software, OTOH, supports only these deprecated characters for the purpose. It’s a mess - as next to everything in “real reality”.
You surely know that next to all of continental Europe (with some funny exceptions in CH) uses the comma as the decimal separator. I do otherwise, but only in spreadsheets. Are you sure you want to be a follower insofar.

[erAck]

@Toby1

that was always wrong

Yes. The language uk is Ukrainian and a country code UK does not exist. The fallback was likely uk-UA that has decimal separator , comma.
You wanted en-GB instead.