Invalid formula exception on Open

Aspose.Cells Product Family
1

Exception is:

{“Error in Cell: O13-Invalid formula:”=HLOOKUP(I13,{“5/16”,“21/44”,“1/2”,“2/3”,“3/4”,“4/5”,“5/6”,“7/8”,“17/18”,“1”,“TPC 1/3”,“TPC 1/2”,“TPC 3/4”;0.3125,0.47727,0.5,0.6667,0.75,0.8,0.8333,0.875,0.9444,1,0.325,0.495,0.793},2,FALSE)"."}

Cell I13 has the following range of values in data validation:
1/2,3/4,2/3,5/6,7/8,1,4/5,17/18,5/16,21/44,TPC 1/3,TPC 1/2,TPC 3/4

Aspose version is 4.7.1.

2

Hi,

Could you try our latest version v5.3.3.2 if it works fine.

If you still find the issue, please paste your sample code and attached your template file, we will check it soon.

thank you.

3

Looks like something between 4.7.1 and 5.3.3.2 fixed the issue. We’ll upgrade to the latest product. Thanks for the quick response.