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.

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();
            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()
        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: