We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formula error: #VALUE!

hi folks,

i am using the latest publicly released version of the Aspose.Cells component (4.1.0.0) and found that there is a problem.

refer to the attached xls file for the error description. this file was generated in code:
1. select the sheet named "1.1 ZXMP S320(ZXSM-600(V2清单表"

2. go to cell G16 with the formula "=SUMPRODUCT(H6:H13,AB6:AB13)"

3. the problem is that the cell displays “#VALUE!” instead of the results. however, if i am to manually press the Enter key after the formula, the result is displayed correctly.

i recall a similar problem existed in a previous version but was fixed. would appreciate if you can check if this is a regression and if there is a way to resolve this.

thanks,
nick wong

Hi Nick,

Maybe it's a problem in v4.1 but it works fine in my machine. Please try this attached version.