CINXE.COM

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta content="Apache Forrest" name="Generator"> <meta name="Forrest-version" content="0.9"> <meta name="Forrest-skin-name" content="pelt"> <title>History of Changes</title> <link type="text/css" href="skin/basic.css" rel="stylesheet"> <link media="screen" type="text/css" href="skin/screen.css" rel="stylesheet"> <link media="print" type="text/css" href="skin/print.css" rel="stylesheet"> <link type="text/css" href="skin/profile.css" rel="stylesheet"> <script src="skin/getBlank.js" language="javascript" type="text/javascript"></script><script src="skin/getMenu.js" language="javascript" type="text/javascript"></script><script src="skin/fontsize.js" language="javascript" type="text/javascript"></script> <link rel="shortcut icon" href="images/favicon.ico"> </head> <body onload="init()"> <script type="text/javascript">ndeSetTextSize();</script> <div id="top">  <div class="breadtrail"> <a href="https://www.apache.org">Apache Software Foundation</a> > <a href="https://poi.apache.org">Apache POI</a><script src="skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script> </div>  <div class="header">  <div class="grouplogo"> <a href="https://www.apache.org"><img class="logoImage" alt="Apache Software Foundation" src="images/group-logo.png" title="The Apache Software Foundation is a cornerstone of the modern Open Source software ecosystem – supporting some of the most widely used and important software solutions powering today's Internet economy."></a> </div>   <div class="projectlogo"> <a href="https://poi.apache.org"><img class="logoImage" alt="Apache POI" src="images/project-header.png" title="Apache POI is well-known in the Java field as a library for reading and writing Microsoft Office file formats, such as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the older (OLE2) and new (OOXML - Office Open XML) formats."></a> </div>   <div class="searchbox"> <form action="https://www.google.com/search" method="get" class="roundtopsmall"> <input value="poi.apache.org" name="sitesearch" type="hidden"><input onFocus="getBlank (this, 'Search the site with google');" size="25" name="q" id="query" type="text" value="Search the site with google">  <input name="Search" value="Search" type="submit"> </form> </div>   <ul id="tabs"> <li class="current"> <a class="selected" href="index.html">Home</a> </li> <li> <a class="unselected" href="help/index.html">Help</a> </li> <li> <a class="unselected" href="components/index.html">Component APIs</a> </li> <li> <a class="unselected" href="devel/index.html">Getting Involved</a> </li> </ul>  </div> </div> <div id="main"> <div id="publishedStrip">  <div id="level2tabs"></div>  <script type="text/javascript"></script> </div>  <div class="breadtrail">   </div>   <div id="menu"> <div onclick="SwitchMenu('menu_selected_1.1', 'skin/')" id="menu_selected_1.1Title" class="menutitle" style="background-image: url('skin/images/chapter_open.gif');">Overview</div> <div id="menu_selected_1.1" class="selectedmenuitemgroup" style="display: block;"> <div class="menuitem"> <a href="index.html">Home</a> </div> <div class="menuitem"> <a href="download.html">Download</a> </div> <div class="menupage"> <div class="menupagetitle">Changelog</div> </div> <div class="menuitem"> <a href="apidocs/index.html">Javadocs</a> </div> <div class="menuitem"> <a href="text-extraction.html">Text Extraction</a> </div> <div class="menuitem"> <a href="encryption.html">Encryption support</a> </div> <div class="menuitem"> <a href="security.html">Secure processing</a> </div> <div class="menuitem"> <a href="casestudies.html">Case Studies</a> </div> <div class="menuitem"> <a href="related-projects.html">Related projects</a> </div> <div class="menuitem"> <a href="legal.html">Legal</a> </div> </div> <div onclick="SwitchMenu('menu_1.2', 'skin/')" id="menu_1.2Title" class="menutitle">Apache Wide</div> <div id="menu_1.2" class="menuitemgroup"> <div class="menuitem"> <a href="https://www.apache.org/">Apache Software Foundation</a> </div> <div class="menuitem"> <a href="https://www.apache.org/licenses/">License</a> </div> <div class="menuitem"> <a href="https://www.apache.org/foundation/sponsorship.html">Sponsorship</a> </div> <div class="menuitem"> <a href="https://www.apache.org/foundation/thanks.html">Thanks</a> </div> <div class="menuitem"> <a href="https://www.apache.org/security/">Security</a> </div> <div class="menuitem"> <a href="https://privacy.apache.org/policies/privacy-policy-public.html">Privacy</a> </div> </div> <div id="credit"></div> <div id="roundbottom"> <img style="display: none" class="corner" height="15" width="15" alt="" src="skin/images/rc-b-l-15-1body-2menu-3menu.png"></div>  <div id="credit2"> <a href="https://donate.apache.org/"><img border="0" title="Support Apache" alt="Support Apache - logo" src="images/support-asf.png" style="width: 125px;height: 125px;"></a><a href="https://www.apache.org/foundation/press/kit/#poweredby"><img border="0" title="powered by POI" alt="powered by POI - logo" src="images/poweredby-poi-logo.png" style="width: 125px;height: 125px;"></a> </div> </div>   <div id="content"> <h1>History of Changes</h1> <div id="front-matter"></div> <a name="previous_releases"></a> <h2 class="boxed">Previous releases</h2> <div class="section"> <p>The change log for <a href="devel/history/changes-3x.html">POI 3.x</a> and <a href="devel/history/changes-pre3x.html">older releases</a> can be found in the history section. </p> </div> <a name="5.4.1"></a> <h2 class="boxed">Version 5.4.1 (2025-04-06) </h2> <div class="section"> <a name="Summary"></a> <h3 class="boxed">Summary</h3> <ul> <li>Note: JDK 24 will change behavior of locale providers, some formatting might be different when upgrading</li> <li>Upgrade commons-codec dependency to 1.18.0</li> <li>Upgrade bouncycastle dependency to 1.80</li> <li>Upgrade pdfbox dependency to 3.0.4</li> <li>Upgrade graphics2d dependency to 3.0.3</li> </ul> <a name="Changes"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69618">69618</a></td><td>OOXML</td><td>ZipPackage save should check that intermediate steps succeed</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/775">github-775</a></td><td>OOXML</td><td>Allow some OPC compliance checks to be tuned. Thanks to Ken Reese</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66260">66260</a></td><td>XWPF</td><td>Add getNumberOfTexts() method</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68094">68094</a></td><td>SXSSF</td><td>Allow to use SXSSFSheet.setArbitraryExtraWidth() to define an adjustment-factor when auto-sizing columns</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57603">57603</a></td><td>HWPF</td><td>Fix reading/writing of documents with many columns</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65190">65190</a></td><td>SS_Common</td><td>Handle decimal format '0#' the same way as Excel</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66425">66425</a></td><td>POI_Overall</td><td>Multiple fixes found by fuzzing Apache POI via oss-fuzz</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66260">66260</a></td><td>XWPF</td><td>Add getNumberOfTexts method to XWPFRun</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69315">69315</a></td><td>HSMF</td><td>Continue processing properties after multivalued properties</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69529">69529</a></td><td>XSSF</td><td>Streamed reading: Log failures to format formulas and numbers instead of stopping processing</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69536">69536</a></td><td>SXSSF</td><td>Fix arbitrary extra width support</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69555">69555</a></td><td>SXSSF</td><td>Handle extra issue where FontSystem is missing</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69583">69583</a></td><td>SS_Common</td><td>Cell copy support does not handle Time only values properly</td> </tr> </tbody> </table> </div> <a name="5.4.0"></a> <h2 class="boxed">Version 5.4.0 (2025-01-08) </h2> <div class="section"> <a name="Summary-N10126"></a> <h3 class="boxed">Summary</h3> <ul> <li>Add support for SOURCE_DATE_EPOCH to allow to create reproducible binary files without creation/modification-timestamp being set</li> <li>Breaking change: Some invalid content in the compressed file-formats for xlsx/docx/pptx/... now fail parsing to prevent handling malicious input incorrectly</li> <li>Upgrade ant dependency to 1.10.15</li> <li>Upgrade batik dependency to 1.18</li> <li>Upgrade commons-codec dependency to 1.17.1</li> <li>Upgrade commons-compress dependency to 1.27.1</li> <li>Upgrade commons-io dependency to 2.18.0</li> <li>Upgrade log4j-api dependency to 2.24.3 and add log4j-bom dependency</li> <li>Upgrade pdfbox dependency to 3.0.3</li> <li>Upgrade xmlbeans dependency to 5.3.0</li> <li>Upgrade xmlsec dependency to 3.0.5</li> <li>Upgrade JaCoCo code-coverage tooling to 0.8.12</li> </ul> <a name="Changes-N10151"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/653">github-653</a></td><td>HSSF</td><td>Adjust HSSFWorkbook.getSheet() to return the first case-insensitive match, similar to XSSF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/655">github-655</a></td><td>XWPF</td><td>Fix searching text in paragraphs when text is spread across multiple runs</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/657">github-657</a></td><td>SXSSF</td><td>Support setting an arbitrary extra width value for column widths - not working - fixed in 69536 (5.4.1)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/670">github-670</a></td><td>XWPF</td><td>XWPFRun.getText should support delInstrText and noBreakHyphen</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/672">github-672</a></td><td>XWPF</td><td>Support removing XWPF Styles</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/673">github-673</a></td><td>OOXML</td><td>Add word10.xsd to poi-ooxml-full</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/733">github-733</a></td><td>SS_Common</td><td>Fix issue with param order in MIRR function evaluation</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66590">66590</a></td><td>POIFS</td><td>Number of blocks used by the property table missing from the file header</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69154">69154</a></td><td>XSSF</td><td>Shifting columns with merged regions generates an error about overlapping regions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69209">69209</a></td><td>SS_Common</td><td>default ignoreMissingFontSystem to true</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69323">69323</a></td><td>POI_Overall</td><td>DefaultTempFileCreationStrategy should worry about OS deleting the temp dir</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69411">69411</a></td><td>XSSF</td><td>add XSSFReader.getSheetIterator</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69418">69418</a></td><td>SS_Common</td><td>Issue when evaluating WORKDAY function that has a cell ref as 2nd param</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69620">69620</a></td><td>OOXML</td><td>Throw exception if xlsx/docx/pptx contains duplicate file names</td> </tr> </tbody> </table> </div> <a name="5.3.0"></a> <h2 class="boxed">Version 5.3.0 (2024-07-02) </h2> <div class="section"> <a name="Summary-N10252"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade log4j-api dependency to 2.23.1</li> <li>Upgrade commons-codec dependency to 1.17.0</li> <li>Upgrade commons-compress dependency to 1.26.2</li> <li>Upgrade commons-io dependency to 2.16.1</li> <li>Upgrade pdfbox dependency to 3.0.2 and graphics2d dependency to 3.0.2</li> <li>Upgrade xmlsec dependency to 3.0.4</li> <li>Upgrade bouncycastle dependency to 1.79</li> <li>Upgrade xmlbeans dependency to 5.2.1</li> </ul> <a name="Changes-N10271"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63189">63189</a></td><td>OOXML</td><td>Add support for hyperlink based relationships which are stored separately from other relationships</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68237">68237</a></td><td>SXSSF</td><td>Some boolean attribute values are written as true instead of 1</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68703">68703</a></td><td>XSLF</td><td>IllegalArgumentException: Unexpected color choice CTFontCollectionImpl when reading font color for a table cell</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68778">68778</a></td><td>SXSSF</td><td>Fix issue in SXSSF when there are missing fonts</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68183">68183</a></td><td>SXSSF</td><td>SXSSFWorkbook now removes temp files when closed - removing need for a separate dispose call</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68987">68987</a></td><td>OOXML</td><td>Support allowStoredEntriesWithDataDescriptor=true when reading zip data</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=69147">69147</a></td><td>OOXML</td><td>Fix regression in date handling when evaluating TEXT function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/578">github-578</a></td><td>SXSSF</td><td>Rework exception handling for missing fonts to make it more robust</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/601">github-601</a></td><td>XDGF</td><td>handle elliptical arcs that have colinear points</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/604">github-604</a></td><td>XDGF</td><td>Support for polylines</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/607">github-607</a></td><td>XWPF</td><td>Support SVGs in XWPF</td> </tr> </tbody> </table> </div> <a name="5.2.5"></a> <h2 class="boxed">Version 5.2.5 (2023-11-25) </h2> <div class="section"> <a name="Summary-N10342"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade commons-io dependency to 2.15.0</li> <li>Upgrade commons-compress dependency to 1.25.0</li> <li>Upgrade log4j-api dependency to 2.21.1</li> <li>Upgrade xmlsec dependency to 3.0.3</li> <li>Upgrade bouncycastle dependency to 1.77</li> <li>Upgrade xmlbeans dependency to 5.2.0</li> </ul> <a name="Changes-N1035B"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67475">67475</a></td><td>SS_Common</td><td>Better support for edge cases in TEXT function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67510">67510</a></td><td>XDDF</td><td>Fix issue where chart axes were defaulting to have blank number formats - which recent versions of Excel treat as corrupted.</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67735">67735</a></td><td>XWPF</td><td>Add Complex scripts support in XWPFRun</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67579">67579</a></td><td>OOXML</td><td>POI 5.2.4 had a regression where it did not close user-provided InputStreams. In POI 5.2.5, user-provided InputStreams are again closed. There are new constructors that allow you to control whether the streams are closed.</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67785">67785</a></td><td>XSSF</td><td>XSSFExcelExtractor does not format formula results like the streaming based extractor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=68094">68094</a></td><td>XSSF</td><td>Improve cell width logic to avoid rounding issues</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/505">github-505</a></td><td>SL_Common</td><td>DrawTextFragment height should include leading space</td> </tr> </tbody> </table> </div> <a name="5.2.4"></a> <h2 class="boxed">Version 5.2.4 (2023-09-28) </h2> <div class="section"> <a name="Summary-N103EC"></a> <h3 class="boxed">Summary</h3> <ul> <li>Discontinued the binary packages to reduce maintenance overhead, please rebuild the sources locally or use Maven Central for binary files</li> <li>Upgrade log4j-api dependency to 2.20.0</li> <li>Upgrade xmlsec dependency to 3.0.2</li> <li>Upgrade batik dependency to 1.17</li> <li>Upgrade pdfbox dependency to 2.0.29, graphics2d to 0.43</li> <li>Upgrade commons-codec dependency to 1.16.0</li> <li>Upgrade commons-compress dependency to 1.24.0</li> <li>Upgrade commons-io dependency to 2.13.0</li> <li>Upgrade curvesapi dependency to 1.08</li> <li>Upgrade SparseBitSet dependency to 1.3</li> <li>Use jdk18on versions of bouncycastle jars (v1.76)</li> </ul> <a name="Changes-N10414"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66598">66598</a></td><td>XSSF</td><td>Fix invalid loop-condition when cleaning up CTCells</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=47950">47950</a></td><td>POI_Overall</td><td>make stream/directory name lookup in OLE2 case insensitive</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66521">66521</a></td><td>POI_Overall</td><td>Provide a utility to clear all thread-locals to avoid reports of memory-leaks in web-application containers</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66436">66436</a></td><td>POI_Overall</td><td>Fix handling padding when decrypting data</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=54373">54373</a></td><td>XSSF</td><td>Include alpha/transparency value when creating an XSSFColor from an AWT Color object</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62272">62272</a></td><td>XSSF</td><td>Include alpha/transparency value when setting a color-value for a font</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65260">65260</a></td><td>SXSSF</td><td>Fix graceful handling of missing font-system on the operating system</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65543">65543</a></td><td>HSSF</td><td>Incomplete Shared String Tables were causing read failures</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66257">66257</a></td><td>XSSF</td><td>NullPointerException in XSSFReader$SheetIterator.next()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66278">66278</a></td><td>XSLF</td><td>Multiple gradient stops at the exact same location causing a rendering failure</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66301">66301</a></td><td>HSMF</td><td>Add a method to properly write the header necessary for a MSG attachment</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66306">66306</a></td><td>XSLF</td><td>Make XSLFDiagramGroupShape public</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66312">66312</a></td><td>XWPF</td><td>Inserting paragraph into table from cursor</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66347">66347</a></td><td>XWPF</td><td>Add theme support to XWPF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66365">66365</a></td><td>XSSF</td><td>Fix issue where cells with formulas and cached results of string type do not properly support shared strings</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66399">66399</a></td><td>XSLF</td><td>Text run highlight colors were ignored</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66401">66401</a></td><td>SS_Common</td><td>Fix parsing formulas with sheet-names which contain single quotes</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66418">66418</a></td><td>XSSF</td><td>Fix performance issue with XSSFSheet.groupRow</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66433">66433</a></td><td>SS_Common</td><td>Improve boolean functions empty cell handling</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66473">66473</a></td><td>SXSSF</td><td>Fix performance issue with SXSSFCell.getColumnIndex()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66475">66475</a></td><td>POI_Overall</td><td>SignatureConfig: remove ThreadLocals and deprecated code associated with them</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66514">66514</a></td><td>POI_Overall</td><td>Remove support for zip/tgz release artifacts</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66532">66532</a></td><td>SXSSF</td><td>Improve performance of SheetDataWriter outputEscapedString</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66584">66584</a></td><td>OOXML</td><td>Ensure ZipPackage closes input stream when exceptions happen</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66614">66614</a></td><td>SS_Common</td><td>Issue where OFFSET function applies limits that should only apply to xls format spreadsheets</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66644">66644</a></td><td>POI_Overall</td><td>Make jar build reproducible</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66661">66661</a></td><td>XSSF</td><td>Fix issue with adding table formulas</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66988">66988</a></td><td>XWPF</td><td>XWPFTableCell: make setText fully replace the text and add appendText method to append</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67005">67005</a></td><td>XSLF</td><td>Basic for reading audio files in pptx files</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=67396">67396</a></td><td>OOXML</td><td>Set standalone="yes" in XML declarations when writing OOXML format files</td> </tr> </tbody> </table> </div> <a name="5.2.3"></a> <h2 class="boxed">Version 5.2.3 (2022-09-16) </h2> <div class="section"> <a name="Summary-N10615"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade graphics2d dependency to 0.40, pdfbox to 2.0.26</li> <li>Upgrade xmlsec dependency to 3.0.0</li> <li>Upgrade xmlbeans dependency to 5.1.1</li> <li>Upgrade log4j-api dependency to 2.18.0</li> <li>Speed up processing of formulas with column-ranges, e.g. VLOOKUP(A4,$D:$E,2,0)</li> <li>Speed up compilation of jar-files-only builds by avoiding direct dependency on test-execution</li> <li>Avoid some more possible overly large memory allocations on certain input documents</li> </ul> <a name="Changes-N10631"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=51037">51037</a></td><td>SS_Common</td><td>setDefaultColumnStyle() in XSSFSheet/SXSSFSheet was not working as expected</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55330">55330</a></td><td>SS_Common</td><td>add PageMargin enum</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=56155">56155</a></td><td>OOXML</td><td>Support version property in CoreProperties</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58468">58468</a></td><td>SS_Common</td><td>Support DAYS function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63575">63575</a></td><td>XWPF</td><td>Support capitalized text in XWPFWordExtractor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63576">63576</a></td><td>HWPF</td><td>Support capitalized text in WordExtractor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65562">65562</a></td><td>SXSSF</td><td>SXSSF doesn't update dimension field</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65473">65473</a></td><td>XSLF</td><td>When slides were copied, the text shapes were still referencing original slide</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65854">65854</a></td><td>OOXML</td><td>Use revert() instead of close() when OPCPackage is opened read-only</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65973">65973</a></td><td>XSSF</td><td>Row shifting does not properly handle hyperlinks that span multiple cells</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65988">65988</a></td><td>SS_Common</td><td>RATE function fails in some cases</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65993">65993</a></td><td>XSSF</td><td>change XSSFHyperlink code that copies HSSFWorkbook to respect cell ranges</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66022">66022</a></td><td>SS_Common</td><td>Fix issue with parsing formulas that have sheet names containing certain chars</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66047">66047</a></td><td>SS_Common</td><td>Fix rounding issue in MROUND function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66079">66079</a></td><td>XWPF</td><td>Fix bug where XWPFNumbering.removeAbstractNum removes by list index, not abstractNumId</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/321">github-321</a></td><td>SS_Common</td><td>DataFormatter issue with rounding in some use cases</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/330">github-330</a></td><td>SS_Common</td><td>Support AVERAGEIF function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66052">66052</a></td><td>SS_Common</td><td>XSSFColor could not be used the same time as org.apache.poi.ss.util classes</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66083">66083</a></td><td>SS_Common</td><td>Support CEILING.MATH and FLOOR.MATH functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66087">66087</a></td><td>SS_Common</td><td>support case insensitive matching in D* functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66090">66090</a></td><td>SS_Common</td><td>add support for DCOUNT, DCOUNTA, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP and DPRODUCT functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66092">66092</a></td><td>SS_Common</td><td>Add STDEVP, STDEVA, STDEVPA, VARA and VARPA functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66093">66093</a></td><td>SS_Common</td><td>add support for unimplemented subfunctions to SUBTOTAL function</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66094">66094</a></td><td>SS_Common</td><td>add support for STDEV.S, STDEV.P, VAR.S and VAR.P functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66095">66095</a></td><td>SS_Common</td><td>add support for POISSON.DIST function</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66097">66097</a></td><td>SS_Common</td><td>Support CEILING.PRECISE and FLOOR.PRECISE functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66098">66098</a></td><td>SS_Common</td><td>D* functions should support wildcard matches</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66105">66105</a></td><td>SS_Common</td><td>Support excel correl, covar, pearson and forecast functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66115">66115</a></td><td>HSSF</td><td>Some Password protected XLS files are not read</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66123">66123</a></td><td>XSSF</td><td>Support the gte attribute with XSSFConditionalFormattingThreshold</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66145">66145</a></td><td>OOXML</td><td>generate poi-ooxml-full classes for dml-drawing xsd</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66146">66146</a></td><td>OOXML</td><td>generate poi-ooxml-full classes for threaded comment and word12 xsds</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66173">66173</a></td><td>SS_Common</td><td>add Sheet createSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, PaneType activePane) to eventually replace the existing createSplitPane method (that has a bug in XSSFSheet)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/360">github-360</a></td><td>HSSF</td><td>HSSFExtendedColor was not setting RGB colors properly</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66176">66176</a></td><td>XSLF</td><td>Integrate SmartArt diagrams from powerpoint presentations</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66181">66181</a></td><td>SS_Common</td><td>POI's implementation of VALUE function did not properly handle empty string input</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66187">66187</a></td><td>XWPF</td><td>Calling getTextHighlightColor() or getEmphasisMark() on XWPFRun can lead to corruption of file</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66211">66211</a></td><td>XSSF</td><td>XSSFTable.updateHeaders did not work for Worksheets created using current Excel versions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66212">66212</a></td><td>XSSF</td><td>XSSFSheet.removeTable did not remove the links to the table part reference from the sheet</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66213">66213</a></td><td>XSSF</td><td>XSSFWorkbook.cloneSheet does not clone XSSFTables linked from the sheet</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66215">66215</a></td><td>XSSF</td><td>Shifting rows or columns can damage formulas in tables</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66216">66216</a></td><td>XSSF</td><td>XSSFPivotTable.getPivotCacheDefinition() does not work properly when XSSFPivotTable was read from an existing *.xlsx file</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66230">66230</a></td><td>SXSSF</td><td>SXSSFWorkbook should work even when fonts not installed on OS</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=66242">66242</a></td><td>XSLF</td><td>Issue with orphaned (in package) images and notes post slide removal</td> </tr> </tbody> </table> </div> <a name="5.2.2"></a> <h2 class="boxed">Version 5.2.2 (2022-03-19) </h2> <div class="section"> <a name="Summary-N10912"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade log4j-api dependency to 2.17.2 and graphics2d dependency to 0.35 as well as some test dependencies</li> </ul> <a name="Changes-N1091C"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65915">65915</a></td><td>SS_Common</td><td>Fix issue where Boolean functions (AND, OR) do not work properly in array context</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65934">65934</a></td><td>XSLF</td><td>add removeTextParagraph to text box API</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65935">65935</a></td><td>XSLF</td><td>add removeTextRun to paragraph API</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65939">65939</a></td><td>XSSF</td><td>Fix stackoverflow issue when removing formulas with circular references</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65943">65943</a></td><td>SXSSF</td><td>Support rich text strings in SXSSFWorkbook (only when shared string table is used)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65946">65946</a></td><td>OOXML</td><td>POIXMLPropertiesTextExtractor returns duplicate key for Core properties</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65950">65950</a></td><td>POI_Overall</td><td>POI 5.2.1 can allocate byte arrays that are too big</td> </tr> </tbody> </table> </div> <a name="5.2.1"></a> <h2 class="boxed">Version 5.2.1 (2022-03-03) </h2> <div class="section"> <a name="Summary-N109AD"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade curvesapi dependency to 1.07</li> </ul> <a name="Changes-N109B7"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65887">65887</a></td><td>POI_Overall</td><td>IOUtils.toByteArray did not fully take into account value set by IOUtils.setByteArrayMaxOverride</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60541">60541</a></td><td>SS_Common</td><td>Collapsing a column group was incorrectly implemented</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62857">62857</a></td><td>SS_Common</td><td>DOLLAR function is not properly implemented</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65792">65792</a></td><td>SS_Common</td><td>Multiplication in cell formulas can have small rounding issues</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65839">65839</a></td><td>SS_Common</td><td>Picture resize can lead to infinite loop</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65846">65846</a></td><td>SS_Common</td><td>Add support for NUMBERVALUE function</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65850">65850</a></td><td>SS_Common</td><td>Add support for Normal Distribution functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65870">65870</a></td><td>SS_Common</td><td>Add support for BESSELJ function</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65871">65871</a></td><td>SS_Common</td><td>Add support for DOLLARDE and DOLLARFR functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65879">65879</a></td><td>SS_Common</td><td>Add support for WORKDAY.INTL functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65899">65899</a></td><td>HMEF</td><td>Fix issue where malformed TNEF file can cause memory issues</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65908">65908</a></td><td>OPC</td><td>XAdES-XL modifications due to specification check errors</td> </tr> </tbody> </table> </div> <a name="5.2.0"></a> <h2 class="boxed">Version 5.2.0 (2022-01-14) </h2> <div class="section"> <a name="Summary-N10A98"></a> <h3 class="boxed">Summary</h3> <ul> <li>Refactor to XSSFReader, SharedStringsTable, CommentsTable and ThemesTable to make them more extensible</li> <li>Upgrade log4j-api dependency to 2.17.1</li> <li>Upgrade BouncyCastle dependency to 1.70</li> <li>Upgrade PDFBox Graphics2d dependency to 0.34 and PDFBox dependency to 2.0.25</li> </ul> <a name="Changes-N10AAB"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65668">65668</a></td><td>OOXML</td><td>upgrade to xmlsec 2.3.0 - make secure validation configurable</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65672">65672</a></td><td>OOXML</td><td>Digital Signature - set commitment type and purpose</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65676">65676</a></td><td>XSSF</td><td>Issue in XSSFReader where string builder is not always cleared between cell reads</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65694">65694</a></td><td>HSLF</td><td>handle date/time fields and formats</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/281">github-281</a></td><td>SS_Common</td><td>Cell Conditional Formatting: Change regex to account for decimals with no leading digit</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/273">github-273</a></td><td>SS_Common</td><td>Log warning when long sheet names are trimmed</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/243">github-243</a></td><td>SS_Common</td><td>Add support for XLOOKUP and XMATCH functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/290">github-290</a></td><td>POI_Overall</td><td>Customize Spliterator implementations for better parallelism</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63211">63211</a></td><td>SS_Common</td><td>DataFormatter incorrectly formats data formats with escaped percent character</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64732">64732</a></td><td>XSSF</td><td>XSSFSheet.createTable generates corrupted file when a header's cell contains a line break</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65701">65701</a></td><td>OOXML</td><td>Password Protecting a document when Saxon is on classpath can corrupt the output</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65703">65703</a></td><td>SS_Common</td><td>DataFormatter: add setUse4DigitYearsInAllDateFormats(boolean) method with default of false</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65730">65730</a></td><td>SS_Common</td><td>DataFormatter: add setUseCachedValuesForFormulaCells(boolean) method with default of false</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65715">65715</a></td><td>OOXML</td><td>Fix issue in XSSFSheet getDrawingPatriarch</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65738">65738</a></td><td>OOXML</td><td>Fix issue with excessive logging of invalid parts in OOXML files</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65766">65766</a></td><td>SS_Common</td><td>Cell copy does not respect rich text</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65772">65772</a></td><td>POI_Overall</td><td>stop using file deleteOnExit in DefaultTempFileCreationStrategy</td> </tr> </tbody> </table> </div> <a name="5.1.0"></a> <h2 class="boxed">Version 5.1.0 (2021-11-01) </h2> <div class="section"> <a name="Summary-N10BDC"></a> <h3 class="boxed">Summary</h3> <ul> <li>XDDF - bug fixes</li> <li>Upgrade Batik dependency to 1.14</li> <li>Upgrade BouncyCastle dependency to 1.69 (including adding dependency on bcutil jar)</li> <li>Upgrade Commons-Compress dependency to 1.21</li> <li>Upgrade XMLSec dependency to 2.2.3</li> <li>Upgrade PDFBox Graphics2d dependency to 0.33 (and test with PDFBox 2.0.24)</li> <li>Add commons-io 2.11.0 as a dependency</li> <li>Upgrade XMLBeans to 5.0.2</li> <li>Internal logging in POI now uses Apache Log4J 2</li> <li>Small refactor to XSSFReader to make it more extensible - should not affect most users unless they subclass XSSFReader</li> <li>By default, no DTDs will be accepted in XML files. This can be relaxed by setting POIXMLTypeLoader.DEFAULT_XML_OPTIONS.setDisallowDocTypeDeclaration(false).</li> </ul> <a name="Changes-N10C04"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/221">github-221</a></td><td>XSLF</td><td>XSLFTable - revert addRow to behaviour before 4.1.2</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65016">65016</a></td><td>XDDF</td><td>Don't throw exception on empty data source</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64950">64950</a></td><td>XDDF</td><td>Set hole size for doughnut chart</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63901">63901</a></td><td>XSSF</td><td>XSSFDrawing - import chart from other drawing</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63902">63902</a></td><td>XSSF</td><td>XSSFWorkbook - reference cloned sheet in cloned chart data</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=54470">54470</a></td><td>XSSF</td><td>XSSFWorkbook - clone sheet with chart</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57835">57835</a></td><td>XSLF</td><td>XSLFSlide - import slide notes when importing slide content</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/228">github-228</a></td><td>XDDF</td><td>Manipulate individual data point properties</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65192">65192</a></td><td>HSSF</td><td>Allow change of EncryptionMode</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65206">65206</a></td><td>POI_Overall</td><td>Migrate ant / maven to gradle build</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65228">65228</a></td><td>XSLF</td><td>the method getCap() does not work correctly in xslf.usermodel.XSLFTextRun</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65214">65214</a></td><td>OOXML</td><td>Document signed by POI reported as 'partially' signed</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65085">65085</a></td><td>HSLF</td><td>LineRect shall throw more specific exceptions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64844">64844</a></td><td>SL_Common</td><td>Incorrect sizes of images in SVG</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65304">65304</a></td><td>POI_Overall</td><td>Add commons-io as a dependency</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64473">64473</a></td><td>OOXML</td><td>Handle issue where OOXML file has metadata and metadata.xml</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60924">60924</a></td><td>SS_Common</td><td>Support IFS and SWITCH functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64633">64633</a></td><td>SS_Common</td><td>Support TEXTJOIN function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65230">65230</a></td><td>SS_Common</td><td>TRIM function should trim extra spaces between words</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65464">65464</a></td><td>XSSF</td><td>Fix issue with removing parent formula when shared formulas are used</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65467">65467</a></td><td>SS_Common</td><td>Support IFNA function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65471">65471</a></td><td>XSSF</td><td>Add support for T literal in DateTime formats</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65475">65475</a></td><td>SS_Common</td><td>SUMIF and SUMIFS functions do not properly handle #N/A values</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/242">github-242</a></td><td>SS_Common</td><td>add support for MAXIFS, MINIFS, AVERAGEIFS functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65501">65501</a></td><td>XSLF</td><td>Use viewbox when rendering SVG images</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65581">65581</a></td><td>OOXML</td><td>add optional support in ZipArchiveFakeEntry to use a temp file</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65595">65595</a></td><td>SS_Common</td><td>Strip color formatting in headers and footers</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65606">65606</a></td><td>SS_Common</td><td>Fix issues with WEEKNUM function evaluation</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65612">65612</a></td><td>XSLF</td><td>XSLF CustomGeometry - replace XmlStreamReader access with XmlBeans delegate</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=49202">49202</a></td><td>SS_Common</td><td>Support PERCENTRANK and related functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64258">64258</a></td><td>SS_Common</td><td>Support TDIST and related functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65490">65490</a></td><td>XSSF</td><td>Better support for shared hyperlinks</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65042">65042</a></td><td>OPC</td><td>Add support to ZipPackage to allow temp files to be used to save memory (useful for writing xlsx/pptx/docx files with pictures, etc.).</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65372">65372</a></td><td>OPC</td><td>Allow ZipSecureFile.setMaxEntrySize to accept sizes above 4Gb</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65331">65331</a></td><td>XWPF</td><td>Fix issue in XWPFTable.setTableAlignment(TableRowAlign tra)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65623">65623</a></td><td>OPC</td><td>Create XAdES-T signature with XAdESXLSignatureFacet</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62040">62040</a></td><td>SS_Common</td><td>QUOTIENT function does not support cell references</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64542">64542</a></td><td>OPC</td><td>Allow creation of POIFSFileSystem instances from FileChannels but with an optional flag to prevent POI from closing the channel</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65452">65452</a></td><td>SS_Common</td><td>WorkbookFactory.create(File, ...) should throw exception if the input file is not in a supported format</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65551">65551</a></td><td>XSLF</td><td>Incorrect fetching paragraph and text runs props from master shape</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65634">65634</a></td><td>XSLF</td><td>SlideShowFactory.create(File, ...) should throw exception if the input file is not in a supported format</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65648">65648</a></td><td>SXSSF</td><td>Remove finalizer on SXSSF SheetDataWriter</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65650">65650</a></td><td>POI_Overall</td><td>Use image/x-pict as mime type for pict format pictures (previous versions used a mix of image/pict and image/x-pict)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65653">65653</a></td><td>HSLF</td><td>HSLF FillType for texture and background color fills ignored</td> </tr> </tbody> </table> </div> <a name="5.0.0"></a> <h2 class="boxed">Version 5.0.0 (2021-01-20) </h2> <div class="section"> <a name="Summary-N10EE5"></a> <h3 class="boxed">Summary</h3> <ul> <li>Upgrade to ECMA-376 5th edition (transitional) schemas - expect API breaks when using XmlBeans directly some smaller changes are necessary when code is using the low-level CT... classes </li> <li>Change artifact names of poi-/ooxml-schemas to poi-ooxml-lite/full</li> <li>ooxml-security is part of poi-ooxml-full (known as ooxml-schemas) now and won't be provided separately</li> <li>updated dependencies to XMLSec 2.2.1, Bouncycastle 1.68, Commons-Codec 1.15, Commons-Compress 1.20</li> <li>XWPF - improvements in table and paragraph</li> <li>XSLF - improvements for paragraph</li> <li>provide JigSaw modules - some classes moved between packages for the JDK 9+ support, e.g. ExtractorFactory, so imports need to be adjusted</li> <li>removed dependencies to jaxb</li> <li>removed deprecated code</li> <li>new experimental DeferredSXSSFWorkbook which creates fewer temp files by lazily generating rows (see DeferredGeneration in poi-examples)</li> </ul> <a name="Changes-N10F0A"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64494">64494</a></td><td>XSSF</td><td>Ensure "applyAlignment" in cell-styles is enabled when necessary</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64450">64450</a></td><td>OOXML</td><td>Allow to parse a file where the relationship-id is an empty string</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64750">64750</a></td><td>XSSF</td><td>Do not use CTDataValidations.getCount(), instead only rely on getDataValidationArray</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64986">64986</a></td><td>SS_Common</td><td>Support missing or blank match_type for function Match</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64838">64838</a></td><td>XWPF</td><td>Do not populate cells with a paragraph when loading an existing document</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65009">65009</a></td><td>HSLF</td><td>Use correct index for 1-based pictures</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64460">64460</a></td><td>XSSF</td><td>Fix invalid moving of merged regions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64791">64791</a></td><td>HSSF</td><td>Use proper position for the WriteAccessRecord</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64238">64238</a></td><td>SS_Common</td><td>Make LOOKUP functions deal with empty last arg correctly</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64322">64322</a></td><td>POIFS</td><td>Improve performance of reading OLE2 files</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64393">64393</a></td><td>SS_Common</td><td>Handle MissingArgEval in relational operators</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64420">64420</a></td><td>XSSF</td><td>Avoid NullPointerException in XSSFReader.SheetIterator.next() if files contain macros</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/177">github-177</a></td><td>SS_Common</td><td>Avoid NullPointerException if RangeCopier encounters empty/missing rows</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63294">63294</a></td><td>SS_Common</td><td>Add some more methods to allow to use CellType everywhere</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td></td><td>XSSF</td><td>Fix regression introduced via Bug 60845: There are more items in CTBorder that need to be handled in equals()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63845">63845</a></td><td>XWPF</td><td>Adjust handling of formula-cells to fix regression with missing re-calculation introduced in 4.1.0</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55966">55966</a></td><td>XWPF</td><td>Include content control text in word extraction also if it is part of a paragraph</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64244">64244</a></td><td>XSSF</td><td>Take the replacement of RichText strings into account when computing length of strings</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td></td><td>SS_Common</td><td>SS method to check if a Named Range is hidden or not</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td></td><td>SS_Common</td><td>SS method to check if a Named Range is hidden or not</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/167">github-167</a></td><td>HSMF</td><td>HSMF enhancements - NamedIdChunk, MultiValueChunks, ByteChunkDeferred</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td></td><td>SS_Common</td><td>Fix incorrect handling of format which should not produce any digit for zero</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/buglist.cgi?bug_id=58896,52834">58896 52834</a></td><td>SS_Common</td><td>Speed up auto-sizing of columns when the sheet contains merged regions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64186">64186</a></td><td>OPC</td><td>Decrease usage of ThreadLocals in XML Signature API</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64213">64213</a></td><td>SS_Common</td><td>Picture.resize(double scale) scales width wrong for small pictures and when dx1 is set</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63712">63712</a></td><td>OPC</td><td>upgrading xmlsec causes junit tests to fail</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64241">64241</a></td><td>XSLF</td><td>XSLF - Wrong scheme colors used when rendering</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63624">63624</a></td><td>XWPF</td><td>Method setText in XWPFTableCell updates the xml and also updates the runs and iruns</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/170">github-170</a></td><td>XWPF</td><td>XWPFTableCell does not process bodyElements when handle paragraph</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/171">github-171</a></td><td>XWPF</td><td>XWPFNumbering.addAbstractNum will definitely throw an exception</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64301">64301</a></td><td>OPC</td><td>Allow try-with-resources with OPCPackage.revert()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63745">63745</a></td><td>HSSF</td><td>Add traversing and debugging interface to HSSF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64350">64350</a></td><td>POI_Overall</td><td>Sonar fix - "Iterator.next()" methods should throw "NoSuchElementException"</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57843">57843</a></td><td>HWPF</td><td>RuntimeException on extracting text from Word 97-2004 Document</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55505">55505</a></td><td>HSSF</td><td>CountryRecord not found</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64387">64387</a></td><td>POIFS</td><td>Big POIFS stream result in OOM</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64411">64411</a></td><td>POI_Overall</td><td><b>Provide JigSaw modules (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64441">64441</a></td><td>SS_Common</td><td>Synchronize code that initialises WorkbookFactory</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63819">63819</a></td><td>SS_Common</td><td>Support DateValue function</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/179">github-179</a></td><td>SS_Common</td><td>Add an option for RangeCopier.copyRange() also clone styles</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63290">63290</a></td><td>XSLF</td><td>Retrieve default run properties from paragraph</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64512">64512</a></td><td>POIFS</td><td>Ole10Native aka embedded / object packager - handle UTF16 variants</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64561">64561</a></td><td>XWPF</td><td>XWPFSDTContent.getText() is empty for nested SDT elements</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64595">64595</a></td><td>SXSSF</td><td>Missing quoting of pre-evaluated string values in formula cells causes corrupt files</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64693">64693</a></td><td>HEMF</td><td>POI HwmfGraphics cannot read the embedded document title</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64716">64716</a></td><td>HWMF</td><td>WMF font typeface charset encoding error</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64773">64773</a></td><td>POI_Overall</td><td>Visual signatures for .xlsx/.docx</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64817">64817</a></td><td>POIFS</td><td>Fix issue in testXLSXinPPT</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/193">github-193</a></td><td>SS_Common</td><td>Change TRUNC implementation to use MathX</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64867">64867</a></td><td>SL_Common</td><td>Provide PDF rendering with PPTX2PNG</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64964">64964</a></td><td>SS_Common</td><td>Converting cell values to boolean should throw IllegalStateException instead of RuntimeException when conversion is not possible</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64971">64971</a></td><td>XSSF</td><td>XSSFFont setCharset(FontCharset) should use latest class instead of deprecated one</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60397">60397</a></td><td>XSSF</td><td>Improve performance of cell merge</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/206">github-206</a></td><td>SXSSF</td><td>Improve performance of SXSSF cell evaluation</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64976">64976</a></td><td>SS_Common</td><td>Change some methods to return ints instead of shorts (Font and CellStyle)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=56205">56205</a></td><td>OOXML</td><td><b>Upgrade OOXML schema to 3rd edition (transitional) (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64979">64979</a></td><td>OOXML</td><td>Change artifact names of poi-/ooxml-schemas</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64981">64981</a></td><td>OOXML</td><td><b>Upgrade OOXML schema to 5th edition (transitional) (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64876">64876</a></td><td>XSLF</td><td>Unable to convert pptx to pdf</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65026">65026</a></td><td>POI_Overall</td><td>Migrate tests to Junit 5</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/207">github-207</a></td><td>POI_Overall</td><td>Use SLF4J instead of commons-logging - use jcl-over-slf4j</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65061">65061</a></td><td>XSSF</td><td>Handle VmlDrawings containing spreadsheet-ml default namespace</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=65063">65063</a></td><td>HSLF</td><td>WMF parsing failed on closed empty polygon</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/198">github-198</a></td><td>POI_Overall</td><td>Remove jdk.charset module dependency for spreadsheets generation</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/196">github-196</a></td><td>OOXML</td><td>Delete unused certificate exceptions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/191">github-191</a></td><td>SS_Common</td><td>Fix RuntimeException on array formula referencing blank cell</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/189">github-189</a></td><td>SS_Common</td><td>Move date parsing logic to DateParser</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/187">github-187</a></td><td>XSSF</td><td>Add length validation for Excel DataValidations that are list literals</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/184">github-184</a></td><td>SXSSF</td><td>New EmittingSXSSFWorkbook</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/176">github-176</a></td><td>XSSF</td><td>Remove limit on number of rules in XSSFSheetConditionalFormatting</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/177">github-177</a></td><td>HSSF</td><td>Avoid NullPointerException if RangeCopier encounters empty/missing rows</td> </tr> </tbody> </table> </div> <a name="4.1.2"></a> <h2 class="boxed">Version 4.1.2 (2020-02-17) </h2> <div class="section"> <a name="Summary-N11392"></a> <h3 class="boxed">Summary</h3> <ul> <li>Removed a lot of internal uses of StringBuffers</li> <li>XDDF - some work on better chart support</li> <li>Common SL / EMF - ongoing rendering fixes</li> <li>XSLF - OOM fixes when parsing arbitrary shape ids + a new dependency to SparseBitSet 1.2</li> <li>updated dependencies to Bouncycastle 1.64</li> </ul> <a name="Changes-N113A8"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64015">64015</a></td><td>POI_Overall</td><td>Swap zaxxer.com:SparseBitSet for java.util.BitSet</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63788">63788</a></td><td>XWPF</td><td>When removing AbstractNum match by abstractNumId, not list index</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63940">63940</a></td><td>POI_Overall</td><td>Avoid endless loop/out of memory on string-replace with empty search string</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63700">63700</a></td><td>POI_Overall</td><td>Make D* functions work with numeric result column</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63960">63960</a></td><td>SXSSF</td><td>Write pre-evaluated string-values in formula cells with the correct type</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63984">63984</a></td><td>POI_Overall</td><td>Function AND / OR should treat missing parameters as FALSE</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63749">63749</a></td><td>POI_Overall</td><td>Make getFirstRowNum() and getFirstCellNum() return -1 consistently with empty data</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63569">63569</a></td><td>POI_Overall</td><td>Make IOUtils.setByteArrayMaxOverride() work correctly</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td></td><td>XSLF</td><td>Add, insert and remove columns on XSLFTable</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63842">63842</a></td><td>POI_Overall</td><td>Fix issue with fractions where the whole number part is too large to store as an int</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63889">63889</a></td><td>XDDF</td><td>Produce valid PPTX file with several chart series</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63918">63918</a></td><td>SL_Common XSLF</td><td>Fix texture fill - scale stretched images correctly</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td></td><td>XDDF</td><td>Add Doughnut chart data series support</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63955">63955</a></td><td>HMEF</td><td>HMEFContentsExtractor fails to extract content from winmail.dat</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63927">63927</a></td><td>POI_Overall</td><td>Inconsistent mapping of Norwegian locales for date formats</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/163">github-163</a></td><td>XSSF</td><td>Add set level numbering on XWPFParagraph</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/164">github-164</a></td><td>XSSF</td><td>Fix Bug in XSSFTable.setCellReferences when table is single cell</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64004">64004</a></td><td>POI_Overall</td><td>Replace Cloneable / clone() with copy constructor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64036">64036</a></td><td>POI_Overall</td><td>Replace reflection calls in factories for Java 9+</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64044">64044</a></td><td>POI_Overall</td><td>Fix issue with setCellValue(LocalDate) not supporting nulls properly</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64088">64088</a></td><td>SL_Common XSLF</td><td>SlideShow rendering fixes</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64098">64098</a></td><td>XWPF</td><td>XWPFRun: Whitespace in text not preserved if starting with tab character.</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64108">64108</a></td><td>POI_Overall</td><td>unsafe pipe character ("|") in Relationship target attribute is not being encoded into a '%7C'.</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/166">github-166</a></td><td>XDDF</td><td>Expose invert if negative on bar charts</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63998">63998</a></td><td>HSSF</td><td>Support commas, exclamation marks correctly in AreaReference</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64045">64045</a></td><td>XSSF</td><td>XSSFWorkbook constructor doesn't close ZipFile if an exception occurs</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=64130">64130</a></td><td>HSSF</td><td>Regression in OldSheetRecord</td> </tr> </tbody> </table> </div> <a name="4.1.1"></a> <h2 class="boxed">Version 4.1.1 (2019-10-20) </h2> <div class="section"> <a name="Summary-N11573"></a> <h3 class="boxed">Summary</h3> <ul> <li>XSSF: Memory improvements which use much less memory while writing large xlsx files</li> <li>XDDF: Improved chart support: more types and some API changes around angles and width units</li> <li>updated dependencies to Bouncycastle 1.62, Commons-Codec 1.13, Commons-Collections4 4.4, Commons-Compress 1.19</li> <li>XWPF: Additional API methods</li> <li>XSSF: Fixes to XSSFSheet.addMergedRegion() and XSSFRow.shiftRows()</li> <li>EMF/HSLF: Rendering fixes</li> <li>CVE-2019-12415 - XML External Entity (XXE) Processing in Apache POI</li> </ul> <a name="Changes-N1158F"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63774">63774</a></td><td>POI_Overall</td><td>Cache pids to speed up custom properties "add" method</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63779">63779</a></td><td>SS_Common</td><td>Add support for the new Java date/time API added in Java 8</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59322">59322</a></td><td>HWPF</td><td>Avoid NullPointerException when reading Word Document with tables and a cell with a null descriptor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61490">61490</a></td><td>HWPF</td><td>Read cells of tables correctly in cases where the last cell is not 'fake'</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td></td><td>HWPF</td><td>Do not use WeakReference for parents in Ranges to avoid spurious failures in tests</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63657">63657</a></td><td>XSSF</td><td>Fix regression with memory usage in XSSFRow.onDocumentWrite and some other temporary memory leaks</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63842">63842</a></td><td>SS_Common</td><td>FractionFormat casts whole part of the value into 'int'</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63818">63818</a></td><td>HSLF</td><td>Allow multiple charsets for same font typeface</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63768">63768</a></td><td>XSSF</td><td>XSSFExportToXml adjust settings on SchemaFactory</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63541">63541</a></td><td>XSLF</td><td>NullPointerException from XSLFSimpleShape.getAnchor for empty xfrm tags</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63745">63745</a></td><td>POI_Overall</td><td>Add traversing and debugging interface</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/buglist.cgi?bug_id=57423,62711">57423 62711</a></td><td>XSSF</td><td>Fix regression when XSSFRow.shiftRows() is used</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63580">63580</a></td><td>SL_Common HSLF XSLF</td><td>Fix texture paint handling</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59004">59004</a></td><td>HSLF</td><td>HSLF rendering - adjust values for presetShapeDefinition differs in HSLF/XSLF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td></td><td>HSLF</td><td>Don't fallback to master shape properties, if master shape is not assigned</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td></td><td>POI_Overall</td><td>Add a ThreadLocalUtil.clearAllThreadLocals which can be used to clear thread-locals</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63371">63371</a></td><td>XSSF</td><td>XSSFSheet.addMergedRegion should adjust count of merged cells</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63073">63073</a></td><td>XSSF</td><td>Return value of XSSFSheet.addMergedRegion is off by one</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=54803">54803</a></td><td>OPC</td><td>Error opening XLSX after saving with a Drawing using POI</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/135">github-135</a></td><td>XDDF</td><td>Support to create new chart without reading template</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/143">github-143</a></td><td>HPSF</td><td>MAPIType.isFixedLength: not true in case of length > 8</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/144">github-144</a></td><td>XDDF</td><td>Support for seven new chart types</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/149">github-149</a></td><td>HSMF</td><td>improve MAPIMessage.getHtmlBody</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/150">github-150</a></td><td>XWPF</td><td>Add XWPFPicture getWidth and getDepth methods</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/151">github-151</a></td><td>XWPF</td><td>Add XWPFRun getStyle method</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/152">github-152</a></td><td>XWPF</td><td>Add XWPFParagraph setKeepNext method</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/153">github-153</a></td><td>XWPF</td><td>Add XWPFParagraph createHyperlinkRun method</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/154">github-154</a></td><td>SXSSF</td><td>Improved support for writing large files</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/157">github-157</a></td><td>OOXML</td><td>Add setters to POIXMLProperties</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63153">63153</a></td><td>XDDF</td><td>Enable safe removal of data series from charts</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59623">59623</a></td><td>XDDF</td><td>Provide example of threshold line in bar chart</td> </tr> </tbody> </table> </div> <a name="4.1.0"></a> <h2 class="boxed">Version 4.1.0 (2019-04-09) </h2> <div class="section"> <a name="Summary-N11797"></a> <h3 class="boxed">Summary</h3> <ul> <li>Improved support/fixes for Java 9+ and IBM JVM</li> <li>New EMF renderer and support of SVG images in XSLF</li> <li>Security, stability and memory/resource handling improvements</li> <li>Various bug fixes across function and conditional format rule evaluation</li> <li>Upgrade to XMLBeans 3.1.0</li> <li>Upgrade to Bouncycastle 1.61</li> <li>Upgrade to Curvesapi 1.06</li> <li>Upgrade to Commons-Codec 1.12</li> <li>Upgrade to Commons-Collections4 4.3</li> <li>Upgrade to XMLSec 2.1.2</li> </ul> <a name="Changes-N117BC"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63200">63200</a></td><td>XSLF</td><td>Avoid a possible NullPointerException in XSLFShape.selectPaint()</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60724">60724</a></td><td>SS_Common</td><td>Implement 'ignore hidden rows' variations for existing implemented variants</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63264">63264</a></td><td>SS_Common</td><td>Conditional Format rule evaluation calculates relative references incorrectly</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61652">61652</a></td><td>SS_Common</td><td>Fix NPE in EDATE function when date evaluates to an invalid value</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62151">62151</a></td><td>POIFS</td><td>Work around illegal reflective access in Java 9+ when freeing buffers</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63029">63029</a></td><td>OPC</td><td>OPCPackage Potentially clobbers files on close()</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62980">62980</a></td><td>SS_Common XSSF HSSF</td><td>Make D* functions ignore case in headings</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60977">60977</a></td><td>XSSF</td><td>Adding custom properties creates invalid .xlsx file on second write</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60460">60460</a></td><td>SL_Common</td><td>Null pointer exception in ExternSheetNameResolver.prependSheetName method</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60845">60845</a></td><td>XSSF</td><td>Fix copying styles/conditional formatting</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63054">63054</a></td><td>SS_Common XSSF HSSF</td><td>Improved evaluation of array formulas with errors in arguments</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63047">63047</a></td><td>POI_Overall</td><td>Make POILogger subclassable</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62904">62904</a></td><td>SS_Common XSSF HSSF</td><td>Support array arguments in IF and logical IS*** functions</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63028">63028</a></td><td>SL_Common XSLF HSLF</td><td>Provide font embedding for slideshows</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61532">61532</a></td><td>SXSSF</td><td>Fix setting values/types during formula evaluation for SXSSF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62629">62629</a></td><td>OPC</td><td>Allow to handle files with invalid content types for pictures</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62839">62839</a></td><td>SL_Common</td><td>Fix MathX.floor for negative n</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62884">62884</a></td><td>SL_Common</td><td>Sheetnum is not checked in InternalWorkbook.setSheetHidden()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62886">62886</a></td><td>OPC</td><td>Regression extracting text from corrupted docx files</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63017">63017</a></td><td>SL_Common XSLF</td><td>Remove rows from a XSLFTable</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60656">60656</a></td><td>SL_Common XSLF HSLF</td><td>EMF image support in slideshows</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62365">62365</a></td><td>XSLF</td><td>SVG image support in XSLF</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/136">github-136</a></td><td>XSSF</td><td>Support GEOMEAN function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63011">63011</a></td><td>OPC</td><td>Multiple digital signature in excel file broke first signature</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62999">62999</a></td><td>SL_Common</td><td>IBM JDK JIT causes AIOOBE in TexturePaintContext</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62994">62994</a></td><td>POI_Overall</td><td>IBM JCE workarounds</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62966">62966</a></td><td>SL_Common</td><td>init presetShapeDefinitions.xml fail under IBM jdk</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62953">62953</a></td><td>SL_Common XSLF HSLF</td><td>Rendering of FreeformShapes with formula fails</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63005">63005</a></td><td>POI_Overall</td><td>Remove support for reading files that have XML entity definitions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63013">63013</a></td><td>XWPF</td><td>add XWPFRun setLang method</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63240">63240</a></td><td>XSSF</td><td>Remove unnecessary synchronization on DocumentHelper.newDocumentBuilder and SAXHelper.newXMLReader</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61652">61652</a></td><td>SS_Common</td><td>Fix NPE in EDATE function when date evaluates to an invalid value</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63264">63264</a></td><td>SS_Common</td><td>Conditional Format rule evaluation calculates relative references incorrectly</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60724">60724</a></td><td>SS_Common</td><td>Implement 'ignore hidden rows' variations for existing SUBTOTAL function variants</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63268">63268</a></td><td>SS_Common</td><td>Fix issue with CellUtil.setFont adding unnecessary styles</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61700">61700</a></td><td>SS_Common</td><td>getForceFormulaRecalculation() returns wrong value</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=63292">63292</a></td><td>SS_Common</td><td>DataFormatter.formatCellValue() ignores use1904Windowing w/4-part date formats</td> </tr> </tbody> </table> </div> <a name="4.0.1"></a> <h2 class="boxed">Version 4.0.1 (2018-12-03) </h2> <div class="section"> <a name="Summary-N11A2D"></a> <h3 class="boxed">Summary</h3> <ul> <li>Fixes pom.xml entries for commons-maths3 (missing), curvesapi and commons-codec</li> <li>Improvements for XDDF charts and text manipulation</li> <li>Upgrade to XMLBeans 3.0.2</li> </ul> <a name="Changes-N11A3D"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59773">59773</a></td><td>POI_Overall</td><td>Move loop invariants outside of loop for faster execution</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59834">59834</a></td><td>POI_Overall</td><td>poi-ooxml pom.xml should include dependency on poi-scratchpad</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62690">62690</a></td><td>POI_Overall</td><td>Missing Maven dependency to commons-math3</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62692">62692</a></td><td>OPC</td><td>WildFly XML parser not properly supported - Property 'http://www.oracle.com/xml/jaxp/properties/entityExpansionLimit' is not recognized</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62699">62699</a></td><td>POI_Overall</td><td>Download page must link to https://downloads.apache.org/poi/KEYS</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62733">62733</a></td><td>XSLF</td><td>XSLFBackground setFill() can corrupt the document</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62735">62735</a></td><td>XSSF</td><td>poi-ooxml 4.0.0 should have dependency on curvesapi 1.05</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62740">62740</a></td><td>XSSF</td><td>XSSFTable constructor automatically assigns invalid (non-unique) column IDs</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62768">62768</a></td><td>OPC</td><td>OPCPackage#close() method is incorrectly synchronized</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62796">62796</a></td><td>POI_Overall</td><td>Remove XML Event parser code from PackagePropertiesMarshaller</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62800">62800</a></td><td>XSLF</td><td>Fix null pointer exception if a picture shape has no blip id</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62805">62805</a></td><td>POI_Overall</td><td>Fix Old-Xerces build issues</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62805">62805</a></td><td>XSLF</td><td>XSLFTableCell#removeBorder(BorderEdge.right) removes the bottom edge not the right edge.</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62811">62811</a></td><td>POI_Overall</td><td>POI Encryption didn't work with 4.0.0 but did work with 3.17</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62951">62951</a></td><td>POI_Overall</td><td>FileMagic not correctly identified</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62949">62949</a></td><td>SL_Common</td><td>SlideShow rendering - keyframe fractions must be increasing</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62921">62921</a></td><td>POI_Overall</td><td>Provide OOXMLLite alternative for Java 12+</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62625">62625</a></td><td>POI_Overall</td><td>Handle off-spec, variant REFERENCE_NAME record structure in VBAMacroReader</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62624">62624</a></td><td>POI_Overall</td><td>Handle module name mapping in VBAMacroReader</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62836">62836</a></td><td>SS_Common</td><td>Support TREND function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62859">62859</a></td><td>XWPF</td><td>Rare NPE while creating XWPFSDTContent</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62373">62373</a></td><td>SS_Common</td><td>Support for FREQUENCY function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62831">62831</a></td><td>POI_Overall</td><td>WorkbookFactory.create support for subclass of File, eg from JFileChooser</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62815">62815</a></td><td>XSSF</td><td>XLSB number extraction improvements</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62373">62373</a></td><td>SS_Common</td><td>Support FREQUENCY function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62742">62742</a></td><td>POI_Overall</td><td>Add common-compress jar to bin zip/tgz</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62747">62747</a></td><td>POI_Overall</td><td>Upgrade bouncycastle dependency to 1.60</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62736">62736</a></td><td>XWPF</td><td>Relations on XSLFPictureShape were removed unconditionally</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/109">github-109</a></td><td>XDDF</td><td>Define XDDF user model for text body, its paragraphs and text runs</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/123">github-123</a></td><td>XSSF</td><td>Import chart on drawing</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62746">62746</a></td><td>XDDF</td><td>Support axIds in XDDF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60509">60509</a></td><td>XSSF</td><td>XSSFWorkbook.setSheetName() does not update references in charts</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59625">59625</a></td><td>XWPF</td><td>Localisation (Internationalisation in other languages) when applied in charts corrupt the MS Word file</td> </tr> </tbody> </table> </div> <a name="4.0.0"></a> <h2 class="boxed">Version 4.0.0 (2018-09-07) </h2> <div class="section"> <a name="Summary-N11C6E"></a> <h3 class="boxed">Summary</h3> <ul> <li>Removed support for Java 6 and 7 making Java 8 the minimum version supported</li> <li>New OOXML schema (1.4) necessary, because of incompatible XMLBeans loading not anymore through POIXMLTypeLoader</li> </ul> <a name="Changes-N11C7B"></a> <h3 class="boxed">Changes</h3> <table class="POITable"> <colgroup> <col width="100"> <col width="200"> <col width="150"> <col> </colgroup> <thead> <tr> <th>Type</th><th>Bug</th><th>Module</th><th>Description</th> </tr> </thead> <tbody> <tr class="action"> <td><img class="icon" alt="remove" src="images/remove.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62649">62649</a></td><td>POIFS</td><td><b>Remove OPOIFS* (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61589">61589</a></td><td>XSLF</td><td>Importing content does not copy hyperlink address</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62587">62587</a></td><td>XSLF</td><td>repeated call to XSLFSheet.removeShape leads to java.lang.IllegalArgumentException: partName</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62513">62513</a></td><td>OOXML</td><td>Don't try to parse embedded package relationships</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59268">59268</a></td><td>OOXML</td><td>Work on providing an updated version of XMLBeans</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62451">62451</a></td><td>HPSF</td><td>Document last printed in the year 27321</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60713">60713</a></td><td>SXSSF XSSF OPC</td><td><b>(S)XSSFWorkbook/POIXMLDocument.write(OutputStream) closes the OutputStream (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62452">62452</a></td><td>OPC</td><td>Extract configuration while verifying XML signatures</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62187">62187</a></td><td>OPC</td><td><b>Compiling with Java 10 fails with ClassCastException / use commons-compress (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62355">62355</a></td><td>POI_Overall</td><td><b>Unsplit packages for Jigsaw / Java 9 compatibility (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62041">62041</a></td><td>SL_Common</td><td>TestFonts fails on Mac</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62051">62051</a></td><td>XSLF</td><td>Two shapes have the same shapeId within the same slide</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61633">61633</a></td><td>XSLF</td><td>Zero width shapes aren't rendered</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62037">62037</a></td><td>SL_Common</td><td>SlideNames should not be null but have a default as if accessed by VBA</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62381">62381</a></td><td>SL_Common</td><td>Fix rendering of AutoShapes</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59893">59893</a></td><td>POI_Overall</td><td>Forbid calls to InputStream.available</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61905">61905</a></td><td>HSSF</td><td>HSSFWorkbook.setActiveCell() does not actually make the cell selected in Excel</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61459">61459</a></td><td>HSLF</td><td>HSLFShape.getShapeName() returns name of shapeType and not the shape name</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62319">62319</a></td><td>SL_Common</td><td><b>Decommission XSLF-/PowerPointExtractor (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62092">62092</a></td><td>SL_Common</td><td>Text not extracted from grouped text shapes in HSLF</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62159">62159</a></td><td>OPC</td><td>Support XML signature over windows certificate store</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57369">57369</a></td><td>XDDF</td><td>Add support for major and minor units on chart axes</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55954">55954</a></td><td>XWPF</td><td>Added methods to position table</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61947">61947</a></td><td>POI_Overall</td><td>Remove deprecated classes (POI 4.0.0)</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=55954">55954</a></td><td>XWPF</td><td>Add functions to get, set, remove outer borders for tables</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/72">github-72</a></td><td>XDDF</td><td>Define XDDF user model for shape properties to be shared between XSLF, XSSF and XWPF</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61543">61543</a></td><td>XSSF</td><td><b>Do not fail with "part already exists" when tables are created/removed (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61550">61550</a></td><td>POI_Overall</td><td><b>Add more information to exception text and verify that it is thrown (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61609">61609</a></td><td>POI_Overall</td><td><b>Add .gitattribute file and set lf for one sample-file (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61797">61797</a></td><td>SL_Common</td><td><b>Embed Excel / Ole objects into powerpoint (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61943">61943</a></td><td>SL_Common</td><td>narrow generics definition because of tighter java9 checks</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61942">61942</a></td><td>OPC</td><td>Refactor PackagePartName handling and add getUnusedPartIndex method</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61941">61941</a></td><td>POIFS</td><td>Move Ole marker generation to Ole10Native</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61940">61940</a></td><td>POI_Overall</td><td>Replace ClassID statics with enum</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61939">61939</a></td><td>OPC</td><td>Provide schema for AlternateContent - provide new ooxml-schemas-1.4.jar</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61787">61787</a></td><td>HSSF</td><td>Change how deleted content is detected to not incorrectly see too much text as deleted, this was introduced with bug 58067</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61798">61798</a></td><td>HSSF</td><td>Fix usage of getLastCellNum() when calculating worksheet dimension during saving</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61911">61911</a></td><td>HWPF</td><td>Avoid IndexOutOfBounds access when reading pictures</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61765">61765</a></td><td>HSSF</td><td>Support third party tool generated files using WorkBook as their POIFS directory name</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61881">61881</a></td><td>HSLF</td><td>Regression in ppt parsing: typeface can't be null or empty</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/68">github-68</a></td><td>XDDF XSLF XSSF XWPF</td><td>Share chart data implementation between XSLFChart, XSSFChart and XWPFChart through XDDF</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61809">61809</a></td><td>HPSF</td><td>Infinite loop in SectionIDMap.get() and .put()</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60887">60887</a></td><td>XSSF</td><td>Surface XSSF Header/Footer Attributes</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61730">61730</a></td><td>SS_Common</td><td>CellRangeAddresses support iterating over their CellAddresses</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61727">61727</a></td><td>SS_Common</td><td>CellRangeUtil merge cell ranges broken for certain orders of arguments</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=57517">57517</a></td><td>HSSF</td><td>Fix various situations that were handled incorrectly in HSSFOptimiser</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61671">61671</a></td><td>XSLF</td><td>XSLFSlide does not contain isHidden and setHidden like HSLFSlide does</td> </tr> <tr class="action"> <td><img class="icon" alt="update" src="images/update.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61630">61630</a></td><td>XSSF</td><td>Performance improvement to XSSFExportToXML</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=58068">58068</a></td><td>XSSF</td><td>Add a method to pass the actual Color to StylesTable.findFont()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61096">61096</a></td><td>POIFS</td><td>Add support for modules in VBAMacroReader</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61033">61033</a></td><td>XSSF</td><td>Add XSSFWorkbook.setCellFormulaValidation() to control if formulas are validated during Cell.setCellFormula()</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61148">61148</a></td><td>SXSSF</td><td>Fix calculating/setting formula value</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61064">61064</a></td><td>SS_Common</td><td>Support behavior of function CEILING in newer versions of Microsoft Excel</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61516">61516</a></td><td>SS_Common</td><td>Correctly handle references that end up outside the workbook when cells with formulas are copied</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60737">60737</a></td><td>XSSF</td><td>Add endSheet() to XSSFEventBasedExcelExtractor</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=59747">59747</a></td><td>OPC</td><td>Exchange order of writing parts into Zip to allow some tools to handle files better</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://github.com/apache/poi/pull/69">github-69</a></td><td>SS_Common</td><td>Support matrix functions</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60499">60499</a></td><td>OPC</td><td>Deleting a picture that is used twice on a slide corrupt the slide</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=60279">60279</a></td><td>POI_Overall</td><td>Back-off to brute-force search for macro content if macro offset is incorrect</td> </tr> <tr class="action"> <td><img class="icon" alt="add" src="images/add.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61528">61528</a></td><td>XSSF</td><td>Pivot table enhancements</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61906">61906</a></td><td>XSSF</td><td>add API for working with RichStringText</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=61792">61792</a></td><td>SS_Common</td><td>Avoid iterating over chars (use codepoints instead)</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62254">62254</a></td><td>SS_Common</td><td>Update OFFSET function to support optional values</td> </tr> <tr class="action"> <td><img class="icon" alt="update" src="images/update.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62435">62435</a></td><td>XSSF</td><td>Rename getAllEmbedds method to getAllEmbeddedParts (getAllEmbedds is retained but deprecated)</td> </tr> <tr class="action"> <td><img class="icon" alt="update" src="images/update.png"></td><td><a href="https://bz.apache.org/bugzilla/show_bug.cgi?id=62438">62438</a></td><td>POI_Overall</td><td><b>Replace org.apache.poi.openxml4j.util.Nullable with java.lang.Optional (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/90">github-90</a></td><td>XSSF</td><td>Change default DSIG signing algorithm to SHA256</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/107">github-107</a></td><td>SS_Common</td><td>Support AREAS function</td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/110">github-110</a></td><td>XWPF</td><td><b>Renames org.apache.poi.xwpf.usermodel.TextSegement to org.apache.poi.xwpf.usermodel.TextSegment (breaks backwards compatibility)</b></td> </tr> <tr class="action"> <td><img class="icon" alt="fix" src="images/fix.png"></td><td><a href="https://github.com/apache/poi/pull/114">github-114</a></td><td>XWPF</td><td>Better support for Footnotes and Endnotes</td> </tr> </tbody> </table> </div> </div>  <div class="clearboth"> </div> </div> <div id="footer">  <div class="lastmodified"> <script type="text/javascript"></script> </div> <div class="copyright"> Copyright © 2001-2025 <a href="https://www.apache.org/">The Apache Software Foundation</a> <br> Apache, Apache POI, the Apache feather logo, and the Apache POI logos are trademarks of The Apache Software Foundation. </div> <div id="feedback"> Send feedback about the website to: <a id="feedbackto" href="mailto:dev@poi.apache.org?subject=Feedback%C2%A0changes.html">dev@poi.apache.org</a> </div>  </div> </body> </html>