View Source

你可以修改 culture 字符串，并使用 CultureInfo 类来创建自定义 culture。

下表列出了 CultureInfo 中的变量，默认值和描述。

The following table lists the class variables, default values, and basic descriptions.

变量名	默认值	描述
currencySymbol	"\u00A4"	美元是 "$"
numberDecimalSeparator	"."	小数点
numberGroupSeparator	","	千分位
arrayGroupSeparator	";"	公式中的数组分隔符
listSeparator	","	公式中方法参数的分隔符
aMDesignator	"AM"
pMDesignator	"PM"
abbreviatedMonthNames	["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec", ""]	格式化字符串是 "MMM"
abbreviatedDayNames	["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"]	格式化字符串是 "ddd"
abbreviatedMonthGenitiveNames	["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec", ""]	格式化字符串是 "MMM"
dayNames	["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"]	格式化字符串是 "dddd"
fullDateTimePattern	"dddd, dd MMMM yyyy HH:mm:ss"	标准日期格式化字符 "F"
longDatePattern	"dddd, dd MMMM yyyy"	标准日期格式化字符 "D"
longTimePattern	"HH:mm:ss"	标准日期格式化字符 "T" 和 "U"
monthDayPattern	"MMMM dd"	标准日期格式化字符 "M" 和 "m"
monthNames	["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December", ""]	格式化字符串是 "M" 或 "MM"
monthGenitiveNames	["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December", ""]	格式化字符串是 "MMMM"
rFC1123Pattern	"ddd, dd MMM yyyy HH\':\'mm\':\'ss \'GMT\'"	标准日期格式化字符 "R" 和 "r"
shortDatePattern	"MM/dd/yyyy"	标准日期格式化字符 "d"
shortTimePattern	"HH:mm"	标准日期格式化字符 "t"
sortableDateTimePattern	"yyyy\'-\'MM\'-\'dd\'T\'HH\':\'mm\':\'ss"	标准日期格式化字符 "s"
universalSortableDateTimePattern	"yyyy\'-\'MM\'-\'dd HH\':\'mm\':\'ss\'Z\'"	标准日期格式化字符 "u"
yearMonthPattern	"yyyy MMMM"	标准日期格式化字符 "y" 和 "Y"

你可以使用 GeneralFormatter 来给单元格设置自定义 culture。

示例代码

以下代码创建了自定义 culture 并给 (1,0) 和 (3,0) 单元格设置了日期格式，给 (0,0) 单元格设置了数字格式。

var myCulture = new GC.Spread.Common.CultureInfo();
myCulture.NumberFormat.currencySymbol = "€"
myCulture.NumberFormat.numberDecimalSeparator = ",";
myCulture.NumberFormat.NumberFormatumberGroupSeparator = ".";
myCulture.NumberFormat.arrayGroupSeparator = ";";
myCulture.NumberFormat.arrayListSeparator = "\\";
myCulture.NumberFormat.listSeparator = ";";
myCulture.DateTimeFormat.amDesignator = "";
myCulture.DateTimeFormat.pmDesignator = "";
myCulture.DateTimeFormat.abbreviatedMonthNames = ["Jan", "Feb", "Mrz", "Apr", "Mai", "Jun", "Jul", "Aug", "Sep", "Okt", "Nov", "Dez", ""];
myCulture.DateTimeFormat.abbreviatedDayNames = ["So", "Mo", "Di", "Mi", "Do", "Fr", "Sa"];
myCulture.DateTimeFormat.abbreviatedMonthGenitiveNames = ["So", "Mo", "Di", "Mi", "Do", "Fr", "Sa"];
myCulture.DateTimeFormat.dayNames = ["Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag"];
myCulture.DateTimeFormat.fullDateTimePattern = "dddd, d. MMMM yyyy HH:mm:ss";
myCulture.DateTimeFormat.longDatePattern = "dddd, d. MMMM yyyy";
myCulture.DateTimeFormat.longTimePattern = "HH:mm:ss";
myCulture.DateTimeFormat.monthDayPattern = "dd MMMM";
myCulture.DateTimeFormat.monthNames = ["Januar", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember", ""];
myCulture.DateTimeFormat.monthGenitiveNames = ["Januar", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember", ""];
myCulture.DateTimeFormat.shortDatePattern = "dd.MM.yyyy";
myCulture.DateTimeFormat.shortTimePattern = "HH:mm";
myCulture.DateTimeFormat.yearMonthPattern = "MMMM yyyy";
//add one culture
GC.Spread.Common.CultureManager.addCultureInfo("de-DE", myCulture);
//switch to "de-DE" culture
GC.Spread.Common.CultureManager.culture("de-DE");
var d = new Date();
//With culture
activeSheet.setValue(1, 0, new Date(d.setDate(d.getDate() + 1)));
activeSheet.getCell(1, 0).formatter("mmm");
var dvalue = 12345.6789;
activeSheet.setColumnWidth(0, 200);
activeSheet.setColumnWidth(1, 200);
activeSheet.setColumnWidth(2, 200);
activeSheet.setValue(0, 0, dvalue);
activeSheet.getCell(0, 0).formatter("###,###.00");
activeSheet.setValue(2, 0, new Date(d.setDate(d.getDate() + 1)));
//With culture
activeSheet.getCell(3, 0).formatter("yyyy/mmm/dddd");
activeSheet.setValue(3, 0, new Date());