Column decimal formatting

Aspose.Cells Product Family
1

I am trying to format a column to two decimal places.

I am using the below code:
Aspose.Cells.Style numeric_style = book1.CreateStyle();
numeric_style.Number = 2;
StyleFlag flg1 = new StyleFlag();
flg1.NumberFormat = true;
sheet1.Cells.Columns[column_index].ApplyStyle(numeric_style, flg1);
book1.Save(filepath, SaveFormat.Xlsx);

But its formatting to 4 decimal places.

Is the right way or is there any other method to do this. Need help with this.

Thanks in advance,
Madhuri
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and use the latest version: Aspose.Cells
for .NET v7.3.4.1. It works fine and displays correct results.

Please see the following test code. I have attached the output xlsx file and the screenshot for your reference.

C#



Workbook workbook = new Workbook();


Worksheet worksheet = workbook.Worksheets[0];


Aspose.Cells.Style numeric_style = workbook.CreateStyle();

numeric_style.Number = 2;


Column ColumnB = worksheet.Cells.Columns[1];


StyleFlag flag = new StyleFlag();

flag.NumberFormat = true;


ColumnB.ApplyStyle(numeric_style, flag);


//Enter some test value in cell B2

worksheet.Cells[“B2”].PutValue(23);


workbook.Save(“output.xlsx”, SaveFormat.Xlsx);


Screenshot: