Excel not allowint more than 15 integer values

Aspose.Cells Product Family
1

we are using aspose cells for load the database data into Excel., While loading more than 15 Integer values, value getting rounded with zero’s.



Code:



dtDataset = GetData(Parm1, Parm2);

Sheet.Cells.ImportDataTable(dtDataset , false, “A5”);



Actual value it supposed to show is :12345678901234568.12

2

Hi,

Thanks for your posting and using Aspose.Cells.

We have added this number manually in Microsoft Excel and it rounded off the number when digits are more than 15.

So, it is not a bug of Aspose.Cells, but it is a limitation of Microsoft Excel. If something is not possible with Microsoft Excel, then it is also not possible with Aspose.Cells.

If you think, it is possible with Microsoft Excel, then please provide us a workbook which should contain this huge number without being rounded off. We will then look into your excel file and then try to achieve the same thing with Aspose.Cells. In case of some missing feature, we will log a new feature request in our database to support it in newer versions. Thanks for your cooperation.