用 C++ 实现类似于 Excel VBA Range.FormulaLocal 的 Cell.FormulaLocal

可能的使用场景

Microsoft Excel公式在不同语言、地区或国家/地区可能有不同的名称。例如，SUM 函数在德语中称为SUMME。Aspose.Cells无法处理非英语函数名称。在Microsoft Excel VBA中，有一个Range.FormulaLocal 属性，根据其语言或地区返回函数的名称。Aspose.Cells也为此提供了Cell.FormulaLocal属性。但是，只有在您实现GlobalizationSettings.GetLocalFunctionName(string standardName)方法时，此属性才能正常工作。

实现类似于Excel VBA Range.FormulaLocal的Cell.FormulaLocal

以下示例代码解释了如何实现GlobalizationSettings.GetLocalFunctionName(string standardName)方法。该方法返回标准函数的本地名称。如果标准函数名称为SUM，它将返回UserFormulaLocal_SUM。您可以根据需要更改代码并返回正确的本地函数名称，例如SUM 在德语中是SUMME，TEXT 在俄语中是ТЕКСТ。还请参考下面给出的示例代码的控制台输出作为参考。

示例代码

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

// Implement GlobalizationSettings class
class GS : public GlobalizationSettings
{
public:
    virtual U16String GetLocalFunctionName(const U16String& standardName) override
    {
        // Change the SUM function name as per your needs.
        if (standardName == u"SUM")
        {
            return u"UserFormulaLocal_SUM";
        }

        // Change the AVERAGE function name as per your needs.
        if (standardName == u"AVERAGE")
        {
            return u"UserFormulaLocal_AVERAGE";
        }

        return u"";
    }
};

void Implement_Cell_FormulaLocal_SimilarTo_Range_FormulaLocal()
{
    // Create workbook
    Workbook wb;

    // Assign GlobalizationSettings implementation class
    wb.GetSettings().SetGlobalizationSettings(new GS());

    // Access first worksheet
    Worksheet ws = wb.GetWorksheets().Get(0);

    // Access some cell
    Cell cell = ws.GetCells().Get(u"C4");

    // Assign SUM formula and print its FormulaLocal
    cell.SetFormula(u"SUM(A1:A2)");
    std::cout << "Formula Local: " << cell.GetFormulaLocal().ToUtf8() << std::endl;

    // Assign AVERAGE formula and print its FormulaLocal
    cell.SetFormula(u"=AVERAGE(B1:B2, B5)");
    std::cout << "Formula Local: " << cell.GetFormulaLocal().ToUtf8() << std::endl;
}

int main()
{
    Aspose::Cells::Startup();
    Implement_Cell_FormulaLocal_SimilarTo_Range_FormulaLocal();
    Aspose::Cells::Cleanup();
    return 0;
}

控制台输出

Formula Local: =UserFormulaLocal_SUM(A1:A2)

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