Linuxeden开源社区Apache POI 4.0.0 发布了，此版本特点是一些新功能和众多 bug 修复，包括：
- 删除了对 Java 6 和 7 的支持，使 Java 8 成为支持的最低版本
- 需要新的 OOXML schema（1.4），因为不兼容的 XMLBeans 加载不再通过 POIXMLTypeLoader
其它内容：
| Type | 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 |
详情见发布公告。
下载地址：http://poi.apache.org/download.html
转自 https://www.oschina.net/news/99696/poi-4-0-0-released