Cell value has changed to some negative number

Aspose.Cells Product Family
1

Hi,

I have noticed a strange behavior in the workbook.
Some positive numbers which I am inserting into the workbook, they are getting converted into negative numbers.
Please see the code below and the comments in bold words.

Code:-----------------------
class CellValueIsChanged
{
public static void Main()
{
Workbook workBook = new Workbook();
Worksheet dataSheet = workBook.Worksheets[0];
dataSheet.Name = “DataSheet”;

dataSheet.Cells[1, 0].PutValue(“Brand one”);
dataSheet.Cells[1, 1].PutValue(171523300);
dataSheet.Cells[1, 2].PutValue(272042400);
dataSheet.Cells[1, 3].PutValue(207347200);
dataSheet.Cells[1, 4].PutValue(0);
dataSheet.Cells[1, 5].PutValue(0);
dataSheet.Cells[1, 6].PutValue(1.586);
dataSheet.Cells[1, 7].PutValue(1.312);

dataSheet.Cells[2, 0].PutValue(“Brand two”);
dataSheet.Cells[2, 1].PutValue(272571200);
dataSheet.Cells[2, 2].PutValue(912597500); //This value is appearing as -161144324 in the WorkSheet
dataSheet.Cells[2, 3].PutValue(962400928); //This value is appearing as -111340896 in the WorkSheet
dataSheet.Cells[2, 4].PutValue(0);
dataSheet.Cells[2, 5].PutValue(0);
dataSheet.Cells[2, 6].PutValue(3.348);
dataSheet.Cells[2, 7].PutValue(2.511);

workBook.Save(@"D:\RPM.NET\Single_App_Test\Output\CellValueIsChanged.xls");
}
}
-----------------------------

Thanks and regards,
Vinay A

2

Hi,

Yes, you are right. I can reproduce this bug with latest version of Aspose.Cells for .NET.

This issue has been logged as CELLSNET-24775 .

3

Hi,

Please try Aspose.Cells for .NET v5.3.0.4, we have fixed the issue.

Thank you.

4

Hi,

This fix is working for this scenario.
Thanks.

Is it possible to use the version 5.3.0, and make some changes in our application, through which we can fix this issue.
(May be like passing all numeric values into some casted form)

Thanks and regards,
Vinay

5

Hi,

"Is it possible to use the version 5.3.0, and make some changes in our application, through which we can fix this issue.
(May be like passing all numeric values into some casted form)"

I am not sure what do you mean, could you elaborate it more? But, one thing should be clear, we don’t sell our source code for the product e.g Aspose.Cells for .NET API.

Thank you.

6

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

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