Posted 19 December 2023, 3:27 am EST - Updated 19 December 2023, 7:15 am EST
Hi Support team,
I’m trying to define the culture for the en-GB locale below:
{
'en-GB': {
id: 0x809,
displayName: 'English (United Kingdom)',
name: 'en-GB',
currencySymbol: '\u00a3',
numberDecimalSeparator: '.',
numberGroupSeparator: ',',
arrayGroupSeparator: ';',
arrayListSeparator: '\\',
listSeparator: ';',
amDesignator: 'AM',
pmDesignator: 'PM',
abbreviatedMonthNames: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', ''],
abbreviatedDayNames: ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'],
abbreviatedMonthGenitiveNames: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', ''],
dayNames: ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'],
fullDateTimePattern: 'dddd, d. mmmm yyyy hh:mm:ss',
longDatePattern: 'dddd, d. mmmm yyyy',
longTimePattern: 'hh:mm:ss',
monthDayPattern: 'dd mmmm',
monthNames: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December', ''],
monthGenitiveNames: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December', ''],
shortDatePattern: 'dd/mm/yyyy',
shortTimePattern: 'hh:mm',
yearMonthPattern: 'mmm yyyy',
accounting: '_-[$£-809]* #,##0.#_-;-[$£-809]* #,##0.#_-;_-[$£-809]* "-"??_-;_-@_-',
currency: [
'#,##0.00',
'[$£-809]#,##0;[Red][$£-809]#,##0',
'[$£-809]#,##0;-[$£-809]#,##0',
'[$£-809]#,##0;[Red]-[$£-809]#,##0'
],
date: [
'dd/mm/yyyy;@',
'dd/mm/yy;@',
'd/m/yy;@',
'd.m.yy;@',
'yyyy-mm-dd;@',
'[$-en-GB]d mmmm yyyy;@'
],
time: [
'hh:mm:ss;@',
'h:mm:ss;@',
'[$-en-US]hh:mm:ss AM/PM;@',
'[$-en-US]h:mm:ss AM/PM;@'
],
special: {
}
}I have an Excel file with some cells formatted “dd/mm/yyyy” with the locale is en-GB
when I open that file on my app with the locale I defined above, the locale display is correct
but when I input the new value in the other cell (15/01/2023), it does not get the correct date format
Can you point out my mistake in the definition above?
Many thanks.
Hieu.
