Any plans to implement the YEAR()- DAY() and MONTH() functions?


#1

Do you know if there is any plan to implement these functions? Our Excel spreadsheets are using these functions and i would like to know if we could use Aspose.Excel with them.


#2

These functions are already supported. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Cell.Formula.html for reference.


#3

I was looking at the wrong page: http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Excel.CalculateFormula.html

Does it means that YEAR() for example is not supported in CalculateFormula since it doesn't appear in the list?

Is the LOOKUP function is supported when we recalculate the spreadsheet through Aspose?

Thanks