转载

Apache POI 4.0.0 正式发布，不再支持 Java 6 与 7

Apache POI 4.0.0 发布了，此版本特点是一些新功能和众多 bug 修复，包括：

删除了对 Java 6 和 7 的支持，使 Java 8 成为支持的最低版本
需要新的 OOXML schema（1.4），因为不兼容的 XMLBeans 加载不再通过 POIXMLTypeLoader

其它内容：

Bug	Module	Description
62649	POIFS	*Remove OPOIFS (breaks backwards compatibility)**
61589	XSLF	Importing content does not copy hyperlink address
62587	XSLF	repeated call to XSLFSheet.removeShape leads to java.lang.IllegalArgumentException: partName
62513	OOXML	Don't try to parse embedded package relationships
59268	OOXML	Work on providing an updated version of XMLBeans
62451	HPSF	Document last printed in the year 27321
60713	SXSSF XSSF OPC	(S)XSSFWorkbook/POIXMLDocument.write(OutputStream) closes the OutputStream (breaks backwards compatibility)
62452	OPC	Extract configuration while verifying XML signatures
62187	OPC	Compiling with Java 10 fails with ClassCastException / use commons-compress (breaks backwards compatibility)
62355	POI_Overall	Unsplit packages for Jigsaw / Java 9 compatibility (breaks backwards compatibility)
62041	SL_Common	TestFonts fails on Mac
62051	XSLF	Two shapes have the same shapeId within the same slide
61633	XSLF	Zero width shapes aren't rendered
62037	SL_Common	SlideNames should not be null but have a default as if accessed by VBA
62381	SL_Common	Fix rendering of AutoShapes
59893	POI_Overall	Forbid calls to InputStream.available
61905	HSSF	HSSFWorkbook.setActiveCell() does not actually make the cell selected in Excel
61459	HSLF	HSLFShape.getShapeName() returns name of shapeType and not the shape name
62319	SL_Common	Decommission XSLF-/PowerPointExtractor (breaks backwards compatibility)
62092	SL_Common	Text not extracted from grouped text shapes in HSLF
62159	OPC	Support XML signature over windows certificate store
57369	XDDF	Add support for major and minor units on chart axes
55954	XWPF	Added methods to position table
61947	POI_Overall	Remove deprecated classes (POI 4.0.0)
55954	XWPF	Add functions to get, set, remove outer borders for tables
github-72	XDDF	Define XDDF user model for shape properties to be shared between XSLF, XSSF and XWPF
61543	XSSF	Do not fail with "part already exists" when tables are created/removed (breaks backwards compatibility)
61550	POI_Overall	Add more information to exception text and verify that it is thrown (breaks backwards compatibility)
61609	POI_Overall	Add .gitattribute file and set lf for one sample-file (breaks backwards compatibility)
61797	SL_Common	Embed Excel / Ole objects into powerpoint (breaks backwards compatibility)
61943	SL_Common	narrow generics definition because of tighter java9 checks
61942	OPC	Refactor PackagePartName handling and add getUnusedPartIndex method
61941	POIFS	Move Ole marker generation to Ole10Native
61940	POI_Overall	Replace ClassID statics with enum
61939	OPC	Provide schema for AlternateContent - provide new ooxml-schemas-1.4.jar
61787	HSSF	Change how deleted content is detected to not incorrectly see too much text as deleted, this was introduced with bug 58067
61798	HSSF	Fix usage of getLastCellNum() when calculating worksheet dimension during saving
61911	HWPF	Avoid IndexOutOfBounds access when reading pictures
61765	HSSF	Support third party tool generated files using WorkBook as their POIFS directory name
61881	HSLF	Regression in ppt parsing: typeface can't be null or empty
github-68	XDDF XSLF XSSF XWPF	Share chart data implementation between XSLFChart, XSSFChart and XWPFChart through XDDF
61809	HPSF	Infinite loop in SectionIDMap.get() and .put()
60887	XSSF	Surface XSSF Header/Footer Attributes
61730	SS_Common	CellRangeAddresses support iterating over their CellAddresses
61727	SS_Common	CellRangeUtil merge cell ranges broken for certain orders of arguments
57517	HSSF	Fix various situations that were handled incorrectly in HSSFOptimiser
61671	XSLF	XSLFSlide does not contain isHidden and setHidden like HSLFSlide does
61630	XSSF	Performance improvement to XSSFExportToXML
58068	XSSF	Add a method to pass the actual Color to StylesTable.findFont()
61096	POIFS	Add support for modules in VBAMacroReader
61033	XSSF	Add XSSFWorkbook.setCellFormulaValidation() to control if formulas are validated during Cell.setCellFormula()
61148	SXSSF	Fix calculating/setting formula value
61064	SS_Common	Support behavior of function CEILING in newer versions of Microsoft Excel
61516	SS_Common	Correctly handle references that end up outside the workbook when cells with formulas are copied
60737	XSSF	Add endSheet() to XSSFEventBasedExcelExtractor
59747	OPC	Exchange order of writing parts into Zip to allow some tools to handle files better
github-69	SS_Common	Support matrix functions
60499	OPC	Deleting a picture that is used twice on a slide corrupt the slide
60279	POI_Overall	Back-off to brute-force search for macro content if macro offset is incorrect
61528	XSSF	Pivot table enhancements
61906	XSSF	add API for working with RichStringText
61792	SS_Common	Avoid iterating over chars (use codepoints instead)
62254	SS_Common	Update OFFSET function to support optional values
62435	XSSF	Rename getAllEmbedds method to getAllEmbeddedParts (getAllEmbedds is retained but deprecated)
62438	POI_Overall	Replace org.apache.poi.openxml4j.util.Nullable with java.lang.Optional (breaks backwards compatibility)
github-90	XSSF	Change default DSIG signing algorithm to SHA256
github-107	SS_Common	Support AREAS function
github-110	XWPF	Renames org.apache.poi.xwpf.usermodel.TextSegement to org.apache.poi.xwpf.usermodel.TextSegment (breaks backwards compatibility)
github-114	XWPF	Better support for Footnotes and Endnotes