Locale number format

Aspose.Cells Product Family
1

hi,


i have problem with numbers format with .

if you are in eurupe you will write 1,50 but in US 1.50

in excel if you write number save the file and open the file after changing the regional settings the format will be changed automaticlly.

is it possible to do the same with aspose?

i need to write number with 1,000.50 and open it in US the same but in europe as 1.000,50
This message was posted using Page2Forum from Aspose.Cells for .NET - Documentation

2

Hi alshemesh,

You shouldn’t have any problem, just write the value with Aspose.Cells and change the regional settings and see the results. Let us know, if you have any problems.

3

hi,


i did it , but its not working.

if i am writing new value i see it changed, but the data that was exported dindnt change.
4

Hi alshemesh,

I investigated about your issue; you will just insert actual number and set their style with custom format “#,##0.00”. Here is a code example. Open it and change the regional settings to USA and then change it to Europe, you will see the number will change accordingly.

I have also attached the output xlsx file generated by this code.

C#


//Create a workbook

Workbook wb = new Workbook();


//Access a sheet

Worksheet ws = wb.Worksheets[0];


//Access a cell

Cell cel = ws.Cells[“A1”];


//Place a value

cel.PutValue(123456789.01);


//You need to set the style now

Style st = cel.GetStyle();

st.Custom = “#,##0.00”;

cel.SetStyle(st);


//Autofit first column

ws.AutoFitColumn(0);


//Save the output file

wb.Save(@“c:\downloads\test.out.xlsx”);



5

Hi,

Please also see this screenshot.