Implement Errors and Boolean Value in Russian or Any Other Language

Possible Usage Scenarios

If you are using Microsoft Excel in a Russian locale or language, or any other locale or language, it will display errors and Boolean values according to that locale or language. You can achieve similar behavior using Aspose.Cells by using the Workbook.Settings.GlobalizationSettings property. You will have to override the following methods of 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 refer to the Sample Excel File used by this code and its Output PDF. The screenshot shows the difference between the sample Excel file and the output PDF for reference.

todo:image_alt_text

Sample Code

Implement Cell.FormulaLocal similar to Excel VBA Range.FormulaLocal Implement Subtotal or Grand Total Labels in Other Languages