Cell.displaystringvalue seems not working

Aspose.Cells Product Family
1

hi,i am using aspose.cells (20.8.0),
i used the below test codes:

var excelFileFullname = @“O:\TEST2.xlsx”;
using var workbook = new Workbook(excelFileFullname);
var sheet = workbook.GetWorkSheet(“Sheet1”);

var cell = sheet.Cells[“M1”];
var value = cell.DisplayStringValue;

the value shown in ms excel is 0.0
the value from aspose.cells api is -0.0

can you please have a look?

TEST2.7z (6.4 KB)

2

@vs6060_qq_com,

I tested your scenario/case using our latest version/fix, Aspose.Cells for .NET v24.3 and it works fine. I am using the following sample code and value “0.0” is retrieved as expected.
e.g.
Sample code:

var excelFileFullname = "g:\\test2\\TEST2.xlsx";

using var workbook = new Workbook(excelFileFullname);

var sheet = workbook.Worksheets["Sheet1"];

var cell = sheet.Cells["M1"];

var value = cell.DisplayStringValue;

Console.WriteLine(value);//0.0 - Ok

This line of code is wrong. Please try using my suggested code segment.