i am using the latest publicly released version of the Aspose.Cells component (126.96.36.199) 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.
Maybe it's a problem in v4.1 but it works fine in my machine. Please try this attached version.