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.