In aspose cell .Net giving wrong value after15th digit of decimal

Hi,
Currently, I am using Aspose cell Net 20.5 version

The Issue is when I am writing a value In excel with 17 digits in decimal I am getting the wrong number in the last digit in excel, Same if I read using the aspose getting wrong value again.

I am writing in cell 0.17333333333333332
and getting 0.17333333333333331

can any help me with this

@pankajgrwl123,

After an initial test, I am able to reproduce the issue as you mentioned by using the following sample code. If I open the output file into some zip tool (WinRAR tool), I spotted the value is documented as “0.17333333333333331” instead of “0.17333333333333332” in “\xl\worksheets\sheet1.xml”.
e.g.
Sample code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells["A1"].PutValue(0.17333333333333332);
workbook.Save("e:\\test2\\out1.xlsx");

I have logged a ticket with an id “CELLSNET-47873” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.

Thank you for your response, How can I track the same?

@pankajgrwl123,

Please note, issue tracking system (Redmine) is internal so you cannot track it. You have to ask us to get latest updates on your issue. You can just check the status (e.g. Open, Resolved, etc.) in the Redmine section below (at the bottom of the page).

@pankajgrwl123,
It is the issue of .Net SDK. Please check the following codes:
double x = 0.17333333333333332; you will see x is 0.17333333333333331.
We can not fix this issue.