StringValue is different than the display in Excel

Hi,

i use Aspose.Cells version 5.0.0.0 to read Excel workbooks.

If a cell contains formula, scaling, and a negative value the Cell.StringValue is not correct.

In the attached example, the value in row 4 column 2 is ‘0 .80 M€’ .

Cell.StringValue shows: '-800,000.00 M€’

What is the reason and how can I change this?

Regards,

Guido

Hi,

We found the issue as you have mentioned by using your template file.
I have logged your issue into our issue tracking system with an id: CELLSNET-20438. We will figure it out soon.

Thank you.

Hi,

Please try the attached version v5.1.3.4. We have fixed the issue now.

Thank you.

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.