Here is some additional information about the problem:
Such kind of issue is complicated and only occurs for some special combinations of different functions, so it is impossible for us to make our test cases cover all scenarios in the real world. We keep improving our formula parser to make it work in the similar way as in MS Excel, however, the rules for working with formulas in MS Excel are varied for different formulas and are hard to be identified.
Commonly such kind of issue is caused by some internal data of some function used in the formula. When one bug is found, we make changes for the function data of the formula and surely make the fix work fine for all existing cases. However, the change we do for the function data to fix the bug may be incorrect for some other special formulas in the real world which uses this function in some other sequence and combination with other functions.
If you find such kind of issue for other formulas, please provide the formulas and we will test and check whether we can reproduce the issue by the formula itself. If the issue cannot be reproduced, then we will require more details, such as template file, executable code, etc., to investigate the issue further.