Author: fanningpj
Date: Mon Feb 21 10:29:06 2022
New Revision: 1898270
URL: http://svn.apache.org/viewvc?rev=1898270&view=rev
Log:
javadoc
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Sumproduct.java
Modified:
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Sumproduct.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Sumproduct.java?rev=1898270&r1=1898269&r2=1898270&view=diff
==============================================================================
---
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Sumproduct.java
(original)
+++
poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Sumproduct.java
Mon Feb 21 10:29:06 2022
@@ -51,6 +51,12 @@ import org.apache.poi.ss.formula.eval.Va
* A<b>n</b><sub>(<b>i</b>,<b>j</b>)</sub>
* )
* )
+ *
+ * <p>
+ * The current implementation does not support the more advanced use cases
of SUMPRODUCT, including
+ * <code>SUMPRODUCT((B2:B9=B12)*(C2:C9=C12)*D2:D9)</code> (see example 3 in
+ *
https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e).
+ * </p>
*/
public final class Sumproduct implements Function {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
