Decimal number Rounding issue

Aspose.Cells Cloud Product Family
1

Hi ,

I am facing an issue with decimal rounding in ASPOSE.

When I manually enter the number 1234567890.123451711 in excel it becomes 1234567890.12345. But the same is not working in ASPOSE when I do workbook.Worksheets[0].Cells[“A1”].PutValue(“1234567890.123451711”);

I also tried

style.Number = 0;
workbook.Worksheets[0].Cells[“A1”].PutValue(“1234567890.123451711”);

        workbook.Worksheets[0].Cells["A1"].SetStyle(style);

        data123 = workbook.Worksheets[0].Cells["A1"].Value;

But its not working. Can you let me know if I am missing anything?

2

style.Number = 0;
workbook.Worksheets[0].Cells[“A1”].PutValue(1234567890.123451711);

        workbook.Worksheets[0].Cells["A1"].SetStyle(style);

        data123 = workbook.Worksheets[0].Cells["A1"].Value;
3

@santhoshsas,

May I ask if you are using Aspose.Cells Cloud or Aspose.Cells local components?

if you are using Aspose.Cells local components , I will move the post to Aspose.Cells Product Family - Free Support Forum - aspose.com.

4

@santhoshsas,

Please check the post(Representation of double numbers in Aspose.Cells - #9 by aspose.notifier - Free Support Forum - aspose.com).