Hi Aspose Team,
I'm having trouble with a spreadsheet evaluating the SUMIFS function in a workbook that I'm currently developing. The SUMIFS function shown below will calculate ok when the workbook is in standalone mode running from my PC and excel. When I invoke the spreadsheet from my application using Aspose.cells via a browser I get the #NAME? error...
SUMIFS(Costing!$I$7:$I$434,Costing!$Q$7:$Q$434,"Equipment Building",Costing!$R$7:$R$434,"X")
The application doesn't have a problem resolving the SUMIF function however...
SUMIF(Costing!$Q$7:$Q$434,"Equipment Building",Costing!$I$7:$I$434)
It's as if the SUMIFS function has trouble with text strings. I Assume that the SUMIFS function is supported in the latest Aspose.Cells.dll but have you encountered this type of issue before? Can you help?
Thanks,
Lee