Custom Localization

Users need to define the localization object with the schema, or get the current working or specified culture resources with GC.Spread.Common.CultureManager.getResources(cultureName?: string). Then add to the CultureManager and switch to the defined culture.

The worksheet displays different properties with the defined words.

For example:

var lang = {
    // localization config goes here
    Sheets: {
        Tip_Row: "行 = ",  //No parameters, will add the row number
        Tip_Column: "列 = ",
        Tip_Height: "高度: {0} 像素",   //Use the parameters 
        Tip_Width: "寬度: {0} 像素",
    },
    CalcEngine: {
        Fbx_Summary: "概要"
    },
    Functions: {
        SUM: {
            description: "此函數返回某一單元格區域中所有數字之和。",
            parameters: ["值1", "值2"]
        },
        NOW: {
            description: "此函數返回當前的日期和時間。"
        },
        IF: {
            description: "使用邏輯函數 IF 函數時，如果條件為真，該函數將返回一個值；如果條件為假，函數將返回另一個值。",
            parameters: ["判断条件", "值1", "值2"]
        },
    }
};

GC.Spread.Common.CultureManager.addCultureInfo("zh-tw", null, lang);   //Add the language
GC.Spread.Common.CultureManager.culture("zh-tw")    //set the culture

Or modify resources based on specified culture resources.

var originZHLang = GC.Spread.Common.CultureManager.getResources("zh-cn");
originZHLang.Sheets.Tip_Row = "行 = ";
originZHLang.Sheets.Tip_Column = "列 = ";
originZHLang.Sheets.Tip_Height = "高度: {0} 像素";
originZHLang.Sheets.Tip_Width = "寬度: {0} 像素";
originZHLang.CalcEngine.Fbx_Summary = "概要";
originZHLang.Functions.SUM = {
            description: "此函數返回某一單元格區域中所有數字之和。",
            parameters: ["值1", "值2"]
        };
originZHLang.Functions.NOW = {
            description: "此函數返回當前的日期和時間。"
        };
originZHLang.Functions.IF = {
            description: "使用邏輯函數 IF 函數時，如果條件為真，該函數將返回一個值；如果條件為假，函數將返回另一個值。",
            parameters: ["判断条件", "值1", "值2"]
        };
GC.Spread.Common.CultureManager.addCultureInfo("zh-tw", null, originZHLang);   //Add the language
GC.Spread.Common.CultureManager.culture("zh-tw")    //set the culture

Hint:

If some of the statements are not set, Spread will display English (if set to an empty string “”, it will not display anything)..

The arguments is use {0}, {1}, … for display (e.g.: "Invalid {0}: {1} (must be between {2} and {3}).", "Height: {0} pixels").

Custom localization does not support fromJSON/toJSON, so a user will need to add it every time it is needed.

The namespace ("common", "Sheets", "Filter") in the sample is optional, but "Functions" and "TableFunctions" are required. The following is also a valid format:

var lang = {
    Tip_Row: "行 = ",  //No parameters, will add the row 
    Tip_Column: "列 = ",
    Tip_Height: "高度: {0} 像素",   //Use the parameters 
    Tip_Width: "寬度: {0} 像素",
    CalcEngine: {  //the CalcEngine can be optional, and put Fbx_Summary into the lang object.
        Fbx_Summary: "概要"
    },
    Functions: { //The "Functions" is needed to custom the function's description.
        SUM: {
            description: "此函數返回某一單元格區域中所有數字之和。",
            parameters: ["值1", "值2"]
        },
    }
};