See <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/236/display/redirect?page=changes>
Changes: [PJ Fanning] SUMIFS should sum and treat booleans and strings as zero [PJ Fanning] SUMIFS should not sum if a value is #N/A [PJ Fanning] test sum with N/A [PJ Fanning] [bug-65475] SUMIF should return #N/A if any of the amounts to sum is #N/A. Thanks to zhangyajun. [PJ Fanning] fix issue with test [PJ Fanning] add disabled SUMIF test [PJ Fanning] add disabled SUMIF test [PJ Fanning] add SUMIF tests disabling one that shows we have a bug ------------------------------------------ [...truncated 391.61 KB...] [javadoc] protected abstract void saveImpl(OutputStream outputStream) [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\OPCPackage.java>:1543: warning: no @throws for org.apache.poi.openxml4j.exceptions.InvalidFormatException [javadoc] protected abstract PackagePartCollection getPartsImpl() [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\OPCPackage.java>:1650: warning: no @return [javadoc] public abstract boolean isClosed(); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\RelationshipSource.java>:114: warning: no @throws for org.apache.poi.openxml4j.exceptions.OpenXML4JException [javadoc] PackageRelationshipCollection getRelationships() throws OpenXML4JException; [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:52: warning: no @param for category [javadoc] void setCategoryProperty(String category); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:58: warning: no @param for category [javadoc] void setCategoryProperty(Optional<String> category); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:69: warning: no @param for contentStatus [javadoc] void setContentStatusProperty(String contentStatus); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:75: warning: no @param for contentStatus [javadoc] void setContentStatusProperty(Optional<String> contentStatus); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:88: warning: no @param for contentType [javadoc] void setContentTypeProperty(String contentType); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:95: warning: no @param for contentType [javadoc] void setContentTypeProperty(Optional<String> contentType); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:106: warning: no @param for created [javadoc] void setCreatedProperty(String created); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:111: warning: no @param for created [javadoc] void setCreatedProperty(Optional<Date> created); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:124: warning: no @param for creator [javadoc] void setCreatorProperty(String creator); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:131: warning: no @param for creator [javadoc] void setCreatorProperty(Optional<String> creator); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:136: warning: no @return [javadoc] Optional<String> getDescriptionProperty(); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:141: warning: no @param for description [javadoc] void setDescriptionProperty(String description); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:147: warning: no @param for description [javadoc] void setDescriptionProperty(Optional<String> description); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:158: warning: no @param for identifier [javadoc] void setIdentifierProperty(String identifier); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:164: warning: no @param for identifier [javadoc] void setIdentifierProperty(Optional<String> identifier); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:179: warning: no @param for keywords [javadoc] void setKeywordsProperty(String keywords); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:187: warning: no @param for keywords [javadoc] void setKeywordsProperty(Optional<String> keywords); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:198: warning: no @param for language [javadoc] void setLanguageProperty(String language); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:204: warning: no @param for language [javadoc] void setLanguageProperty(Optional<String> language); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:209: warning: no @return [javadoc] Optional<String> getLastModifiedByProperty(); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:214: warning: no @param for lastModifiedBy [javadoc] void setLastModifiedByProperty(String lastModifiedBy); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:220: warning: no @param for lastModifiedBy [javadoc] void setLastModifiedByProperty(Optional<String> lastModifiedBy); [javadoc] ^ [javadoc] <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/poi-ooxml\src\main\java\org\apache\poi\openxml4j\opc\PackageProperties.java>:231: warning: no @param for lastPrinted [javadoc] void setLastPrintedProperty(String lastPrinted); [javadoc] ^ [javadoc] 100 warnings [jar] Building jar: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\maven\poi-ooxml\poi-ooxml-5.0.1-SNAPSHOT-javadoc.jar> assemble: [zip] Building zip: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\poi-bin-5.0.1-SNAPSHOT-20210730.zip> [tar] Building tar: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\poi-bin-5.0.1-SNAPSHOT-20210730.tar.gz> [zip] Building zip: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\poi-src-5.0.1-SNAPSHOT-20210730.zip> [tar] Building tar: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\poi-src-5.0.1-SNAPSHOT-20210730.tar.gz> [echo] Creating Maven POMs maven-poms: [copy] Copying 7 files to <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist\maven> [echo] Maven POMs are located in <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist> [echo] Use ant dist-nexus to deploy the artifacts in the remote repository [echo] Distribution located in <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist> [echo] Use "ant dist-checksum" to create sha256/sha512 checksums and GPG signatures findbugs: [mkdir] Created dir: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\config> [get] Getting: https://repo1.maven.org/maven2/com/github/spotbugs/spotbugs/4.2.0/spotbugs-4.2.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\spotbugs.jar> [get] Getting: https://repo1.maven.org/maven2/com/github/spotbugs/spotbugs-ant/4.2.0/spotbugs-ant-4.2.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\spotbugs-ant.jar> [get] Getting: https://repo1.maven.org/maven2/com/github/spotbugs/spotbugs-annotations/4.2.0/spotbugs-annotations-4.2.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\spotbugs-annotations.jar> [get] Getting: https://repo1.maven.org/maven2/org/dom4j/dom4j/2.1.3/dom4j-2.1.3.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\dom4j-2.1.3.jar> [get] Getting: https://repo1.maven.org/maven2/jaxen/jaxen/1.2.0/jaxen-1.2.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\jaxen-1.2.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/bcel/bcel/6.5.0/bcel-6.5.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\bcel-6.5.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/slf4j/slf4j-api/1.8.0-beta4/slf4j-api-1.8.0-beta4.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\slf4j-api-1.8.0-beta4.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/commons/commons-lang3/3.11/commons-lang3-3.11.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\commons-lang3-3.11.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/commons/commons-text/1.9/commons-text-1.9.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\commons-text-1.9.jar> [get] Getting: https://repo1.maven.org/maven2/net/jcip/jcip-annotations/1.0/jcip-annotations-1.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\jcip-annotations-1.0.jar> [get] Getting: https://repo1.maven.org/maven2/com/google/code/findbugs/jsr305/3.0.2/jsr305-3.0.2.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\jsr305-3.0.2.jar> [get] Getting: https://repo1.maven.org/maven2/org/ow2/asm/asm/9.0/asm-9.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\asm-9.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/ow2/asm/asm-analysis/9.0/asm-analysis-9.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\asm-analysis-9.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/ow2/asm/asm-commons/9.0/asm-commons-9.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\asm-commons-9.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/ow2/asm/asm-tree/9.0/asm-tree-9.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\asm-tree-9.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/ow2/asm/asm-util/9.0/asm-util-9.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\asm-util-9.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/logging/log4j/log4j-api/2.14.0/log4j-api-2.14.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\log4j-api-2.14.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/logging/log4j/log4j-core/2.14.0/log4j-core-2.14.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\log4j-core-2.14.0.jar> [get] Getting: https://repo1.maven.org/maven2/org/apache/logging/log4j/log4j-slf4j18-impl/2.14.0/log4j-slf4j18-impl-2.14.0.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\log4j-slf4j18-impl-2.14.0.jar> [get] Getting: https://repo1.maven.org/maven2/net/sf/saxon/Saxon-HE/9.9.1-8/Saxon-HE-9.9.1-8.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\Saxon-HE-9.9.1-8.jar> [get] Getting: https://repo1.maven.org/maven2/com/ibm/icu/icu4j/68.2/icu4j-68.2.jar [get] To: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs\lib\icu4j-63.1.jar> [spotbugs] Executing SpotBugs FindBugsTask from ant task [spotbugs] Running SpotBugs... [spotbugs] Java Result: 1 [spotbugs] Output saved to build/findbugs.xml [xslt] Transforming into <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build> [xslt] Processing <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs.xml> to <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\findbugs.html> [xslt] Loading stylesheet jar:<https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build/findbugs/lib/spotbugs.jar!/fancy.xsl> release-notes: [copy] Copying 1 file to <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\dist> rat-check: [mkdir] Created dir: <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build\rat> [echo] [echo] ***************************************************** [echo] Summary [echo] ------- [echo] Generated at: 2021-07-30T06:18:10-07:00 [echo] [echo] Notes: 0 [echo] Binaries: 113 [echo] Archives: 0 [echo] Standards: 3662 [echo] [echo] Apache Licensed: 3661 [echo] Generated Documents: 0 [echo] [echo] JavaDocs are generated, thus a license header is optional. [echo] Generated files do not require license headers. [echo] [echo] 1 Unknown Licenses [echo] [echo] ***************************************************** [echo] [echo] Files with unapproved licenses: [echo] [echo] f:/jenkins/jenkins-slave/712657a4/workspace/POI/POI-DSL-Windows-1.8/poi/src/test/java/org/apache/poi/ss/util/Utils.java [echo] [echo] ***************************************************** [echo] [echo] ***************************************************** [echo] Files with Apache License headers will be marked AL [echo] Binary files (which do not require any license headers) will be marked B [echo] Compressed archives will be marked A [echo] Notices, licenses etc. will be marked N [echo] !????? f:/jenkins/jenkins-slave/712657a4/workspace/POI/POI-DSL-Windows-1.8/poi/src/test/java/org/apache/poi/ss/util/Utils.java [echo] [echo] ***************************************************** [echo] [echo] Printing headers for text files without a valid license header... [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/712657a4/workspace/POI/POI-DSL-Windows-1.8/poi/src/test/java/org/apache/poi/ss/util/Utils.java [echo] ===================================================== [echo] package org.apache.poi.ss.util; [echo] [echo] import org.apache.poi.ss.usermodel.Cell; [echo] import org.apache.poi.ss.usermodel.FormulaError; [echo] import org.apache.poi.ss.usermodel.Row; [echo] import org.apache.poi.ss.usermodel.Sheet; [echo] [echo] import java.time.LocalDate; [echo] import java.time.LocalDateTime; [echo] import java.util.Calendar; [echo] import java.util.Date; [echo] [echo] public class Utils { [echo] public static void addRow(Sheet sheet, int rownum, Object... values) { [echo] Row row = sheet.createRow(rownum); [echo] for (int i = 0; i < values.length; i++) { [echo] Cell cell = row.createCell(i); [echo] if (values[i] instanceof Integer) { [echo] cell.setCellValue((Integer) values[i]); [echo] } else if (values[i] instanceof Double) { [echo] cell.setCellValue((Double) values[i]); [echo] } else if (values[i] instanceof Boolean) { [echo] cell.setCellValue((Boolean) values[i]); [echo] } else if (values[i] instanceof Calendar) { [echo] cell.setCellValue((Calendar) values[i]); [echo] } else if (values[i] instanceof Date) { [echo] cell.setCellValue((Date) values[i]); [echo] } else if (values[i] instanceof LocalDate) { [echo] cell.setCellValue((LocalDate) values[i]); [echo] } else if (values[i] instanceof LocalDateTime) { [echo] cell.setCellValue((LocalDateTime) values[i]); [echo] } else if (values[i] instanceof FormulaError) { [echo] cell.setCellErrorValue(((FormulaError)values[i]).getCode()); [echo] } else if (values[i] == null) { [echo] cell.setBlank(); [echo] } else { [echo] cell.setCellValue(values[i].toString()); [echo] } [echo] } [echo] } [echo] [echo] } BUILD FAILED <https://ci-builds.apache.org/job/POI/job/POI-DSL-Windows-1.8/ws/build.xml>:2539: condition satisfied Total time: 27 minutes 3 seconds Build step 'Invoke Ant' marked build as failure [SpotBugs] Skipping execution of recorder since overall result is 'FAILURE' Archiving artifacts [Fast Archiver] Compressed 222.74 MB of artifacts by 29.3% relative to #235 Skipping publisher since build result is FAILURE Recording test results [Checks API] No suitable checks publisher found. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
