Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
What Is poi-5.2.3.jar?
What Is poi-5.2.3.jar?
✍: FYIcenter.com
poi-5.2.3.jar is one of the JAR files for Apache POI 5.2.3, which provides an API for Microsoft document files of Word, Excel, PowerPoint, and Visio.
poi-5.2.3.jar supports Apache POI components that read and write Microsoft's OLE 2 Compound document format, which is used in early versions of Microsoft Office tools like Word 97, Excel 97, PowerPoint 97, etc.
poi-5.2.3.jar is distributed as part of the poi-bin-5.2.3-20220909.zip download file.
JAR File Size and Download Location:
JAR name: poi-5.2.3.jar Target JDK version: 9 File name: poi.jar, poi-5.2.3.jar File size: 2964641 bytes Release date: 09-09-2022 Download: Apache POI Website
Here are Java Source Code files for poi-5.2.3.jar:
⏎ org/apache/poi/ss/formula/functions/Sumproduct.java
/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.ss.formula.functions; import java.util.Arrays; import org.apache.poi.ss.formula.TwoDEval; import org.apache.poi.ss.formula.eval.AreaEval; import org.apache.poi.ss.formula.eval.BlankEval; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.EvaluationException; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.RefEval; import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; /** * Implementation for the Excel function SUMPRODUCT<p> * * Syntax : <br> * SUMPRODUCT ( array1[, array2[, array3[, ...]]]) * <table> * <caption>Parameter descriptions</caption> * <tr><th>array1, ... arrayN </th><td>typically area references, * possibly cell references or scalar values</td></tr> * </table><br> * * Let A<b>n</b><sub>(<b>i</b>,<b>j</b>)</sub> represent the element in the <b>i</b>th row <b>j</b>th column * of the <b>n</b>th array<br> * Assuming each array has the same dimensions (W, H), the result is defined as:<br> * SUMPRODUCT = Σ<sub><b>i</b>: 1..H</sub> * ( Σ<sub><b>j</b>: 1..W</sub> * ( Π<sub><b>n</b>: 1..N</sub> * 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 { @Override public ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol) { int maxN = args.length; if(maxN < 1) { return ErrorEval.VALUE_INVALID; } ValueEval firstArg = args[0]; try { if(firstArg instanceof NumericValueEval) { return evaluateSingleProduct(args); } if(firstArg instanceof RefEval) { return evaluateSingleProduct(args); } if (firstArg instanceof TwoDEval) { TwoDEval ae = (TwoDEval) firstArg; if(ae.isRow() && ae.isColumn()) { return evaluateSingleProduct(args); } return evaluateAreaSumProduct(args); } } catch (EvaluationException e) { return e.getErrorEval(); } throw new RuntimeException("Invalid arg type for SUMPRODUCT: (" + firstArg.getClass().getName() + ")"); } private static ValueEval evaluateSingleProduct(ValueEval[] evalArgs) throws EvaluationException { int maxN = evalArgs.length; double term = 1D; for (ValueEval evalArg : evalArgs) { double val = getScalarValue(evalArg); term *= val; } return new NumberEval(term); } private static double getScalarValue(ValueEval arg) throws EvaluationException { ValueEval eval; if (arg instanceof RefEval) { RefEval re = (RefEval) arg; if (re.getNumberOfSheets() > 1) { throw new EvaluationException(ErrorEval.VALUE_INVALID); } eval = re.getInnerValueEval(re.getFirstSheetIndex()); } else { eval = arg; } if (eval == null) { throw new RuntimeException("parameter may not be null"); } if (eval instanceof AreaEval) { AreaEval ae = (AreaEval) eval; // an area ref can work as a scalar value if it is 1x1 if(!ae.isColumn() || !ae.isRow()) { throw new EvaluationException(ErrorEval.VALUE_INVALID); } eval = ae.getRelativeValue(0, 0); } return getProductTerm(eval, true); } private static ValueEval evaluateAreaSumProduct(ValueEval[] evalArgs) throws EvaluationException { int maxN = evalArgs.length; TwoDEval[] args; try { args = Arrays.copyOf(evalArgs, maxN, TwoDEval[].class); } catch (ArrayStoreException e) { // one of the other args was not an AreaRef return ErrorEval.VALUE_INVALID; } TwoDEval firstArg = args[0]; int height = firstArg.getHeight(); int width = firstArg.getWidth(); // TODO - junit // first check dimensions if (!areasAllSameSize(args, height, width)) { // normally this results in #VALUE!, // but errors in individual cells take precedence for (int i = 1; i < args.length; i++) { throwFirstError(args[i]); } return ErrorEval.VALUE_INVALID; } double acc = 0; for (int rrIx=0; rrIx<height; rrIx++) { for (int rcIx=0; rcIx<width; rcIx++) { double term = 1D; for(int n=0; n<maxN; n++) { double val = getProductTerm(args[n].getValue(rrIx, rcIx), false); term *= val; } acc += term; } } return new NumberEval(acc); } private static void throwFirstError(TwoDEval areaEval) throws EvaluationException { int height = areaEval.getHeight(); int width = areaEval.getWidth(); for (int rrIx=0; rrIx<height; rrIx++) { for (int rcIx=0; rcIx<width; rcIx++) { ValueEval ve = areaEval.getValue(rrIx, rcIx); if (ve instanceof ErrorEval) { throw new EvaluationException((ErrorEval) ve); } } } } private static boolean areasAllSameSize(TwoDEval[] args, int height, int width) { for (TwoDEval areaEval : args) { // check that height and width match if (areaEval.getHeight() != height) { return false; } if (areaEval.getWidth() != width) { return false; } } return true; } /** * Determines a {@code double} value for the specified {@code ValueEval}. * @param isScalarProduct {@code false} for SUMPRODUCTs over area refs. * @throws EvaluationException if {@code ve} represents an error value. * <p> * Note - string values and empty cells are interpreted differently depending on * {@code isScalarProduct}. For scalar products, if any term is blank or a string, the * error (#VALUE!) is raised. For area (sum)products, if any term is blank or a string, the * result is zero. */ private static double getProductTerm(ValueEval ve, boolean isScalarProduct) throws EvaluationException { if(ve instanceof BlankEval || ve == null) { // TODO - shouldn't BlankEval.INSTANCE be used always instead of null? // null seems to occur when the blank cell is part of an area ref (but not reliably) if(isScalarProduct) { throw new EvaluationException(ErrorEval.VALUE_INVALID); } return 0; } if(ve instanceof ErrorEval) { throw new EvaluationException((ErrorEval)ve); } if(ve instanceof StringEval) { if(isScalarProduct) { throw new EvaluationException(ErrorEval.VALUE_INVALID); } // Note for area SUMPRODUCTs, string values are interpreted as zero // even if they would parse as valid numeric values return 0; } if(ve instanceof NumericValueEval) { NumericValueEval nve = (NumericValueEval) ve; return nve.getNumberValue(); } throw new RuntimeException("Unexpected value eval class (" + ve.getClass().getName() + ")"); } }
⏎ org/apache/poi/ss/formula/functions/Sumproduct.java
Or download all of them as a single archive file:
File name: poi-5.2.3-src.zip File size: 2479830 bytes Release date: 2022-09-09 Download
⇒ What Is poi-ooxml-5.2.3.jar?
⇐ What Is poi-bin-5.2.3-20220909.zip?
2017-04-04, 75341👍, 0💬
Popular Posts:
How to download and install Apache ZooKeeper Source Package? Apache ZooKeeper is an open-source serv...
The JMX technology provides the tools for building distributed, Web-based, modular and dynamic solut...
JDK 17 jdk.compiler.jmod is the JMOD file for JDK 17 Compiler tool, which can be invoked by the "jav...
What Is HttpComponents httpclient-4.2.2.jar? HttpComponents httpclient-4.2.2.jar is the JAR file for...
JRE 8 deploy.jar is the JAR file for JRE 8 Java Control Panel and other deploy tools. JRE (Java Runt...