Hi, I've been looking at implementing XLookup function. I have a very partial implementation at https://github.com/apache/poi/pull/243.
One issue is examples like Example 2 in https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929. In the unit test for that example in the pull request, I try to add the XLOOKUP formula as an array function but the formula evaluator sticks the first column value in the matched row in both cells as opposed to putting the second column value in the second cell. I'm not an expert on how POI evaluates formulas and I'm not sure whether array formula is the way to go in the first place. Is there anyone who is interested in working through this with me? Regards. PJ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
