We're sorry AsposeCloud doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.cloud

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 https://forum.aspose.com/c/cells/9.

#4

@santhoshsas,

Please check the post(https://forum.aspose.com/t/representation-of-double-numbers-in-aspose-cells/22227/9).