Formula Parsing Error Using Union Arguments

[SlowFox71]

Reopening #503 as requested. The attachment contains a formula using a union argument which is working fine at least in my Excel365 (but has been working with previous versions of Excel as well; union arguments can be used wherever ranges are allowed).

rank.xlsx

[oleibman]

Interesting. Not sure what I was doing wrong. Thank you for opening the issue anew. Not sure when I might have an idea on how to solve it, but it is definitely an (obscure) issue.

[oleibman]

@SlowFox71 Here's a good laugh for you. I actually solved this problem while working on PR #4596. But, as I refined that PR, I found that some of the code I was introducing was no longer being executed in the test suite, so I commented it out. Search for "The following code may be a better choice" in Calculation/Calculation. Your example actually reaches the critical point, and, if I comment out the return statement there and uncomment the new code, I think it returns the correct result. Expect a new PR soon.

[oleibman]

@SlowFox71 Please test with PR #4657 if possible, with a view to adding more test cases. I won't be doing much work on it over the next couple of weeks, and it needs more tests.