你可以修改 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) 单元格设置了数字格式。
JavaScript
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());
更多信息
Setting the Culture
Setting the Era Format
Formatting Cells