We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formula problem with data type

Hi,


In my project we allow users to download excel file (generated by using aspose) to get data from database unsing importDataTable.
While exporting data to excel for one column i created formula so that when user changed value in other cells it will be summed.
Ex:
worksheet.Cells(“M4”).Formula() = "=SUM(N4 “:BD4”)"

So after getting report if i change value then it is working perfectly.

Same report(Modified) should be imported to data base again.
So i imported changed data to dataTable and by reading from datatable i am saving the data.
But while reading column “M4” it is throwing error as “Input string was not in a correct format

Can some one please help on fix

Hi,


Please create a sample console application (runnable), zip it and post it here with v7.5.0.2, also, attach your template Excel file to reproduce the issue on our end. We will check your issue soon.

Thank you.