From ce3371e92e873e872655c10952d10c085558583a Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Fri, 15 Jul 2022 23:23:34 +0000 Subject: [PATCH] [github-341] Remove unused imports. Thanks to XenoAmess. This closes #341 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1902760 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/examples/xslf/DoughnutChartFromScratch.java | 6 ------ .../opc/internal/EncryptedTempFilePackagePart.java | 1 - .../poi/openxml4j/opc/internal/PartUnmarshaller.java | 1 - .../xddf/usermodel/chart/XDDFNumericalDataSource.java | 3 --- .../org/apache/poi/xssf/streaming/SheetDataWriter.java | 1 - .../poi/xssf/usermodel/helpers/XSSFPasswordHelper.java | 1 - .../apache/poi/openxml4j/opc/TestPackageThumbnail.java | 2 -- .../apache/poi/poifs/crypt/tests/TestEncryptor.java | 1 - .../apache/poi/util/tests/TestIdentifierManager.java | 1 - .../usermodel/chart/TestXDDFChartRemoveSeries.java | 2 -- .../org/apache/poi/xslf/usermodel/TestPPTX2PNG.java | 1 - .../java/org/apache/poi/xssf/TestXSSFCloneSheet.java | 1 - .../org/apache/poi/xssf/model/TestStylesTable.java | 1 - .../org/apache/poi/xssf/streaming/TestSXSSFRow.java | 1 - .../apache/poi/xssf/streaming/TestSXSSFWorkbook.java | 1 - .../xssf/usermodel/TestSXSSFSheetAutosizeColumn.java | 1 - .../org/apache/poi/xssf/usermodel/TestXSSFBugs.java | 1 - .../org/apache/poi/xssf/usermodel/TestXSSFCell.java | 3 --- .../poi/xssf/usermodel/TestXSSFDataValidation.java | 1 - .../poi/xssf/usermodel/charts/TestXSSFChartTitle.java | 1 - .../usermodel/extensions/TestXSSFHeaderFooter.java | 1 - .../java/org/apache/poi/hslf/usermodel/HSLFFill.java | 1 - .../org/apache/poi/hslf/usermodel/HSLFPictureData.java | 1 - .../apache/poi/hslf/usermodel/HSLFPictureShape.java | 1 - .../org/apache/poi/hslf/usermodel/HSLFSlideShow.java | 1 - .../org/apache/poi/hsmf/datatypes/DirectoryChunk.java | 1 - .../apache/poi/hwpf/converter/WordToFoConverter.java | 3 --- .../test/java/org/apache/poi/hdgf/TestHDGFCore.java | 2 -- .../org/apache/poi/hslf/usermodel/TestBackground.java | 1 - .../src/test/java/org/apache/poi/hsmf/TestBasics.java | 1 - .../org/apache/poi/hwpf/usermodel/TestProblems.java | 1 - .../org/apache/poi/extractor/ExtractorFactory.java | 1 - .../org/apache/poi/hssf/eventmodel/ERFListener.java | 2 -- .../poi/hssf/eventusermodel/AbortableHSSFListener.java | 2 -- .../poi/hssf/eventusermodel/EventWorkbookBuilder.java | 1 - .../apache/poi/hssf/eventusermodel/HSSFListener.java | 2 -- .../apache/poi/hssf/eventusermodel/HSSFRequest.java | 1 - .../eventusermodel/MissingRecordAwareHSSFListener.java | 1 - .../org/apache/poi/hssf/model/HSSFFormulaParser.java | 1 - .../java/org/apache/poi/hssf/model/InternalSheet.java | 1 - .../org/apache/poi/hssf/model/InternalWorkbook.java | 1 - .../org/apache/poi/hssf/record/WriteAccessRecord.java | 1 - .../java/org/apache/poi/hssf/usermodel/HSSFRow.java | 1 - .../main/java/org/apache/poi/hssf/util/HSSFColor.java | 1 - .../org/apache/poi/sl/draw/geom/CurveToCommand.java | 1 - .../main/java/org/apache/poi/sl/draw/geom/GuideIf.java | 1 - .../org/apache/poi/ss/formula/EvaluationCache.java | 1 - .../poi/ss/formula/atp/PercentRankExcFunction.java | 1 - .../apache/poi/ss/formula/atp/WorkdayCalculator.java | 1 - .../org/apache/poi/ss/formula/functions/Covar.java | 1 - .../org/apache/poi/ss/formula/functions/DCountA.java | 1 - .../org/apache/poi/ss/formula/functions/DProduct.java | 4 ---- .../org/apache/poi/ss/formula/functions/IfFunc.java | 2 -- .../org/apache/poi/ss/formula/functions/Quotient.java | 1 - .../org/apache/poi/ss/usermodel/FormulaEvaluator.java | 2 -- poi/src/main/java/org/apache/poi/ss/util/CellUtil.java | 1 - .../main/java/org/apache/poi/util/CodePageUtil.java | 3 --- .../java/org/apache/poi/hssf/dev/TestBiffViewer.java | 1 - .../java/org/apache/poi/hssf/dev/TestEFBiffViewer.java | 1 - .../poi/hssf/usermodel/TestHSSFSheetShiftColumns.java | 3 --- .../poi/ss/formula/functions/TestAverageifs.java | 9 --------- .../apache/poi/ss/formula/functions/TestDollarDe.java | 2 -- .../apache/poi/ss/formula/functions/TestForecast.java | 2 -- .../org/apache/poi/ss/formula/functions/TestGcd.java | 9 --------- .../apache/poi/ss/formula/functions/TestMaxifs.java | 10 ---------- .../apache/poi/ss/formula/functions/TestMinifs.java | 10 ---------- .../apache/poi/ss/formula/functions/TestNormDist.java | 1 - .../apache/poi/ss/formula/functions/TestNormInv.java | 1 - .../apache/poi/ss/formula/functions/TestNormSDist.java | 1 - .../poi/ss/formula/functions/TestNumberValue.java | 3 --- .../apache/poi/ss/formula/functions/TestSubtotal.java | 1 - .../poi/ss/usermodel/TestExcelStyleDateFormatter.java | 3 --- .../test/java/org/apache/poi/util/TestStringUtil.java | 1 - 73 files changed, 139 deletions(-) diff --git a/poi-examples/src/main/java/org/apache/poi/examples/xslf/DoughnutChartFromScratch.java b/poi-examples/src/main/java/org/apache/poi/examples/xslf/DoughnutChartFromScratch.java index dba07cedd9..2be46b9b5f 100644 --- a/poi-examples/src/main/java/org/apache/poi/examples/xslf/DoughnutChartFromScratch.java +++ b/poi-examples/src/main/java/org/apache/poi/examples/xslf/DoughnutChartFromScratch.java @@ -21,19 +21,13 @@ package org.apache.poi.examples.xslf; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.util.Units; -import org.apache.poi.xddf.usermodel.chart.AxisCrossBetween; -import org.apache.poi.xddf.usermodel.chart.AxisCrosses; -import org.apache.poi.xddf.usermodel.chart.AxisPosition; -import org.apache.poi.xddf.usermodel.chart.AxisTickMark; import org.apache.poi.xddf.usermodel.chart.ChartTypes; import org.apache.poi.xddf.usermodel.chart.LegendPosition; -import org.apache.poi.xddf.usermodel.chart.XDDFChartAxis; import org.apache.poi.xddf.usermodel.chart.XDDFChartLegend; import org.apache.poi.xddf.usermodel.chart.XDDFDataSource; import org.apache.poi.xddf.usermodel.chart.XDDFDataSourcesFactory; import org.apache.poi.xddf.usermodel.chart.XDDFDoughnutChartData; import org.apache.poi.xddf.usermodel.chart.XDDFNumericalDataSource; -import org.apache.poi.xddf.usermodel.chart.XDDFValueAxis; import org.apache.poi.xslf.usermodel.XMLSlideShow; import org.apache.poi.xslf.usermodel.XSLFChart; import org.apache.poi.xslf.usermodel.XSLFGraphicFrame; diff --git a/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/EncryptedTempFilePackagePart.java b/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/EncryptedTempFilePackagePart.java index 1365a494dc..1ec18cf584 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/EncryptedTempFilePackagePart.java +++ b/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/EncryptedTempFilePackagePart.java @@ -28,7 +28,6 @@ import org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller; import org.apache.poi.poifs.crypt.temp.EncryptedTempData; import org.apache.poi.util.Beta; import org.apache.poi.util.IOUtils; -import org.apache.poi.util.TempFile; import java.io.*; diff --git a/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/PartUnmarshaller.java b/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/PartUnmarshaller.java index 8d31319dc2..42bd8dcd82 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/PartUnmarshaller.java +++ b/poi-ooxml/src/main/java/org/apache/poi/openxml4j/opc/internal/PartUnmarshaller.java @@ -21,7 +21,6 @@ import java.io.IOException; import java.io.InputStream; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; -import org.apache.poi.openxml4j.exceptions.OpenXML4JException; import org.apache.poi.openxml4j.opc.PackagePart; import org.apache.poi.openxml4j.opc.internal.unmarshallers.UnmarshallContext; diff --git a/poi-ooxml/src/main/java/org/apache/poi/xddf/usermodel/chart/XDDFNumericalDataSource.java b/poi-ooxml/src/main/java/org/apache/poi/xddf/usermodel/chart/XDDFNumericalDataSource.java index 95ef676462..82c573a8f9 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/xddf/usermodel/chart/XDDFNumericalDataSource.java +++ b/poi-ooxml/src/main/java/org/apache/poi/xddf/usermodel/chart/XDDFNumericalDataSource.java @@ -20,9 +20,6 @@ package org.apache.poi.xddf.usermodel.chart; import org.apache.poi.util.Beta; -import org.apache.poi.util.Internal; -import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumData; -import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumVal; @Beta public interface XDDFNumericalDataSource extends XDDFDataSource { diff --git a/poi-ooxml/src/main/java/org/apache/poi/xssf/streaming/SheetDataWriter.java b/poi-ooxml/src/main/java/org/apache/poi/xssf/streaming/SheetDataWriter.java index 0477a747cd..9352ebe133 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/xssf/streaming/SheetDataWriter.java +++ b/poi-ooxml/src/main/java/org/apache/poi/xssf/streaming/SheetDataWriter.java @@ -44,7 +44,6 @@ import org.apache.poi.util.CodepointsUtil; import org.apache.poi.util.Removal; import org.apache.poi.util.TempFile; import org.apache.poi.xssf.model.SharedStringsTable; -import org.apache.poi.xssf.usermodel.XSSFRichTextString; import org.openxmlformats.schemas.spreadsheetml.x2006.main.STCellType; /** diff --git a/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/helpers/XSSFPasswordHelper.java b/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/helpers/XSSFPasswordHelper.java index 8c3329e797..ab9caf5d5b 100644 --- a/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/helpers/XSSFPasswordHelper.java +++ b/poi-ooxml/src/main/java/org/apache/poi/xssf/usermodel/helpers/XSSFPasswordHelper.java @@ -27,7 +27,6 @@ import javax.xml.namespace.QName; import org.apache.poi.poifs.crypt.CryptoFunctions; import org.apache.poi.poifs.crypt.HashAlgorithm; -import org.apache.poi.poifs.crypt.temp.EncryptedTempData; import org.apache.poi.util.Internal; import org.apache.poi.util.RandomSingleton; import org.apache.poi.util.StringUtil; diff --git a/poi-ooxml/src/test/java/org/apache/poi/openxml4j/opc/TestPackageThumbnail.java b/poi-ooxml/src/test/java/org/apache/poi/openxml4j/opc/TestPackageThumbnail.java index 81c78f41dc..db4ce054e8 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/openxml4j/opc/TestPackageThumbnail.java +++ b/poi-ooxml/src/test/java/org/apache/poi/openxml4j/opc/TestPackageThumbnail.java @@ -18,9 +18,7 @@ package org.apache.poi.openxml4j.opc; import static org.junit.jupiter.api.Assertions.assertFalse; -import static org.junit.jupiter.api.Assertions.assertNotEquals; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assertions.fail; import java.io.File; diff --git a/poi-ooxml/src/test/java/org/apache/poi/poifs/crypt/tests/TestEncryptor.java b/poi-ooxml/src/test/java/org/apache/poi/poifs/crypt/tests/TestEncryptor.java index 54c4681150..5e106b4202 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/poifs/crypt/tests/TestEncryptor.java +++ b/poi-ooxml/src/test/java/org/apache/poi/poifs/crypt/tests/TestEncryptor.java @@ -46,7 +46,6 @@ import org.apache.poi.poifs.crypt.CipherAlgorithm; import org.apache.poi.poifs.crypt.Decryptor; import org.apache.poi.poifs.crypt.EncryptionInfo; import org.apache.poi.poifs.crypt.EncryptionMode; -import org.apache.poi.poifs.crypt.EncryptionVerifier; import org.apache.poi.poifs.crypt.Encryptor; import org.apache.poi.poifs.crypt.HashAlgorithm; import org.apache.poi.poifs.crypt.agile.AgileDecryptor; diff --git a/poi-ooxml/src/test/java/org/apache/poi/util/tests/TestIdentifierManager.java b/poi-ooxml/src/test/java/org/apache/poi/util/tests/TestIdentifierManager.java index 4bbc64ddc5..370b2c3a56 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/util/tests/TestIdentifierManager.java +++ b/poi-ooxml/src/test/java/org/apache/poi/util/tests/TestIdentifierManager.java @@ -19,7 +19,6 @@ package org.apache.poi.util.tests; import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertFalse; import static org.junit.jupiter.api.Assertions.assertNotEquals; -import static org.junit.jupiter.api.Assertions.assertSame; import static org.junit.jupiter.api.Assertions.assertThrows; import static org.junit.jupiter.api.Assertions.assertTrue; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xddf/usermodel/chart/TestXDDFChartRemoveSeries.java b/poi-ooxml/src/test/java/org/apache/poi/xddf/usermodel/chart/TestXDDFChartRemoveSeries.java index ca5c40aaf1..75571ac3d8 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xddf/usermodel/chart/TestXDDFChartRemoveSeries.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xddf/usermodel/chart/TestXDDFChartRemoveSeries.java @@ -20,11 +20,9 @@ import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertThrows; import java.io.File; -import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; -import java.util.Locale; import org.apache.poi.xssf.usermodel.XSSFClientAnchor; import org.apache.poi.xssf.usermodel.XSSFDrawing; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xslf/usermodel/TestPPTX2PNG.java b/poi-ooxml/src/test/java/org/apache/poi/xslf/usermodel/TestPPTX2PNG.java index 65984ed638..fedf7a4854 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xslf/usermodel/TestPPTX2PNG.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xslf/usermodel/TestPPTX2PNG.java @@ -21,7 +21,6 @@ package org.apache.poi.xslf.usermodel; import static java.util.Arrays.asList; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assumptions.assumeFalse; import java.io.Closeable; import java.io.File; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFCloneSheet.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFCloneSheet.java index 8ceb06981c..72fc676c6e 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFCloneSheet.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFCloneSheet.java @@ -22,7 +22,6 @@ import static org.junit.jupiter.api.Assertions.assertNotEquals; import static org.junit.jupiter.api.Assertions.assertNotNull; import static org.junit.jupiter.api.Assertions.assertThrows; -import org.apache.poi.hssf.HSSFITestDataProvider; import org.apache.poi.ss.usermodel.BaseTestCloneSheet; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/model/TestStylesTable.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/model/TestStylesTable.java index 1429564084..e220357750 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/model/TestStylesTable.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/model/TestStylesTable.java @@ -28,7 +28,6 @@ import static org.junit.jupiter.api.Assertions.assertFalse; import static org.junit.jupiter.api.Assertions.assertNotNull; import static org.junit.jupiter.api.Assertions.assertThrows; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assertions.fail; import java.io.IOException; import java.io.InputStream; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFRow.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFRow.java index 59a18bc7e5..cd442b5406 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFRow.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFRow.java @@ -23,7 +23,6 @@ import org.apache.poi.ss.tests.usermodel.BaseTestXRow; import org.apache.poi.xssf.SXSSFITestDataProvider; import org.junit.jupiter.api.AfterEach; import org.junit.jupiter.api.Disabled; -import org.junit.jupiter.api.Test; /** * Tests for XSSFRow diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java index 579ea290f2..37b1740623 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java @@ -44,7 +44,6 @@ import org.apache.poi.openxml4j.opc.PackageAccess; import org.apache.poi.ss.tests.usermodel.BaseTestXWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellType; -import org.apache.poi.ss.usermodel.Hyperlink; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFSheetAutosizeColumn.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFSheetAutosizeColumn.java index cc162c3820..4ccc4e5122 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFSheetAutosizeColumn.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFSheetAutosizeColumn.java @@ -19,7 +19,6 @@ package org.apache.poi.xssf.usermodel; import org.apache.poi.ss.usermodel.BaseTestSheetAutosizeColumn; import org.apache.poi.ss.usermodel.Sheet; -import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.SXSSFITestDataProvider; import org.apache.poi.xssf.streaming.SXSSFSheet; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java index 5f5bd2f484..26011c3711 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java @@ -35,7 +35,6 @@ import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; -import java.io.OutputStream; import java.nio.charset.StandardCharsets; import java.time.Instant; import java.time.LocalDateTime; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFCell.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFCell.java index a98f762d79..2d2b930598 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFCell.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFCell.java @@ -25,7 +25,6 @@ import static org.junit.jupiter.api.Assertions.assertNull; import static org.junit.jupiter.api.Assertions.assertSame; import static org.junit.jupiter.api.Assertions.assertThrows; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assertions.fail; import java.io.IOException; import java.util.List; @@ -57,10 +56,8 @@ import org.apache.poi.xssf.SXSSFITestDataProvider; import org.apache.poi.xssf.XSSFITestDataProvider; import org.apache.poi.xssf.XSSFTestDataSamples; import org.apache.poi.xssf.model.SharedStringsTable; -import org.junit.jupiter.api.Tag; import org.junit.jupiter.api.Test; import org.junit.jupiter.params.ParameterizedTest; -import org.junit.jupiter.params.provider.CsvSource; import org.junit.jupiter.params.provider.EnumSource; import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCell; import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataValidation.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataValidation.java index d72cf493b1..c4b3d96eb8 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataValidation.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataValidation.java @@ -34,7 +34,6 @@ import org.apache.poi.ss.usermodel.DataValidationConstraint.OperatorType; import org.apache.poi.ss.usermodel.DataValidationConstraint.ValidationType; import org.apache.poi.ss.usermodel.DataValidationHelper; import org.apache.poi.ss.usermodel.Row; -import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.ss.util.CellRangeAddressList; import org.apache.poi.ss.util.CellReference; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/charts/TestXSSFChartTitle.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/charts/TestXSSFChartTitle.java index 72f3ff5ad4..8970453de6 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/charts/TestXSSFChartTitle.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/charts/TestXSSFChartTitle.java @@ -18,7 +18,6 @@ package org.apache.poi.xssf.usermodel.charts; import static org.junit.jupiter.api.Assertions.assertEquals; -import static org.junit.jupiter.api.Assertions.assertFalse; import static org.junit.jupiter.api.Assertions.assertNotEquals; import static org.junit.jupiter.api.Assertions.assertNotNull; import static org.junit.jupiter.api.Assertions.assertNull; diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/extensions/TestXSSFHeaderFooter.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/extensions/TestXSSFHeaderFooter.java index f5c1054849..0f8a35e8f9 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/extensions/TestXSSFHeaderFooter.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/extensions/TestXSSFHeaderFooter.java @@ -21,7 +21,6 @@ import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertFalse; import static org.junit.jupiter.api.Assertions.assertNotNull; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assertions.fail; import org.apache.poi.xssf.usermodel.XSSFOddHeader; import org.apache.poi.xssf.usermodel.XSSFSheet; diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFFill.java b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFFill.java index 219cd05c59..14ceaa5e6a 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFFill.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFFill.java @@ -32,7 +32,6 @@ import org.apache.poi.ddf.EscherBSERecord; import org.apache.poi.ddf.EscherColorRef; import org.apache.poi.ddf.EscherContainerRecord; import org.apache.poi.ddf.EscherPropertyTypes; -import org.apache.poi.ddf.EscherRecord; import org.apache.poi.ddf.EscherRecordTypes; import org.apache.poi.ddf.EscherSimpleProperty; import org.apache.poi.hslf.record.Document; diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureData.java b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureData.java index 3a6d2ad879..cfb44383b9 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureData.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureData.java @@ -47,7 +47,6 @@ import org.apache.poi.poifs.crypt.HashAlgorithm; import org.apache.poi.sl.usermodel.PictureData; import org.apache.poi.util.Internal; import org.apache.poi.util.LittleEndian; -import org.apache.poi.util.LittleEndianConsts; import org.apache.poi.util.Removal; import org.apache.poi.util.Units; diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureShape.java b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureShape.java index 6aba4b23ff..416fe4147b 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureShape.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFPictureShape.java @@ -28,7 +28,6 @@ import org.apache.poi.ddf.EscherBSERecord; import org.apache.poi.ddf.EscherComplexProperty; import org.apache.poi.ddf.EscherContainerRecord; import org.apache.poi.ddf.EscherPropertyTypes; -import org.apache.poi.ddf.EscherRecord; import org.apache.poi.ddf.EscherSimpleProperty; import org.apache.poi.ddf.EscherSpRecord; import org.apache.poi.hslf.record.Document; diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFSlideShow.java b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFSlideShow.java index fa4cf6c795..bab2df281d 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFSlideShow.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hslf/usermodel/HSLFSlideShow.java @@ -54,7 +54,6 @@ import org.apache.poi.hslf.exceptions.HSLFException; import org.apache.poi.hslf.model.HeadersFooters; import org.apache.poi.hslf.model.MovieShape; import org.apache.poi.hslf.record.*; -import org.apache.poi.hslf.record.Record; import org.apache.poi.hslf.record.SlideListWithText.SlideAtomsSet; import org.apache.poi.poifs.crypt.EncryptionInfo; import org.apache.poi.poifs.filesystem.DirectoryNode; diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hsmf/datatypes/DirectoryChunk.java b/poi-scratchpad/src/main/java/org/apache/poi/hsmf/datatypes/DirectoryChunk.java index 2b42db7209..1faba2dc66 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hsmf/datatypes/DirectoryChunk.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hsmf/datatypes/DirectoryChunk.java @@ -23,7 +23,6 @@ import java.io.OutputStream; import org.apache.poi.hsmf.MAPIMessage; import org.apache.poi.hsmf.datatypes.Types.MAPIType; import org.apache.poi.poifs.filesystem.DirectoryNode; -import org.apache.poi.util.Removal; /** * A Chunk that is just a placeholder in the MAPIMessage directory structure, diff --git a/poi-scratchpad/src/main/java/org/apache/poi/hwpf/converter/WordToFoConverter.java b/poi-scratchpad/src/main/java/org/apache/poi/hwpf/converter/WordToFoConverter.java index 3aca26981f..9bf16aeb03 100644 --- a/poi-scratchpad/src/main/java/org/apache/poi/hwpf/converter/WordToFoConverter.java +++ b/poi-scratchpad/src/main/java/org/apache/poi/hwpf/converter/WordToFoConverter.java @@ -17,9 +17,6 @@ package org.apache.poi.hwpf.converter; import static org.apache.logging.log4j.util.Unbox.box; -import static org.apache.poi.hwpf.converter.AbstractWordUtils.TWIPS_PER_INCH; -import static org.apache.poi.hwpf.converter.AbstractWordUtils.isNotEmpty; -import static org.apache.poi.hwpf.converter.AbstractWordUtils.loadDoc; import static org.apache.poi.hwpf.converter.WordToFoUtils.*; import java.io.File; diff --git a/poi-scratchpad/src/test/java/org/apache/poi/hdgf/TestHDGFCore.java b/poi-scratchpad/src/test/java/org/apache/poi/hdgf/TestHDGFCore.java index 9c78ba3b61..9d96dddd19 100644 --- a/poi-scratchpad/src/test/java/org/apache/poi/hdgf/TestHDGFCore.java +++ b/poi-scratchpad/src/test/java/org/apache/poi/hdgf/TestHDGFCore.java @@ -28,8 +28,6 @@ import org.apache.poi.hdgf.extractor.VisioTextExtractor; import org.apache.poi.hdgf.streams.PointerContainingStream; import org.apache.poi.hdgf.streams.TrailerStream; import org.apache.poi.poifs.filesystem.POIFSFileSystem; -import org.junit.jupiter.api.AfterEach; -import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; public final class TestHDGFCore { diff --git a/poi-scratchpad/src/test/java/org/apache/poi/hslf/usermodel/TestBackground.java b/poi-scratchpad/src/test/java/org/apache/poi/hslf/usermodel/TestBackground.java index cc3abf76e8..82cc3e2fb8 100644 --- a/poi-scratchpad/src/test/java/org/apache/poi/hslf/usermodel/TestBackground.java +++ b/poi-scratchpad/src/test/java/org/apache/poi/hslf/usermodel/TestBackground.java @@ -29,7 +29,6 @@ import org.apache.poi.ddf.AbstractEscherOptRecord; import org.apache.poi.ddf.EscherBSERecord; import org.apache.poi.ddf.EscherContainerRecord; import org.apache.poi.ddf.EscherPropertyTypes; -import org.apache.poi.ddf.EscherRecord; import org.apache.poi.ddf.EscherSimpleProperty; import org.apache.poi.hslf.HSLFTestDataSamples; import org.apache.poi.hslf.record.Document; diff --git a/poi-scratchpad/src/test/java/org/apache/poi/hsmf/TestBasics.java b/poi-scratchpad/src/test/java/org/apache/poi/hsmf/TestBasics.java index 25b5442ac2..9b89718b63 100644 --- a/poi-scratchpad/src/test/java/org/apache/poi/hsmf/TestBasics.java +++ b/poi-scratchpad/src/test/java/org/apache/poi/hsmf/TestBasics.java @@ -20,7 +20,6 @@ package org.apache.poi.hsmf; import static org.apache.poi.POITestCase.assertContains; import static org.apache.poi.POITestCase.assertStartsWith; import static org.junit.jupiter.api.Assertions.*; -import static org.junit.jupiter.api.Assertions.assertNotNull; import java.io.IOException; diff --git a/poi-scratchpad/src/test/java/org/apache/poi/hwpf/usermodel/TestProblems.java b/poi-scratchpad/src/test/java/org/apache/poi/hwpf/usermodel/TestProblems.java index 9732b77bda..da0f319dd3 100644 --- a/poi-scratchpad/src/test/java/org/apache/poi/hwpf/usermodel/TestProblems.java +++ b/poi-scratchpad/src/test/java/org/apache/poi/hwpf/usermodel/TestProblems.java @@ -27,7 +27,6 @@ import java.io.IOException; import org.apache.poi.EncryptedDocumentException; import org.apache.poi.hwpf.HWPFDocument; import org.apache.poi.hwpf.HWPFTestCase; -import org.apache.poi.hwpf.HWPFTestDataSamples; import org.apache.poi.hwpf.extractor.WordExtractor; import org.apache.poi.hwpf.model.StyleSheet; import org.junit.jupiter.api.Test; diff --git a/poi/src/main/java/org/apache/poi/extractor/ExtractorFactory.java b/poi/src/main/java/org/apache/poi/extractor/ExtractorFactory.java index 1fad9152eb..28b81e9cc4 100644 --- a/poi/src/main/java/org/apache/poi/extractor/ExtractorFactory.java +++ b/poi/src/main/java/org/apache/poi/extractor/ExtractorFactory.java @@ -30,7 +30,6 @@ import java.util.stream.StreamSupport; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; import org.apache.poi.EmptyFileException; -import org.apache.poi.OldFileFormatException; import org.apache.poi.hssf.extractor.ExcelExtractor; import org.apache.poi.poifs.crypt.Decryptor; import org.apache.poi.poifs.filesystem.DirectoryEntry; diff --git a/poi/src/main/java/org/apache/poi/hssf/eventmodel/ERFListener.java b/poi/src/main/java/org/apache/poi/hssf/eventmodel/ERFListener.java index 1924b476ba..2bb3989f8d 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventmodel/ERFListener.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventmodel/ERFListener.java @@ -17,8 +17,6 @@ package org.apache.poi.hssf.eventmodel; -import org.apache.poi.hssf.record.Record; - /** * An ERFListener is registered with the EventRecordFactory. * An ERFListener listens for Records coming from the stream diff --git a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/AbortableHSSFListener.java b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/AbortableHSSFListener.java index b030effac6..9d78819dfe 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/AbortableHSSFListener.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/AbortableHSSFListener.java @@ -18,8 +18,6 @@ package org.apache.poi.hssf.eventusermodel; -import org.apache.poi.hssf.record.Record; - /** * Abstract class for use with the HSSFRequest and HSSFEventFactory, which * allows for the halting of processing. diff --git a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java index 3a6a54e133..6c7681a704 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java @@ -25,7 +25,6 @@ import org.apache.poi.hssf.model.InternalWorkbook; import org.apache.poi.hssf.record.BoundSheetRecord; import org.apache.poi.hssf.record.EOFRecord; import org.apache.poi.hssf.record.ExternSheetRecord; -import org.apache.poi.hssf.record.Record; import org.apache.poi.hssf.record.SSTRecord; import org.apache.poi.hssf.record.SupBookRecord; import org.apache.poi.hssf.usermodel.HSSFWorkbook; diff --git a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFListener.java b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFListener.java index cc47e416b0..7b3e0be49f 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFListener.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFListener.java @@ -18,8 +18,6 @@ package org.apache.poi.hssf.eventusermodel; -import org.apache.poi.hssf.record.Record; - /** * Interface for use with the HSSFRequest and HSSFEventFactory. Users should create * a listener supporting this interface and register it with the HSSFRequest (associating diff --git a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFRequest.java b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFRequest.java index ce6b93af72..d2ea4b259f 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFRequest.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/HSSFRequest.java @@ -22,7 +22,6 @@ import java.util.List; import java.util.ArrayList; import java.util.Map; -import org.apache.poi.hssf.record.Record; import org.apache.poi.hssf.record.RecordFactory; /** diff --git a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/MissingRecordAwareHSSFListener.java b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/MissingRecordAwareHSSFListener.java index ed87510c70..48e6826233 100644 --- a/poi/src/main/java/org/apache/poi/hssf/eventusermodel/MissingRecordAwareHSSFListener.java +++ b/poi/src/main/java/org/apache/poi/hssf/eventusermodel/MissingRecordAwareHSSFListener.java @@ -25,7 +25,6 @@ import org.apache.poi.hssf.record.CellValueRecordInterface; import org.apache.poi.hssf.record.MulBlankRecord; import org.apache.poi.hssf.record.MulRKRecord; import org.apache.poi.hssf.record.NoteRecord; -import org.apache.poi.hssf.record.Record; import org.apache.poi.hssf.record.RecordFactory; import org.apache.poi.hssf.record.RowRecord; import org.apache.poi.hssf.record.SharedFormulaRecord; diff --git a/poi/src/main/java/org/apache/poi/hssf/model/HSSFFormulaParser.java b/poi/src/main/java/org/apache/poi/hssf/model/HSSFFormulaParser.java index e2ed227155..4bab58bd4c 100644 --- a/poi/src/main/java/org/apache/poi/hssf/model/HSSFFormulaParser.java +++ b/poi/src/main/java/org/apache/poi/hssf/model/HSSFFormulaParser.java @@ -26,7 +26,6 @@ import org.apache.poi.ss.formula.FormulaRenderer; import org.apache.poi.ss.formula.FormulaType; import org.apache.poi.ss.formula.ptg.Ptg; import org.apache.poi.util.Internal; -import org.apache.poi.util.Removal; /** * HSSF wrapper for the {@link FormulaParser} and {@link FormulaRenderer} diff --git a/poi/src/main/java/org/apache/poi/hssf/model/InternalSheet.java b/poi/src/main/java/org/apache/poi/hssf/model/InternalSheet.java index 8deeec15a3..41e1099ba2 100644 --- a/poi/src/main/java/org/apache/poi/hssf/model/InternalSheet.java +++ b/poi/src/main/java/org/apache/poi/hssf/model/InternalSheet.java @@ -25,7 +25,6 @@ import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; import org.apache.logging.log4j.message.SimpleMessage; import org.apache.poi.hssf.record.*; -import org.apache.poi.hssf.record.Record; import org.apache.poi.hssf.record.aggregates.ChartSubstreamRecordAggregate; import org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate; import org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable; diff --git a/poi/src/main/java/org/apache/poi/hssf/model/InternalWorkbook.java b/poi/src/main/java/org/apache/poi/hssf/model/InternalWorkbook.java index 82a3838414..ca1e7f8ec5 100644 --- a/poi/src/main/java/org/apache/poi/hssf/model/InternalWorkbook.java +++ b/poi/src/main/java/org/apache/poi/hssf/model/InternalWorkbook.java @@ -39,7 +39,6 @@ import org.apache.poi.ddf.EscherSpRecord; import org.apache.poi.ddf.EscherSplitMenuColorsRecord; import org.apache.poi.hssf.extractor.OldExcelExtractor; import org.apache.poi.hssf.record.*; -import org.apache.poi.hssf.record.Record; import org.apache.poi.hssf.record.common.UnicodeString; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor.HSSFColorPredefined; diff --git a/poi/src/main/java/org/apache/poi/hssf/record/WriteAccessRecord.java b/poi/src/main/java/org/apache/poi/hssf/record/WriteAccessRecord.java index 84061d0cda..88f8affd2d 100644 --- a/poi/src/main/java/org/apache/poi/hssf/record/WriteAccessRecord.java +++ b/poi/src/main/java/org/apache/poi/hssf/record/WriteAccessRecord.java @@ -17,7 +17,6 @@ package org.apache.poi.hssf.record; -import java.io.IOException; import java.nio.charset.Charset; import java.nio.charset.StandardCharsets; import java.util.Arrays; diff --git a/poi/src/main/java/org/apache/poi/hssf/usermodel/HSSFRow.java b/poi/src/main/java/org/apache/poi/hssf/usermodel/HSSFRow.java index 83d6213b32..9220c14157 100644 --- a/poi/src/main/java/org/apache/poi/hssf/usermodel/HSSFRow.java +++ b/poi/src/main/java/org/apache/poi/hssf/usermodel/HSSFRow.java @@ -33,7 +33,6 @@ import org.apache.poi.ss.usermodel.CellCopyContext; import org.apache.poi.ss.usermodel.CellCopyPolicy; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.CellType; -import org.apache.poi.ss.usermodel.FormulaError; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.helpers.RowShifter; import org.apache.poi.ss.util.CellRangeAddress; diff --git a/poi/src/main/java/org/apache/poi/hssf/util/HSSFColor.java b/poi/src/main/java/org/apache/poi/hssf/util/HSSFColor.java index c659f1cfef..1d791102aa 100644 --- a/poi/src/main/java/org/apache/poi/hssf/util/HSSFColor.java +++ b/poi/src/main/java/org/apache/poi/hssf/util/HSSFColor.java @@ -25,7 +25,6 @@ import java.util.Map; import java.util.Objects; import org.apache.poi.ss.usermodel.Color; -import org.apache.poi.util.Removal; /** diff --git a/poi/src/main/java/org/apache/poi/sl/draw/geom/CurveToCommand.java b/poi/src/main/java/org/apache/poi/sl/draw/geom/CurveToCommand.java index 01d3f726e5..793ea6dd70 100644 --- a/poi/src/main/java/org/apache/poi/sl/draw/geom/CurveToCommand.java +++ b/poi/src/main/java/org/apache/poi/sl/draw/geom/CurveToCommand.java @@ -19,7 +19,6 @@ package org.apache.poi.sl.draw.geom; -import java.awt.geom.Path2D; import java.util.Objects; /** diff --git a/poi/src/main/java/org/apache/poi/sl/draw/geom/GuideIf.java b/poi/src/main/java/org/apache/poi/sl/draw/geom/GuideIf.java index d813f0ca31..ff0e58d351 100644 --- a/poi/src/main/java/org/apache/poi/sl/draw/geom/GuideIf.java +++ b/poi/src/main/java/org/apache/poi/sl/draw/geom/GuideIf.java @@ -20,7 +20,6 @@ package org.apache.poi.sl.draw.geom; import static java.lang.Math.*; -import static java.lang.Math.toRadians; import java.util.regex.Pattern; diff --git a/poi/src/main/java/org/apache/poi/ss/formula/EvaluationCache.java b/poi/src/main/java/org/apache/poi/ss/formula/EvaluationCache.java index cd7539a675..ddb3f591dc 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/EvaluationCache.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/EvaluationCache.java @@ -17,7 +17,6 @@ package org.apache.poi.ss.formula; -import org.apache.poi.ss.formula.FormulaCellCache.IEntryOperation; import org.apache.poi.ss.formula.FormulaUsedBlankCellSet.BookSheetKey; import org.apache.poi.ss.formula.PlainCellCache.Loc; import org.apache.poi.ss.formula.eval.BlankEval; diff --git a/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java b/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java index 8ab6f9dad0..e638fddd61 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/atp/PercentRankExcFunction.java @@ -23,7 +23,6 @@ import org.apache.poi.ss.formula.functions.FreeRefFunction; import org.apache.poi.ss.formula.functions.PercentRank; import java.math.BigDecimal; -import java.math.RoundingMode; import java.util.ArrayList; import java.util.List; diff --git a/poi/src/main/java/org/apache/poi/ss/formula/atp/WorkdayCalculator.java b/poi/src/main/java/org/apache/poi/ss/formula/atp/WorkdayCalculator.java index 17b22a32c1..69b5a6e320 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/atp/WorkdayCalculator.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/atp/WorkdayCalculator.java @@ -28,7 +28,6 @@ import java.util.Set; import org.apache.poi.ss.usermodel.DateUtil; import org.apache.poi.util.LocaleUtil; -import org.apache.poi.util.Removal; /** * A calculator for workdays, considering dates as excel representations. diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/Covar.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/Covar.java index 3c902498b6..2aa916a2ae 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/Covar.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/Covar.java @@ -17,7 +17,6 @@ package org.apache.poi.ss.formula.functions; import org.apache.commons.math3.stat.correlation.Covariance; -import org.apache.commons.math3.stat.correlation.PearsonsCorrelation; import org.apache.poi.ss.formula.OperationEvaluationContext; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.EvaluationException; diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/DCountA.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/DCountA.java index 6b9cc27aee..9d7405843b 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/DCountA.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/DCountA.java @@ -19,7 +19,6 @@ package org.apache.poi.ss.formula.functions; import org.apache.poi.ss.formula.eval.BlankEval; import org.apache.poi.ss.formula.eval.NumberEval; -import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.ValueEval; /** diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/DProduct.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/DProduct.java index 2a1c05ff4a..6f72ff2519 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/DProduct.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/DProduct.java @@ -20,10 +20,6 @@ package org.apache.poi.ss.formula.functions; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.ValueEval; -import org.apache.poi.ss.util.NumberToTextConverter; - -import java.math.BigDecimal; -import java.util.ArrayList; /** * Implementation of the DProduct function: diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/IfFunc.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/IfFunc.java index c73e13a1cc..3f78273f7e 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/IfFunc.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/IfFunc.java @@ -23,8 +23,6 @@ import org.apache.poi.ss.formula.eval.*; import org.apache.poi.ss.formula.ptg.Ptg; import org.apache.poi.ss.formula.ptg.RefPtg; -import java.util.function.BiFunction; - /** * Implementation for the Excel function IF *

diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/Quotient.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/Quotient.java index 7a1ff4a9ba..36ddf437ac 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/Quotient.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/Quotient.java @@ -18,7 +18,6 @@ package org.apache.poi.ss.formula.functions; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.ValueEval; import org.apache.poi.ss.formula.eval.*; diff --git a/poi/src/main/java/org/apache/poi/ss/usermodel/FormulaEvaluator.java b/poi/src/main/java/org/apache/poi/ss/usermodel/FormulaEvaluator.java index 5d9a671dc4..7c90640fa1 100644 --- a/poi/src/main/java/org/apache/poi/ss/usermodel/FormulaEvaluator.java +++ b/poi/src/main/java/org/apache/poi/ss/usermodel/FormulaEvaluator.java @@ -17,8 +17,6 @@ package org.apache.poi.ss.usermodel; -import org.apache.poi.util.Removal; - import java.util.Map; /** diff --git a/poi/src/main/java/org/apache/poi/ss/util/CellUtil.java b/poi/src/main/java/org/apache/poi/ss/util/CellUtil.java index e509dd2aaf..29c2f2a524 100644 --- a/poi/src/main/java/org/apache/poi/ss/util/CellUtil.java +++ b/poi/src/main/java/org/apache/poi/ss/util/CellUtil.java @@ -30,7 +30,6 @@ import org.apache.logging.log4j.Logger; import org.apache.poi.common.Duplicatable; import org.apache.poi.ss.usermodel.*; import org.apache.poi.util.Beta; -import org.apache.poi.util.Internal; /** * Various utility functions that make working with a cells and rows easier. The various methods diff --git a/poi/src/main/java/org/apache/poi/util/CodePageUtil.java b/poi/src/main/java/org/apache/poi/util/CodePageUtil.java index 1b068c8754..b89fba871b 100644 --- a/poi/src/main/java/org/apache/poi/util/CodePageUtil.java +++ b/poi/src/main/java/org/apache/poi/util/CodePageUtil.java @@ -18,9 +18,6 @@ package org.apache.poi.util; import java.io.UnsupportedEncodingException; -import java.nio.charset.Charset; -import java.util.Collections; -import java.util.Set; /** * Utilities for working with Microsoft CodePages. diff --git a/poi/src/test/java/org/apache/poi/hssf/dev/TestBiffViewer.java b/poi/src/test/java/org/apache/poi/hssf/dev/TestBiffViewer.java index 82ae713ab1..107c87668b 100644 --- a/poi/src/test/java/org/apache/poi/hssf/dev/TestBiffViewer.java +++ b/poi/src/test/java/org/apache/poi/hssf/dev/TestBiffViewer.java @@ -20,7 +20,6 @@ import java.io.File; import java.io.IOException; import java.util.Map; -import org.apache.poi.EncryptedDocumentException; import org.apache.poi.util.RecordFormatException; class TestBiffViewer extends BaseTestIteratingXLS { diff --git a/poi/src/test/java/org/apache/poi/hssf/dev/TestEFBiffViewer.java b/poi/src/test/java/org/apache/poi/hssf/dev/TestEFBiffViewer.java index 375bf8fa76..a5349ff25c 100644 --- a/poi/src/test/java/org/apache/poi/hssf/dev/TestEFBiffViewer.java +++ b/poi/src/test/java/org/apache/poi/hssf/dev/TestEFBiffViewer.java @@ -26,7 +26,6 @@ import org.apache.poi.hssf.eventusermodel.HSSFEventFactory; import org.apache.poi.hssf.eventusermodel.HSSFRequest; import org.apache.poi.hssf.record.RecordInputStream; import org.apache.poi.poifs.filesystem.POIFSFileSystem; -import org.apache.poi.util.RecordFormatException; import org.junit.jupiter.api.Assertions; class TestEFBiffViewer extends BaseTestIteratingXLS { diff --git a/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFSheetShiftColumns.java b/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFSheetShiftColumns.java index 9333ac516a..4f6b446c2b 100644 --- a/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFSheetShiftColumns.java +++ b/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFSheetShiftColumns.java @@ -18,14 +18,11 @@ */ package org.apache.poi.hssf.usermodel; -import java.io.IOException; - import org.apache.poi.hssf.HSSFITestDataProvider; import org.apache.poi.hssf.HSSFTestDataSamples; import org.apache.poi.ss.usermodel.BaseTestSheetShiftColumns; import org.apache.poi.ss.usermodel.Workbook; import org.junit.jupiter.api.Disabled; -import org.junit.jupiter.api.Test; class TestHSSFSheetShiftColumns extends BaseTestSheetShiftColumns { public TestHSSFSheetShiftColumns() { diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageifs.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageifs.java index d299d9e04b..8db06f2fb7 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageifs.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestAverageifs.java @@ -19,26 +19,17 @@ package org.apache.poi.ss.formula.functions; -import static org.apache.poi.ss.util.Utils.*; import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertTrue; -import org.apache.poi.hssf.HSSFTestDataSamples; -import org.apache.poi.hssf.usermodel.HSSFCell; -import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; -import org.apache.poi.hssf.usermodel.HSSFSheet; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; -import org.apache.poi.ss.usermodel.FormulaError; import org.junit.jupiter.api.Test; -import java.io.IOException; - /** * Test cases for AVERAGEIFS() */ diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDollarDe.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDollarDe.java index 5d9e1ea522..768e723482 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDollarDe.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDollarDe.java @@ -23,7 +23,6 @@ import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.BoolEval; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.StringEval; @@ -32,7 +31,6 @@ import org.junit.jupiter.api.Test; import java.io.IOException; -import static org.apache.poi.ss.util.Utils.addRow; import static org.apache.poi.ss.util.Utils.assertDouble; import static org.junit.jupiter.api.Assertions.assertEquals; diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestForecast.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestForecast.java index e2e42e110d..e31b180828 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestForecast.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestForecast.java @@ -22,14 +22,12 @@ import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; -import org.apache.poi.ss.usermodel.FormulaError; import org.junit.jupiter.api.Test; import java.io.IOException; import static org.apache.poi.ss.util.Utils.addRow; import static org.apache.poi.ss.util.Utils.assertDouble; -import static org.apache.poi.ss.util.Utils.assertError; /** * Tests for {@link Forecast} diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestGcd.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestGcd.java index a4ddb8d2b2..624b2bccc3 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestGcd.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestGcd.java @@ -17,25 +17,16 @@ package org.apache.poi.ss.formula.functions; -import org.apache.poi.hssf.usermodel.HSSFCell; -import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; -import org.apache.poi.hssf.usermodel.HSSFSheet; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.BoolEval; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; import org.junit.jupiter.api.Test; -import java.io.IOException; import java.util.Arrays; -import java.util.Collections; import java.util.List; -import static org.apache.poi.ss.util.Utils.addRow; -import static org.apache.poi.ss.util.Utils.assertDouble; import static org.junit.jupiter.api.Assertions.assertEquals; /** diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMaxifs.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMaxifs.java index 91d8c32b7b..580e7740dc 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMaxifs.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMaxifs.java @@ -19,26 +19,16 @@ package org.apache.poi.ss.formula.functions; -import static org.apache.poi.ss.util.Utils.*; import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertTrue; -import org.apache.poi.hssf.HSSFTestDataSamples; -import org.apache.poi.hssf.usermodel.HSSFCell; -import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; -import org.apache.poi.hssf.usermodel.HSSFSheet; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; -import org.apache.poi.ss.usermodel.FormulaError; import org.junit.jupiter.api.Test; -import java.io.IOException; - /** * Test cases for MAXIFS() */ diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMinifs.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMinifs.java index 4e3f6cfe1f..d7f530585a 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMinifs.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestMinifs.java @@ -19,26 +19,16 @@ package org.apache.poi.ss.formula.functions; -import static org.apache.poi.ss.util.Utils.*; import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertTrue; -import org.apache.poi.hssf.HSSFTestDataSamples; -import org.apache.poi.hssf.usermodel.HSSFCell; -import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; -import org.apache.poi.hssf.usermodel.HSSFSheet; -import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.NumericValueEval; import org.apache.poi.ss.formula.eval.StringEval; import org.apache.poi.ss.formula.eval.ValueEval; -import org.apache.poi.ss.usermodel.FormulaError; import org.junit.jupiter.api.Test; -import java.io.IOException; - /** * Test cases for MINIFS() */ diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java index 39ae606adf..9099876f84 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java @@ -22,7 +22,6 @@ import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.BlankEval; import org.apache.poi.ss.formula.eval.BoolEval; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormInv.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormInv.java index 689b1ae12f..08baad5ab8 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormInv.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormInv.java @@ -22,7 +22,6 @@ import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.OperationEvaluationContext; -import org.apache.poi.ss.formula.eval.BoolEval; import org.apache.poi.ss.formula.eval.ErrorEval; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.StringEval; diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormSDist.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormSDist.java index a5a3922b9f..03670a030a 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormSDist.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormSDist.java @@ -31,7 +31,6 @@ import org.junit.jupiter.api.Test; import java.io.IOException; -import static org.apache.poi.ss.util.Utils.addRow; import static org.apache.poi.ss.util.Utils.assertDouble; import static org.junit.jupiter.api.Assertions.assertEquals; diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumberValue.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumberValue.java index f8307698cd..ef6444cbbb 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumberValue.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNumberValue.java @@ -22,16 +22,13 @@ import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; -import org.apache.poi.ss.usermodel.CellValue; import org.apache.poi.ss.usermodel.FormulaError; import org.junit.jupiter.api.Test; import java.io.IOException; -import static org.apache.poi.ss.util.Utils.addRow; import static org.apache.poi.ss.util.Utils.assertDouble; import static org.apache.poi.ss.util.Utils.assertError; -import static org.junit.jupiter.api.Assertions.assertEquals; /** * Testcase for function NUMBERVALUE() diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSubtotal.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSubtotal.java index a12917242b..0cfc46f0dc 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSubtotal.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSubtotal.java @@ -28,7 +28,6 @@ import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.formula.FormulaParseException; import org.apache.poi.ss.formula.eval.AreaEval; import org.apache.poi.ss.formula.eval.ErrorEval; -import org.apache.poi.ss.formula.eval.NotImplementedException; import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.ValueEval; import org.apache.poi.ss.usermodel.Cell; diff --git a/poi/src/test/java/org/apache/poi/ss/usermodel/TestExcelStyleDateFormatter.java b/poi/src/test/java/org/apache/poi/ss/usermodel/TestExcelStyleDateFormatter.java index e27557e9b9..ad86341a26 100644 --- a/poi/src/test/java/org/apache/poi/ss/usermodel/TestExcelStyleDateFormatter.java +++ b/poi/src/test/java/org/apache/poi/ss/usermodel/TestExcelStyleDateFormatter.java @@ -28,11 +28,8 @@ import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; -import java.util.HashMap; import java.util.List; import java.util.Locale; -import java.util.Map; -import java.util.stream.Collectors; import java.util.stream.Stream; import org.apache.poi.util.LocaleUtil; diff --git a/poi/src/test/java/org/apache/poi/util/TestStringUtil.java b/poi/src/test/java/org/apache/poi/util/TestStringUtil.java index c0545cd762..82a65b1bfb 100644 --- a/poi/src/test/java/org/apache/poi/util/TestStringUtil.java +++ b/poi/src/test/java/org/apache/poi/util/TestStringUtil.java @@ -21,7 +21,6 @@ import static org.junit.jupiter.api.Assertions.assertEquals; import static org.junit.jupiter.api.Assertions.assertFalse; import static org.junit.jupiter.api.Assertions.assertThrows; import static org.junit.jupiter.api.Assertions.assertTrue; -import static org.junit.jupiter.api.Assertions.fail; import java.nio.charset.Charset; -- 2.39.5