Aspose Cells ExportDataTable

volker.voigt.catalig · August 28, 2009, 9:03am

Hi,

usage of ExportDataTable with formulas within a worksheet.

Using ExportDataTableAsString resolves the formulas
Using ExportDataTable doesn’t.

Is there a reason for this or am I doing something wrong?

I have lets say two datetime cells. Cell1 holds 06/11/2009 Cell2 holds a formula =Cell1+3
it shows 06/14/2009

After ExportDataTable the returned datatable shows null for Cell2
After ExportDataTableAsString the returned datatable shows the correct value for Cell2 as a string.

I’m using Aspose Cells 4.7.1.0

Any help is appreciated.

Thanks

nausherwan.aslam · August 28, 2009, 10:55am

Hi,

Thank you for considering Aspose.

I tested your issue with the attached latest version of Aspose.Cells and it works fine. Please try the attached version and let us know if it works fine for you. If you still face any problem, please share your template file and sample code and we will check it soon.

Thank You & Best Regards,