Excel lookup function

Aspose.Cells Product Family
1

Dose ASPOSE fully support EXCEL LOOKUP function? I used Array Form LOOKUP function: =LOOKUP(A2,{0,60,70,80,90},{“F”,“D”,“C”,“B”,“A”}).

This is the error that I got:


ERROR 2010-07-16 12:38:42,875 [com.caci.arms.utility.aspose.AsposeExcelGraph] - You have entered too many parameters for fuction LOOKUP
java.lang.IllegalArgumentException: You have entered too many parameters for fuction LOOKUP
at com.aspose.cells.bB.a(Lcom.aspose.cells.fm;Lcom.aspose.cells.G;)V(Unknown Source)
at com.aspose.cells.bB.a(Lcom.aspose.cells.fm;Lcom.aspose.cells.G;CIICS)Z(Unknown Source)
at com.aspose.cells.bB.a(Lcom.aspose.cells.G;IICS)Lcom.aspose.cells.fm;(Unknown Source)
at com.aspose.cells.aY.b(Ljava.lang.String;IICLjava.lang.Object;IZ)Lcom.aspose.cells.fm;(Unknown Source)
at com.aspose.cells.aY.b(Ljava.lang.String;IICLjava.lang.Object;Z)Lcom.aspose.cells.fm;(Unknown Source)
at com.aspose.cells.Cell.a(Ljava.lang.String;Z)V(Unknown Source)
at com.aspose.cells.Cell.setFormula(Ljava.lang.String;)V(Unknown Source)
at com.caci.arms.utility.aspose.AsposeExcelGraph.createExcelPieGraph(AsposeE

2

Hi,

I have found the issue using your specified formula. We will figure it out soon.

I have logged your issue into our issue tracking system with an id: CELLSJAVA-18535.


Thank you.

3

The issues you have found earlier (filed as 18535) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.