Hi,
Does Formulas works for diferent sheets?
Example: SHEET0 has in one cell (reference to SHEET1 Cell C12):
=IF(ISERROR('SHEET1_NAME'!C12),0,'SHEET1_NAME'!C12)
Returns: #NAME?
tks
excel function works in aspose? (if, iserror, etc)
Hi,
Well, Aspose.Grid.Web has its own calculation engine that supports many standard and advanced excel functions, kindly check the list (this is not final): http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/list-of-supported-functions.html
For your case, IF is supported but ISERROR is not supported currently, we will support it soon.
Thank you.