实施 Cell.FormulaLocal 类似于 Excel VBA Range.FormulaLocal

可能的使用场景

Microsoft Excel 公式在不同的语言环境或地区或语言中可能有不同的名称。例如，和函数被调用夏日在德国。 Aspose.Cells 无法使用非英语函数名称。在 Microsoft Excel VBA 中，有范围.FormulaLocal根据函数的语言或区域返回函数名称的属性。 Aspose.Cells还提供Cell.FormulaLocal为此目的的财产。但是，此属性仅在您实施时才有效GlobalizationSettings.GetLocalFunctionName（字符串标准名称）方法。

实施 Cell.FormulaLocal 类似于 Excel VBA Range.FormulaLocal

下面的示例代码解释了如何实现GlobalizationSettings.GetLocalFunctionName（字符串标准名称）方法。该方法返回标准函数的本地名称。如果标准函数名是和 它返回UserFormulaLocal_SUM.您可以根据需要更改代码并返回正确的本地函数名称，例如和是夏日用德语和文本是ТЕКСТ用俄语。另请参阅下面给出的示例代码的控制台输出以供参考。

示例代码

// 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);
        }
    }
}

控制台输出

Formula Local: =UserFormulaLocal_SUM(A1:A2)

Formula Local: =UserFormulaLocal_AVERAGE(B1:B2,B5)