Double values change when opened by cells and saved to byte array

Aspose.Cells Product Family
1

Double values in cells change - the process is as follows:

1.1. Upload Excel file via browser

1.2. Create Workbook from MemoryStream

1.3. Save Byte Array to DB

2.1. Read Byte Array from DB, create Workbook from MemoryStream

2.2. Write when approriate to Workbook

2.3. Download from browser as Byte Array from MemoryStream



As soon as the Excel File has been opened by Aspose Cells and downloaded, there are several double values that are changed when opening in Excel, even when the file was just opened without changing anything and downloaded as Byte Array generated from the Workbook-MemoryStream.

See the two sample Excel files attached:

- Double_changed_before_opening_with_cells.xlsx

- Double_changed_after_opening_with_cells.xlsx

In the Debugger you can see the double values, e. g. B5 which changes at the sixth decimal position from 6 to 7 after the file has been opened and downloaded.



Why does this happen and how can it be prevented, we have spent a lot of time yet and must provide a solution to our customer.



Thank you in advance for your Feedback/solution.



Regards, Erhard

2

Hi Erhad,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for .NET v8.3.0.2 and see if resolves your issue.

If your issue still persists, then please provide us a console application without any DB dependency replicating this issue with the latest version.

We will look into your issue and help you asap.

3

Hi Mshakeel



thank you for your reply.



See the console solution attached which shows the Problem.



Thank you in advance for your Feedback.



Regards, Erhard



PS: I had to remove the license file from the zip, please contact me, if I have to provide it.

4

Hi Erhard,


Thank you for providing the sample application.

We are able to replicate the said problem of change in the double values while using your provided sample application. We have logged the problem in our bug tracking system under the ticket CELLSNET-43194 for further investigation. Please spare us little time to properly analyze the problem cause, and to provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
5

Hi Erhard,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.0.3 and let us know your feedback.

6

Hi Shakeel

thank you very much, the fix works:-)

Kind Regards
Erhard

7

Hi Erhard,


Thank you for the confirmation. Please feel free to contact us back in case you need our further assistance with Aspose APIs.
8

The issues you have found earlier (filed as CELLSNET-43194) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.