i use Aspose.Cells version 220.127.116.11 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?
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.
Please try the attached version v18.104.22.168. We have fixed the issue now.