You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/12/02 19:40:42 UTC
svn commit: r1895500 - /poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java
Author: fanningpj
Date: Thu Dec 2 19:40:42 2021
New Revision: 1895500
URL: http://svn.apache.org/viewvc?rev=1895500&view=rev
Log:
[github-243] basic version of XLookup
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java
Modified: poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java?rev=1895500&r1=1895499&r2=1895500&view=diff
==============================================================================
--- poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java (original)
+++ poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java Thu Dec 2 19:40:42 2021
@@ -29,12 +29,11 @@ import java.util.Optional;
/**
* Implementation of Excel function XLOOKUP()
*
- * POI does not currently support having return values with multiple columns and just takes the first cell
- * right now.
- *
* <b>Syntax</b><br>
* <b>XLOOKUP</b>(<b>lookup_value</b>, <b>lookup_array</b>, <b>return_array</b>, <b>[if_not_found]</b>, <b>[match_mode]</b>, <b>[search_mode]</b>)<p>
*
+ * https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929
+ *
* @since POI 5.2.0
*/
final class XLookupFunction implements FreeRefFunction, ArrayFunction {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org