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/hssf/usermodel/HSSFConditionalFormattingRule.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.hssf.usermodel; import org.apache.poi.hssf.model.HSSFFormulaParser; import org.apache.poi.hssf.record.CFRule12Record; import org.apache.poi.hssf.record.CFRuleBase; import org.apache.poi.hssf.record.CFRuleBase.ComparisonOperator; import org.apache.poi.hssf.record.cf.BorderFormatting; import org.apache.poi.hssf.record.cf.ColorGradientFormatting; import org.apache.poi.hssf.record.cf.DataBarFormatting; import org.apache.poi.hssf.record.cf.FontFormatting; import org.apache.poi.hssf.record.cf.IconMultiStateFormatting; import org.apache.poi.hssf.record.cf.PatternFormatting; import org.apache.poi.ss.formula.ptg.Ptg; import org.apache.poi.ss.usermodel.ConditionFilterData; import org.apache.poi.ss.usermodel.ConditionFilterType; import org.apache.poi.ss.usermodel.ConditionType; import org.apache.poi.ss.usermodel.ConditionalFormattingRule; import org.apache.poi.ss.usermodel.ExcelNumberFormat; /** * * High level representation of Conditional Formatting Rule. * It allows to specify formula based conditions for the Conditional Formatting * and the formatting settings such as font, border and pattern. */ @SuppressWarnings("unused") public final class HSSFConditionalFormattingRule implements ConditionalFormattingRule { private static final byte CELL_COMPARISON = CFRuleBase.CONDITION_TYPE_CELL_VALUE_IS; private final CFRuleBase cfRuleRecord; private final HSSFWorkbook workbook; private final HSSFSheet sheet; HSSFConditionalFormattingRule(HSSFSheet pSheet, CFRuleBase pRuleRecord) { if (pSheet == null) { throw new IllegalArgumentException("pSheet must not be null"); } if (pRuleRecord == null) { throw new IllegalArgumentException("pRuleRecord must not be null"); } sheet = pSheet; workbook = pSheet.getWorkbook(); cfRuleRecord = pRuleRecord; } /** * Only newer style formatting rules have priorities. For older ones, * we don't know priority for these, other than definition/model order, * which appears to be what Excel uses. */ @Override public int getPriority() { CFRule12Record rule12 = getCFRule12Record(false); if (rule12 == null) return 0; return rule12.getPriority(); } /** * Always true for HSSF files, per Microsoft Excel documentation */ @Override public boolean getStopIfTrue() { return true; } CFRuleBase getCfRuleRecord() { return cfRuleRecord; } private CFRule12Record getCFRule12Record(boolean create) { if (cfRuleRecord instanceof CFRule12Record) { return (CFRule12Record) cfRuleRecord; } if (create) { throw new IllegalArgumentException("Can't convert a CF into a CF12 record"); } return null; } /** * Always null for HSSF records, until someone figures out where to find it */ @Override public ExcelNumberFormat getNumberFormat() { return null; } private HSSFFontFormatting getFontFormatting(boolean create) { FontFormatting fontFormatting = cfRuleRecord.getFontFormatting(); if (fontFormatting == null) { if (!create) return null; fontFormatting = new FontFormatting(); cfRuleRecord.setFontFormatting(fontFormatting); } return new HSSFFontFormatting(cfRuleRecord, workbook); } /** * @return - font formatting object if defined, {@code null} otherwise */ @Override public HSSFFontFormatting getFontFormatting() { return getFontFormatting(false); } /** * create a new font formatting structure if it does not exist, * otherwise just return existing object. * @return - font formatting object, never returns {@code null}. */ @Override public HSSFFontFormatting createFontFormatting() { return getFontFormatting(true); } private HSSFBorderFormatting getBorderFormatting(boolean create) { BorderFormatting borderFormatting = cfRuleRecord.getBorderFormatting(); if (borderFormatting == null) { if (!create) return null; borderFormatting = new BorderFormatting(); cfRuleRecord.setBorderFormatting(borderFormatting); } return new HSSFBorderFormatting(cfRuleRecord, workbook); } /** * @return - border formatting object if defined, {@code null} otherwise */ @Override public HSSFBorderFormatting getBorderFormatting() { return getBorderFormatting(false); } /** * create a new border formatting structure if it does not exist, * otherwise just return existing object. * @return - border formatting object, never returns {@code null}. */ @Override public HSSFBorderFormatting createBorderFormatting() { return getBorderFormatting(true); } private HSSFPatternFormatting getPatternFormatting(boolean create) { PatternFormatting patternFormatting = cfRuleRecord.getPatternFormatting(); if (patternFormatting == null) { if (!create) return null; patternFormatting = new PatternFormatting(); cfRuleRecord.setPatternFormatting(patternFormatting); } return new HSSFPatternFormatting(cfRuleRecord, workbook); } /** * @return - pattern formatting object if defined, {@code null} otherwise */ @Override public HSSFPatternFormatting getPatternFormatting() { return getPatternFormatting(false); } /** * create a new pattern formatting structure if it does not exist, * otherwise just return existing object. * @return - pattern formatting object, never returns {@code null}. */ @Override public HSSFPatternFormatting createPatternFormatting() { return getPatternFormatting(true); } private HSSFDataBarFormatting getDataBarFormatting(boolean create) { CFRule12Record cfRule12Record = getCFRule12Record(create); if (cfRule12Record == null) return null; DataBarFormatting databarFormatting = cfRule12Record.getDataBarFormatting(); if (databarFormatting == null) { if (!create) return null; cfRule12Record.createDataBarFormatting(); } return new HSSFDataBarFormatting(cfRule12Record, sheet); } /** * @return databar / data-bar formatting object if defined, {@code null} otherwise */ @Override public HSSFDataBarFormatting getDataBarFormatting() { return getDataBarFormatting(false); } /** * create a new databar / data-bar formatting object if it does not exist, * otherwise just return the existing object. */ public HSSFDataBarFormatting createDataBarFormatting() { return getDataBarFormatting(true); } private HSSFIconMultiStateFormatting getMultiStateFormatting(boolean create) { CFRule12Record cfRule12Record = getCFRule12Record(create); if (cfRule12Record == null) return null; IconMultiStateFormatting iconFormatting = cfRule12Record.getMultiStateFormatting(); if (iconFormatting == null) { if (!create) return null; cfRule12Record.createMultiStateFormatting(); } return new HSSFIconMultiStateFormatting(cfRule12Record, sheet); } /** * @return icon / multi-state formatting object if defined, {@code null} otherwise */ @Override public HSSFIconMultiStateFormatting getMultiStateFormatting() { return getMultiStateFormatting(false); } /** * create a new icon / multi-state formatting object if it does not exist, * otherwise just return the existing object. */ public HSSFIconMultiStateFormatting createMultiStateFormatting() { return getMultiStateFormatting(true); } private HSSFColorScaleFormatting getColorScaleFormatting(boolean create) { CFRule12Record cfRule12Record = getCFRule12Record(create); if (cfRule12Record == null) return null; ColorGradientFormatting colorFormatting = cfRule12Record.getColorGradientFormatting(); if (colorFormatting == null) { if (!create) return null; cfRule12Record.createColorGradientFormatting(); } return new HSSFColorScaleFormatting(cfRule12Record, sheet); } /** * @return color scale / gradient formatting object if defined, {@code null} otherwise */ @Override public HSSFColorScaleFormatting getColorScaleFormatting() { return getColorScaleFormatting(false); } /** * create a new color scale / gradient formatting object if it does not exist, * otherwise just return the existing object. */ public HSSFColorScaleFormatting createColorScaleFormatting() { return getColorScaleFormatting(true); } /** * @return - the conditiontype for the cfrule */ @Override public ConditionType getConditionType() { byte code = cfRuleRecord.getConditionType(); return ConditionType.forId(code); } /** * always null (not a filter condition) or {@link ConditionFilterType#FILTER} if it is. */ @Override public ConditionFilterType getConditionFilterType() { return getConditionType() == ConditionType.FILTER ? ConditionFilterType.FILTER : null; } @Override public ConditionFilterData getFilterConfiguration() { return null; } /** * @return - the comparisionoperatation for the cfrule */ @Override public byte getComparisonOperation() { return cfRuleRecord.getComparisonOperation(); } @Override public String getFormula1() { return toFormulaString(cfRuleRecord.getParsedExpression1()); } @Override public String getFormula2() { byte conditionType = cfRuleRecord.getConditionType(); if (conditionType == CELL_COMPARISON) { byte comparisonOperation = cfRuleRecord.getComparisonOperation(); switch(comparisonOperation) { case ComparisonOperator.BETWEEN: case ComparisonOperator.NOT_BETWEEN: return toFormulaString(cfRuleRecord.getParsedExpression2()); } } return null; } @Override public String getText() { return null; // not available here, unless it exists and is unimplemented in cfRuleRecord } String toFormulaString(Ptg[] parsedExpression) { return toFormulaString(parsedExpression, workbook); } static String toFormulaString(Ptg[] parsedExpression, HSSFWorkbook workbook) { if(parsedExpression == null || parsedExpression.length == 0) { return null; } return HSSFFormulaParser.toFormulaString(workbook, parsedExpression); } /** * Conditional format rules don't define stripes, so always 0 * @see org.apache.poi.ss.usermodel.DifferentialStyleProvider#getStripeSize() */ @Override public int getStripeSize() { return 0; } }
⏎ org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.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, 78963👍, 0💬
Popular Posts:
JDK 11 jdk.compiler.jmod is the JMOD file for JDK 11 Compiler tool, which can be invoked by the "jav...
Jaxen, Release 1.1.1, is an open source XPath library written in Java. It is adaptable to many diffe...
commons-lang-2.6.jar is the JAR file for Apache Commons Lang 2.6, which provides a host of helper ut...
How to read XML document from socket connections with the socket\DelayedInput.java provided in the A...
What Is activation.jar? I heard it's related to JAF (JavaBeans Activation Framework) 1.1? The if you...