See <https://ci-builds.apache.org/job/POI/job/POI-DSL-1.18/32/display/redirect?page=changes>
Changes: [PJ Fanning] support sqrtpi function [PJ Fanning] support sqrtpi function [PJ Fanning] support lcm function [PJ Fanning] support gcd function [PJ Fanning] support gcd function [PJ Fanning] support gcd function [PJ Fanning] support gcd function [PJ Fanning] reformat [PJ Fanning] make HPSF limit more configuarble [PJ Fanning] update changes [PJ Fanning] fix broken test [PJ Fanning] reformat [PJ Fanning] add broken test that prvis new averageif code is incorrect [PJ Fanning] reformat [PJ Fanning] [github-330] add averageif function support [PJ Fanning] [bug-66039] remove stray </p> [PJ Fanning] [bug-66039] add more javadoc about setCellFormulaValidation [PJ Fanning] update legal copyright [PJ Fanning] update changes [PJ Fanning] small big decimal refactor [PJ Fanning] [bug-66047] change mround implementation due to issue - thanks to @fabio [PJ Fanning] [bug-66039] show use of setCellFormulaValidation=false in a test [PJ Fanning] update github actions [PJ Fanning] [github-325] Update GithubActions permissions. Thanks to @nathannaveen. This closes #325 ------------------------------------------ [...truncated 396.72 KB...] WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports > Task :poi-examples:spotbugsTest The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) > Task :poi:spotbugsMain M P UrF: Unread field: org.apache.poi.hpsf.Decimal.field_5_lo64 At Decimal.java:[line 38] M P UrF: Unread field: org.apache.poi.hpsf.Decimal.field_2_scale At Decimal.java:[line 35] M P SS: Unread field: org.apache.poi.ss.formula.ptg.UnknownPtg.size; should this field be static? At UnknownPtg.java:[line 25] M P UrF: Unread field: org.apache.poi.hssf.usermodel.HSSFChart.chartTitleFormat At HSSFChart.java:[line 217] M P UrF: Unread field: org.apache.poi.ss.formula.atp.TextJoinFunction.evaluator At TextJoinFunction.java:[line 51] M P UrF: Unread field: org.apache.poi.hpsf.Decimal.field_4_hi32 At Decimal.java:[line 37] M P UrF: Unread field: org.apache.poi.ss.formula.atp.PercentRankIncFunction.evaluator At PercentRankIncFunction.java:[line 51] M P UrF: Unread field: org.apache.poi.hpsf.Decimal.field_1_wReserved At Decimal.java:[line 34] M P UrF: Unread field: org.apache.poi.ss.formula.atp.PercentRankExcFunction.evaluator At PercentRankExcFunction.java:[line 55] M P UrF: Unread field: org.apache.poi.hpsf.Decimal.field_3_sign At Decimal.java:[line 36] M V MS: org.apache.poi.hpsf.VariantSupport.SUPPORTED_TYPES should be package protected At VariantSupport.java:[line 55] M V MS: org.apache.poi.hpsf.DocumentSummaryInformation.FORMAT_ID should be package protected At DocumentSummaryInformation.java:[line 51] M V MS: org.apache.poi.ss.formula.eval.FunctionEval.functions should be package protected At FunctionEval.java:[line 59] M M IS: Inconsistent synchronization of org.apache.poi.poifs.filesystem.DocumentInputStream._current_block_count; locked 71% of time Unsynchronized access at DocumentInputStream.java:[line 287] M M IS: Inconsistent synchronization of org.apache.poi.ss.format.CellDateFormatter.sFmt; locked 66% of time Unsynchronized access at CellDateFormatter.java:[line 109] M M IS: Inconsistent synchronization of org.apache.poi.ss.format.CellDateFormatter.amPmUpper; locked 50% of time Unsynchronized access at CellDateFormatter.java:[line 122] M M IS: Inconsistent synchronization of org.apache.poi.poifs.filesystem.DocumentInputStream._buffer; locked 50% of time Unsynchronized access at DocumentInputStream.java:[line 286] M M IS: Inconsistent synchronization of org.apache.poi.hpsf.ClassIDPredefined.classId; locked 66% of time Unsynchronized access at ClassIDPredefined.java:[line 132] M M IS: Inconsistent synchronization of org.apache.poi.poifs.filesystem.DocumentInputStream._data; locked 80% of time Unsynchronized access at DocumentInputStream.java:[line 288] The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) SpotBugs ended with exit code 1 > Task :poi-examples:test TestXLSX2CSV > testSampleFile() FAILED org.opentest4j.AssertionFailedError at TestXLSX2CSV.java:90 4 tests completed, 1 failed [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 39 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 43 started executing tests. > Task :poi-integration:test WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 40 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 41 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 42 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 44 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 43 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 41 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 45 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 27 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 42 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 40 finished executing tests. > Task :poi-examples:test FAILED > Task :poi-excelant:spotbugsMain The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) SpotBugs ended with exit code 1 > Task :poi-integration:test WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 34 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 44 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 33 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 45 finished executing tests. > Task :poi-integration:test WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports WARNING: Unknown module: org.junit.platform.commons specified to --add-exports > Task :poi-excelant:spotbugsTest The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 46 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 46 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 47 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 38 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 48 started executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 47 finished executing tests. > Task :poi-integration:spotbugsTest M C RCN: Nullcheck of read at line 59 of value previously dereferenced in org.apache.poi.stress.SlideShowHandler.handleSlideShow(SlideShow) At SlideShowHandler.java:[line 59] [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 48 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 31 finished executing tests. [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 49 started executing tests. > Task :poi-integration:spotbugsTest M C RCN: Nullcheck of wb at line 50 of value previously dereferenced in org.apache.poi.stress.StressMap.load(File) At StressMap.java:[line 50] [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 49 finished executing tests. > Task :poi-integration:spotbugsTest M V MS: org.apache.poi.stress.AbstractFileHandler.EXPECTED_EXTRACTOR_FAILURES is a mutable collection which should be package protected At AbstractFileHandler.java:[line 48] M V MS: org.apache.poi.stress.TestAllFiles.SCAN_EXCLUDES should be package protected At TestAllFiles.java:[line 76] M V MS: org.apache.poi.stress.TestAllFiles.SCAN_EXCLUDES_NOSCRATCHPAD should be package protected At TestAllFiles.java:[line 92] The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) SpotBugs ended with exit code 1 > Task :poi-examples:spotbugsMain M V EI2: new org.apache.poi.examples.hwpf.Word2Forrest(HWPFDocument, OutputStream) may expose internal representation by storing an externally mutable object into Word2Forrest._doc At Word2Forrest.java:[line 46] H B Nm: The class name org.apache.poi.examples.hssf.usermodel.AddDimensionedImage shadows the simple name of the superclass org.apache.poi.examples.ss.AddDimensionedImage At AddDimensionedImage.java:[line 29] M D RCN: Redundant nullcheck of wb which is known to be null in org.apache.poi.examples.ss.CellStyleDetails.main(String[]) Redundant null check at CellStyleDetails.java:[line 90] M D RCN: Redundant nullcheck of wb, which is known to be non-null in org.apache.poi.examples.ss.CellStyleDetails.main(String[]) Redundant null check at CellStyleDetails.java:[line 90] M D NP: Load of known null value in org.apache.poi.examples.ss.CellStyleDetails.main(String[]) At CellStyleDetails.java:[line 90] M V EI2: org.apache.poi.examples.hssf.usermodel.EventExample.processRecord(Record) may expose internal representation by storing an externally mutable object into EventExample.sstrec At EventExample.java:[line 80] M D SF: Switch statement found in org.apache.poi.examples.hssf.usermodel.EventExample.processRecord(Record) where default case is missing At EventExample.java:[lines 50-88] M D RCN: Redundant nullcheck of workbook, which is known to be non-null in org.apache.poi.examples.ss.formula.UserDefinedFunctionExample.main(String[]) Redundant null check at UserDefinedFunctionExample.java:[line 82] M D RCN: Redundant nullcheck of workbook which is known to be null in org.apache.poi.examples.ss.formula.UserDefinedFunctionExample.main(String[]) Redundant null check at UserDefinedFunctionExample.java:[line 82] M D NP: Load of known null value in org.apache.poi.examples.ss.formula.UserDefinedFunctionExample.main(String[]) At UserDefinedFunctionExample.java:[line 82] M V EI2: new org.apache.poi.examples.hssf.eventusermodel.XLS2CSVmra(POIFSFileSystem, PrintStream, int) may expose internal representation by storing an externally mutable object into XLS2CSVmra.output At XLS2CSVmra.java:[line 92] M V EI2: org.apache.poi.examples.hssf.eventusermodel.XLS2CSVmra.processRecord(Record) may expose internal representation by storing an externally mutable object into XLS2CSVmra.sstRecord At XLS2CSVmra.java:[line 172] M V EI2: new org.apache.poi.examples.hssf.eventusermodel.XLS2CSVmra(POIFSFileSystem, PrintStream, int) may expose internal representation by storing an externally mutable object into XLS2CSVmra.fs At XLS2CSVmra.java:[line 91] M V EI2: new org.apache.poi.examples.ss.html.HSSFHtmlHelper(HSSFWorkbook) may expose internal representation by storing an externally mutable object into HSSFHtmlHelper.wb At HSSFHtmlHelper.java:[line 38] M V EI: org.apache.poi.examples.hssf.usermodel.InCellLists$MultiLevelListItem.getLowerLevelItems() may expose internal representation by returning InCellLists$MultiLevelListItem.lowerLevelItems At InCellLists.java:[line 536] M V EI2: new org.apache.poi.examples.hssf.usermodel.InCellLists$MultiLevelListItem(String, List) may expose internal representation by storing an externally mutable object into InCellLists$MultiLevelListItem.lowerLevelItems At InCellLists.java:[line 516] M V EI2: new org.apache.poi.examples.xssf.eventusermodel.XLSX2CSV(OPCPackage, PrintStream, int) may expose internal representation by storing an externally mutable object into XLSX2CSV.xlsxPackage At XLSX2CSV.java:[line 181] M V EI2: new org.apache.poi.examples.xssf.eventusermodel.XLSX2CSV(OPCPackage, PrintStream, int) may expose internal representation by storing an externally mutable object into XLSX2CSV.output At XLSX2CSV.java:[line 182] > Task :poi:javadoc 2 warnings > Task :poi-examples:spotbugsMain M V EI2: new org.apache.poi.examples.ss.formula.CheckFunctionsSupported(Workbook) may expose internal representation by storing an externally mutable object into CheckFunctionsSupported.workbook At CheckFunctionsSupported.java:[line 103] M C UwF: Unwritten field: org.apache.poi.examples.hssf.eventusermodel.XLS2CSVmra.workbookBuildingListener At XLS2CSVmra.java:[line 151] M P SS: Unread field: org.apache.poi.examples.hssf.eventusermodel.XLS2CSVmra.outputFormulaValues; should this field be static? At XLS2CSVmra.java:[line 64] The following errors occurred during analysis: Unable to construct type qualifier checker javax/annotation/Nonnull$Checker java.lang.UnsupportedOperationException: The Security Manager is deprecated and will be removed in a future release At java.base/java.lang.System.setSecurityManager(System.java:416) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.<init>(TypeQualifierValue.java:157) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:298) At edu.umd.cs.findbugs.ba.jsr305.TypeQualifierValue.getValue(TypeQualifierValue.java:306) At edu.umd.cs.findbugs.ba.npe.TypeQualifierNullnessAnnotationDatabase.<init>(TypeQualifierNullnessAnnotationDatabase.java:70) At edu.umd.cs.findbugs.ba.AnalysisContext.getNullnessAnnotationDatabase(AnalysisContext.java:1055) At edu.umd.cs.findbugs.ba.AnalysisContext.updateDatabases(AnalysisContext.java:1008) At edu.umd.cs.findbugs.FindBugs2.analyzeApplication(FindBugs2.java:1061) At edu.umd.cs.findbugs.FindBugs2.execute(FindBugs2.java:309) At edu.umd.cs.findbugs.FindBugs.runMain(FindBugs.java:395) At edu.umd.cs.findbugs.FindBugs2.main(FindBugs2.java:1231) SpotBugs ended with exit code 1 [Test worker] INFO org.gradle.api.internal.tasks.testing.worker.TestWorker - Gradle Test Executor 39 finished executing tests. FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':poi-examples:test'. > There were failing tests. See the report at: > file://<https://ci-builds.apache.org/job/POI/job/POI-DSL-1.18/ws/poi-examples/build/reports/tests/test/index.html> * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. * Get more help at https://help.gradle.org Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0. You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins. See https://docs.gradle.org/7.4.1/userguide/command_line_interface.html#sec:command_line_warnings Execution optimizations have been disabled for 1 invalid unit(s) of work during this build to ensure correctness. Please consult deprecation warnings for more details. BUILD FAILED in 12m 21s 95 actionable tasks: 93 executed, 2 up-to-date Build step 'Invoke Gradle script' changed build result to FAILURE Build step 'Invoke Gradle script' marked build as failure [SpotBugs] Skipping execution of recorder since overall result is 'FAILURE' Archiving artifacts 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