Formula problem with data type

Aspose.Cells Product Family
1

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

2

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.