Posted 31 May 2018, 5:35 am EST
Hi,
We found there is change in the way we add custom culture in v11 when compare to v9.
And We faced some issues when we were trying to add a custom culture to spread and we are facing some issues.
we get culture related info from server based on user locale, and when we are trying to set this in CultureInfo object and then add it to spread. Like below:
var obj = {"NumberFormat":{"currencyDecimalDigits":2,"currencyDecimalSeparator":",","currencyGroupSeparator":" ","currencyGroupSizes":[3],"currencyNegativePattern":15,"currencyPositivePattern":3,"currencySymbol":"$","digitSubstitution":1,"isReadOnly":false,"numberGroupSizes":[3],"nanSymbol":"NaN","nativeDigits":["0","1","2","3","4","5","6","7","8","9"],"numberNegativePattern":1,"negativeInfinitySymbol":"-∞","negativeSign":"-","numberDecimalDigits":2,"numberDecimalSeparator":",","numberGroupSeparator":" ","positiveInfinitySymbol":"∞","positiveSign":"+","percentDecimalDigits":2,"percentDecimalSeparator":",","percentGroupSeparator":" ","percentGroupSizes":[3],"percentNegativePattern":0,"percentPositivePattern":0,"percentSymbol":"%","perMilleSymbol":"‰","listSeparator":";","arrayListSeparator":"\\","arrayGroupSeparator":";"},"DateTimeFormat":{"abbreviatedDayNames":["dim.","lun.","mar.","mer.","jeu.","ven.","sam."],"abbreviatedMonthGenitiveNames":["janv.","févr.","mars","avr.","mai","juin","juil.","août","sept.","oct.","nov.","déc.",""],"abbreviatedMonthNames":["janv.","févr.","mars","avr.","mai","juin","juil.","août","sept.","oct.","nov.","déc.",""],"amDesignator":"","calendarIsReadOnly":false,"calendarWeekRule":0,"dayNames":["dimanche","lundi","mardi","mercredi","jeudi","vendredi","samedi"],"firstDayOfWeek":0,"fullDateTimePattern":"d MMMM yyyy HH:mm:ss","longDatePattern":"d MMMM yyyy","longTimePattern":"HH:mm:ss","monthDayPattern":"d MMMM","monthGenitiveNames":["janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre",""],"monthNames":["janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre",""],"nativeCalendarName":"calendrier grégorien","pmDesignator":"","rfc1123Pattern":"ddd, dd MMM yyyy HH':'mm':'ss 'GMT'","shortDatePattern":"yyyy-MM-dd","shortestDayNames":["di","lu","ma","me","je","ve","sa"],"shortTimePattern":"HH:mm","sortableDateTimePattern":"yyyy'-'MM'-'dd'T'HH':'mm':'ss","timeSeparator":":","universalSortableDateTimePattern":"yyyy'-'MM'-'dd HH':'mm':'ss'Z'","yearMonthPattern":"MMMM, yyyy"},"id":-1,"currencySymbol":"$"}
var myCulture = new GC.Spread.Common.CultureInfo();
for (var key in myCulture.NumberFormat) {
if(obj.NumberFormat[key]) {
myCulture.NumberFormat[key] = obj.NumberFormat[key];
}
}
for (var key in obj.DateTimeFormat) {
if(obj.DateTimeFormat[key]) {
myCulture.DateTimeFormat[key] = obj.DateTimeFormat[key];
}
}
GC.Spread.Common.CultureManager.addCultureInfo("fr-CA", myCulture);
GC.Spread.Common.CultureManager.culture("fr-CA");
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
Note: In this scenario what we are seeing is, when sheet renders comma is rendered as thousand seperator instead of a space. formatter we are using for the cell is: “(* #,##0);[Red](* (#,##0);(* “-”);(@_)”
But, when we dont add “percentDecimalSeparator”, “percentGroupSeparator” to cultureInfo under thnigs work perfectly.
Could you please let us know do we need to include these two properties as part of setting culture Info? also let us know if we are missing anything else.
Thanks,
Viswanath
