Implement Errors and Boolean Value in Russian or Any Other Language with C++

Possible Usage Scenarios

If you are using Microsoft Excel in the Russian locale or any other locale, it will display errors and Boolean values according to that locale. You can achieve similar behavior using Aspose.Cells by using the Workbook.GetGlobalizationSettings() property. You will have to override the following methods of the GlobalizationSettings class.

• GlobalizationSettings.GetErrorValueString()
• GlobalizationSettings.GetBooleanValueString()

Implement Errors and Boolean Value in Russian or Any Other Language

The following sample code illustrates how to implement errors and Boolean values in Russian or any other language. Please check the Sample Excel File used in this code and its Output PDF. The screenshot shows the difference between the sample Excel file and the output PDF for reference.

Sample Code

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

class RussianGlobalization : public GlobalizationSettings
{
public:
    virtual U16String GetErrorValueString(const U16String& err) override
    {
        if (err == u"#NAME?")
        {
            return u"#RussianName-имя?";
        }
        return u"RussianError-ошибка";
    }

    virtual U16String GetBooleanValueString(bool bv) override
    {
        return bv ? u"RussianTrue-правда" : u"RussianFalse-ложный";
    }
};

class ImplementErrorsAndBooleanValueInRussianOrAnyOtherLanguage
{
public:
    static void Run()
    {
        Aspose::Cells::Startup();

        Workbook wb(u"sampleRussianGlobalization.xlsx");

        auto russianGlobalization = std::make_shared<RussianGlobalization>();
        wb.GetSettings().SetGlobalizationSettings(russianGlobalization.get());

        wb.CalculateFormula();

        wb.Save(u"outputRussianGlobalization.pdf");

        Aspose::Cells::Cleanup();
    }
};

int main()
{
    ImplementErrorsAndBooleanValueInRussianOrAnyOtherLanguage::Run();
    return 0;
}