Set the culture

The following example shows you how to set the culture used for text conversion. CalcOptions.Culture controls how TEXT, DOLLAR, FIXED, VALUE, DATEVALUE and the & operator convert between numbers and text. The default is the invariant culture, which matches the en-US behaviour of Excel. Formulas themselves always use invariant syntax.

As in Excel, the format text of TEXT is read in the conventions of the culture: with a non-English culture the decimal and group separators and the localized date letters are translated (German #.##0,00 and TT.MM.JJJJ, French # ##0,00 and jj/mm/aaaa), while the default culture and English cultures read the English codes. Text that is converted to a date or time (VALUE, DATEVALUE, arithmetic on text) is recognized by one fixed set of patterns built from the culture's date order, date separator, month names and AM/PM designators.

C# example

using System;
using System.Globalization;
using Independentsoft.Calc;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet1 = new Worksheet("Sheet1");
            sheet1["A1"] = new Cell(1234.5);

            Cell text = new Cell();
            //The format text is written the way a German user types it
            text.Formula = new Formula("TEXT(A1,\"#.##0,00\")");
            sheet1["A2"] = text;

            Workbook book = new Workbook();
            book.Sheets.Add(sheet1);

            CalcSession session = new CalcSession();
            session.Options.Culture = new CultureInfo("de-DE");

            session.Calculate(book);

            //Prints 1.234,50
            Console.WriteLine(sheet1["A2"].Value);
        }
    }
}

VB example

Imports System
Imports System.Globalization
Imports Independentsoft.Calc
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet1 As New Worksheet("Sheet1")
        sheet1("A1") = New Cell(1234.5)

        Dim text As New Cell()
        'The format text is written the way a German user types it
        text.Formula = New Formula("TEXT(A1,""#.##0,00"")")
        sheet1("A2") = text

        Dim book As New Workbook()
        book.Sheets.Add(sheet1)

        Dim session As New CalcSession()
        session.Options.Culture = New CultureInfo("de-DE")

        session.Calculate(book)

        'Prints 1.234,50
        Console.WriteLine(sheet1("A2").Value)

    End Sub
End Module

Calc .NET > Tutorial > Set the culture

Need help? Ask our developers: