diff options
| author | PJ Fanning <fanningpj@apache.org> | 2021-12-02 19:40:42 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2021-12-02 19:40:42 +0000 |
| commit | 75f910ace690249cf193b08fcda91f427b9d7219 (patch) | |
| tree | 44388d7366e9500f5ef4b8b4e458cd7f3e210b86 /poi | |
| parent | c8a3870064b49ce280e87da67740696e001488fd (diff) | |
| download | poi-75f910ace690249cf193b08fcda91f427b9d7219.tar.gz poi-75f910ace690249cf193b08fcda91f427b9d7219.zip | |
[github-243] basic version of XLookup
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1895500 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi')
| -rw-r--r-- | poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java b/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java index 69f96184b5..ba86b6cec0 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/atp/XLookupFunction.java @@ -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 { |