Free Support Forum - aspose.com

Formulas Problem

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.