Hi,
I am trialling Aspose Cells (4.4.3.1) using Visual Studio 2005 and Windows XP.
I can't use function DateDiff althought it's been in the formula list which I have read in the documentation.
When I put this formula to the cells:
Dim AspWorkBook As New Aspose.Cells.Workbook
Dim AspWorkSheet As Aspose.Cells.Worksheet = AspWorkBook.Worksheets(0)
AspWorkSheet.Name = "MySheet"
AspWorkSheet.Cells("A1").Formula=DateDiff("3/2/2008","3/7/2008","d")
AspWorkBookCalculateFormula()
MessageBox.Show(AspWorkSheet.Cells("A1").Value)
, then it returns this error :
#Name?
Doesn't Aspose support this function ?
Regards,
Hau