Implement Cell.FormulaLocal similar to Excel VBA Range.FormulaLocal
Possible Usage Scenarios
Microsoft Excel Formulas may have different names in different locales or regions or languages. For example, SUM function is called SUMME in German. Aspose.Cells cannot work with non-English function names. In Microsoft Excel VBA, there is Range.FormulaLocal property that returns the name of the function as per its language or region. Aspose.Cells also provides Cell.FormulaLocal property for this purpose. However, this property will only work when you will implement GlobalizationSettings.GetLocalFunctionName(string standardName) method.
Implement Cell.FormulaLocal similar to Excel VBA Range.FormulaLocal
The following sample code explains how to implement GlobalizationSettings.GetLocalFunctionName(string standardName) method. The method returns the local name of the standard function. If the standard function name is SUM, it returns UserFormulaLocal_SUM. You can change the code as per your needs and return the correct local function names e.g. SUM is SUMME in German and TEXT is ТЕКСТ in Russian. Please also see the console output of the sample code given below for a reference.
Sample Code
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Text; | |
namespace Aspose.Cells.Examples.CSharp.WorkbookSettings | |
{ | |
class Implement_Cell_FormulaLocal_SimilarTo_Range_FormulaLocal | |
{ | |
//Implement GlobalizationSettings class | |
class GS : GlobalizationSettings | |
{ | |
public override string GetLocalFunctionName(string standardName) | |
{ | |
//Change the SUM function name as per your needs. | |
if (standardName == "SUM") | |
{ | |
return "UserFormulaLocal_SUM"; | |
} | |
//Change the AVERAGE function name as per your needs. | |
if (standardName == "AVERAGE") | |
{ | |
return "UserFormulaLocal_AVERAGE"; | |
} | |
return ""; | |
}//GetLocalFunctionName | |
}//GS:GlobalizationSettings | |
public static void Run() | |
{ | |
//Create workbook | |
Workbook wb = new Workbook(); | |
//Assign GlobalizationSettings implementation class | |
wb.Settings.GlobalizationSettings = new GS(); | |
//Access first worksheet | |
Worksheet ws = wb.Worksheets[0]; | |
//Access some cell | |
Cell cell = ws.Cells["C4"]; | |
//Assign SUM formula and print its FormulaLocal | |
cell.Formula = "SUM(A1:A2)"; | |
Console.WriteLine("Formula Local: " + cell.FormulaLocal); | |
//Assign AVERAGE formula and print its FormulaLocal | |
cell.Formula = "=AVERAGE(B1:B2, B5)"; | |
Console.WriteLine("Formula Local: " + cell.FormulaLocal); | |
} | |
} | |
} |
Console Output
Formula Local: =UserFormulaLocal_SUM(A1:A2)
Formula Local: =UserFormulaLocal_AVERAGE(B1:B2,B5)