https://bz.apache.org/bugzilla/show_bug.cgi?id=65643
Bug ID: 65643
Summary: FILTER function wrong number of arguments
Product: POI
Version: 5.0.0-FINAL
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
>From Microsoft docs [1], FILTER function accepts between two and three
arguments, such as:
=FILTER(A5:D20,C5:C20=H2,"")
However, in Apache POI the call
'FunctionMetadataRegistry.getFunctionByName("FILTER")' returns:
result = {FunctionMetadata@8544}
"org.apache.poi.ss.formula.function.FunctionMetadata [447 FILTER]":
_index = 447
_name = "FILTER"
_minParams = 0
_maxParams = 0
_returnClassCode = 0
_parameterClassCodes = {byte[0]@10804}
Using the function as stated in Microsoft docs triggers a FormulaParseException
with message
"Too many arguments to function 'FILTER'. Expected 0 but got 2."
[1]:
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
