<!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">
<!--*** This is a generated file. Do not edit. ***-->
<link rel="stylesheet" href="skin/tigris.css" type="text/css">
<link rel="stylesheet" href="skin/mysite.css" type="text/css">
<link rel="stylesheet" href="skin/site.css" type="text/css">
<link media="print" rel="stylesheet" href="skin/print.css" type="text/css">
<title>History of Changes</title>
</head>
<body bgcolor="white" class="composite">
<!--================= start Banner ==================-->
<div id="banner">
<table width="100%" cellpadding="8" cellspacing="0" summary="banner" border="0">
<tbody>
<tr>
<!--================= start Group Logo ==================-->
<td width="50%" align="left">
<div class="groupLogo">
<a href="http://poi.apache.org"><img border="0" class="logoImage" alt="Apache POI" src="resources/images/group-logo.jpg"></a>
</div>
</td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="50%" align="right">
<div align="right" class="projectLogo">
<a href="http://poi.apache.org/"><img border="0" class="logoImage" alt="POI" src="resources/images/project-logo.jpg"></a>
</div>
</td>
<!--================= end Project Logo ==================-->
</tr>
</tbody>
</table>
</div>
<!--================= end Banner ==================-->
<!--================= start Main ==================-->
<table width="100%" cellpadding="0" cellspacing="0" border="0" summary="nav" id="breadcrumbs">
<tbody>
<!--================= start Status ==================-->
<tr class="status">
<td>
<!--================= start BreadCrumb ==================--><a href="http://www.apache.org/">Apache</a> | <a href="http://poi.apache.org/">POI</a><a href=""></a>
<!--================= end BreadCrumb ==================--></td><td id="tabs">
<!--================= start Tabs ==================-->
<div class="tab">
<span class="selectedTab"><a class="base-selected" href="index.html">Home</a></span> | <script language="Javascript" type="text/javascript">
function printit() {
if (window.print) {
window.print() ;
} else {
var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH="0" HEIGHT="0" CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box WebBrowser1.outerHTML = "";
}
}
</script><script language="Javascript" type="text/javascript">
var NS = (navigator.appName == "Netscape");
var VERSION = parseInt(navigator.appVersion);
if (VERSION > 3) {
document.write(' <a title="PRINT this page OUT" href="javascript:printit()">PRINT</a>');
}
</script>
</div>
<!--================= end Tabs ==================-->
</td>
</tr>
</tbody>
</table>
<!--================= end Status ==================-->
<table id="main" width="100%" cellpadding="8" cellspacing="0" summary="" border="0">
<tbody>
<tr valign="top">
<!--================= start Menu ==================-->
<td id="leftcol">
<div id="navcolumn">
<div class="menuBar">
<div class="menu">
<span class="menuLabel">Overview</span>
<div class="menuItem">
<a href="index.html">Home</a>
</div>
<div class="menuItem">
<a href="download.html">Download</a>
</div>
<div class="menuItem">
<a href="overview.html">Components</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="casestudies.html">Case Studies</a>
</div>
<div class="menuItem">
<a href="legal.html">Legal</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Help</span>
<div class="menuItem">
<a href="apidocs/index.html">Javadocs</a>
</div>
<div class="menuItem">
<a href="faq.html">FAQ</a>
</div>
<div class="menuItem">
<a href="mailinglists.html">Mailing Lists</a>
</div>
<div class="menuItem">
<a href="http://issues.apache.org/bugzilla/buglist.cgi?product=POI">Bug Database</a>
</div>
<div class="menuItem">
<span class="menuSelected">Changes Log</span>
</div>
</div>
<div class="menu">
<span class="menuLabel">Getting Involved</span>
<div class="menuItem">
<a href="subversion.html">Subversion Repository</a>
</div>
<div class="menuItem">
<a href="howtobuild.html">How To Build</a>
</div>
<div class="menuItem">
<a href="guidelines.html">Contribution Guidelines</a>
</div>
<div class="menuItem">
<a href="who.html">Who We Are</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Component APIs</span>
<div class="menuItem">
<a href="spreadsheet/index.html">Excel (SS=HSSF+XSSF)</a>
</div>
<div class="menuItem">
<a href="hwpf/index.html">Word (HWPF+XWPF)</a>
</div>
<div class="menuItem">
<a href="slideshow/index.html">PowerPoint (HSLF+XSLF)</a>
</div>
<div class="menuItem">
<a href="oxml4j/index.html">OpenXML4J (OOXML)</a>
</div>
<div class="menuItem">
<a href="poifs/index.html">OLE2 Filesystem (POIFS)</a>
</div>
<div class="menuItem">
<a href="hpsf/index.html">OLE2 Document Props (HPSF)</a>
</div>
<div class="menuItem">
<a href="hsmf/index.html">Outlook (HSMF)</a>
</div>
<div class="menuItem">
<a href="hdgf/index.html">Visio (HDGF)</a>
</div>
<div class="menuItem">
<a href="hmef/index.html">TNEF (HMEF)</a>
</div>
<div class="menuItem">
<a href="hpbf/index.html">Publisher (HPBF)</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Apache Wide</span>
<div class="menuItem">
<a href="http://www.apache.org/">Apache Software Foundation</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/licenses/">License</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/foundation/sponsorship.html">Sponsorship</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/foundation/thanks.html">Thanks</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/security/">Security</a>
</div>
</div>
</div>
</div>
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap">
Search Apache POI<br>
<input value="poi.apache.org" name="sitesearch" type="hidden"><input size="10" name="q" id="query" type="text"><img height="1" width="5" alt="" src="skin/images/spacer.gif" class="spacer"><input name="Search" value="GO" type="submit"></td><td><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="3"><img height="7" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td class="bottom-left-thick"></td><td bgcolor="#a5b6c6"><img height="1" width="1" alt="" src="skin/images/spacer.gif" class="spacer"></td><td class="bottom-right-thick"></td>
</tr>
</table>
</form>
</td>
<!--================= end Menu ==================-->
<!--================= start Content ==================--><td>
<div id="bodycol">
<div class="app">
<div align="center">
<h1>History of Changes</h1>
</div>
<div class="h3">
<p>
<a href="changes.rss"><img alt="RSS" src="images/rss.png"></a>
</p>
<a name="3.10.1"></a>
<div class="h3">
<h3>Version 3.10.1 (2014-08-18)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54764 - On supported XML parser versions (Xerces or JVM built-in, XMLBeans 2.6), enforce sensible limits on entity expansion in OOXML files, and ensure that subsequent normal files still pass fine (CVE-2014-3574)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">56164 - Tidy up the OPC SAX setup code with a new common Helper, preventing external entity expansion (CVE-2014-3529)(poi-developers)</li>
</ul>
<a name="3.10-FINAL"></a>
<div class="h3">
<h3>Version 3.10-FINAL (2014-02-08)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51585 - WorkbookFactory.create() hangs when creating a workbook(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55873 - Support for COUNTIFS function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55723 - Inconsistent behavior in HSSFSheet.setAutoFilter() function, also make XSSF work when setAutoFilter is called multiple times(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51158 - Writing a workbook multiple times produces unreadable content(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45776 - Fix corrupt file problem using TextRun.setText(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">41246 - AIOOBE with missing notes entries(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48593 - Multiple Saves Causes Slide Corruption(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55579 - Support embedding OLE objects into HSLF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55818 - Add encryption support(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55731 - Fix StringBuilder logic in DataFormatter.cleanFormatForNumber (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55730 - Fix org.apache.poi.ss.usermodel.BuiltinFormats.java for 0x29-0x2c (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55901 - Avoid using RMI based exception from PropertySetFactory, as it's not needed nor helpful(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55850 - Fix NullPointerException during Xml-extraction from xslx(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55640 - Avoid IndexOutOfboundsException when setting nested row grouping(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55745 - fix handling of tables in XSSF if there are comments as well(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55560 - Patch for hiding slides in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53176 - Fixed auto shapes render problem in pptx files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55661 - CellStyle support for get/set Shrink To Fit(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49237 - HSSF Row Style XfIndex is 12 not 16 bits of data(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53475 - OOXML encrypted document fix for cspname being optional(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55733 - XWPFWordExtractor needs to handle .docx files with neither headers nor footers(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55729 - DataFormatter should format Error cells, returning the Excel error string(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55612 - Performance improvement in HSSFCellStyle.getDataFormatString()(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55611 - Performance improvement in DateUtil.isADateFormat(int, String)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55578 - Support embedding OLE1.0 packages in HSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49658 - Support embedding EMF/WMF pictures in HSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52400 - Fix handling some types of TNEF files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54400 - Updating the index in the LinkTable whenever sheets are removed(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49940 - Apply patch to avoid XmlValueDisconnectedException when saving a file twice(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55369 - Add support for collapsing rows in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55692 - Give a more helpful error if an Encrypted .xlsx file is passed to HSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55650 - Avoid AIOOBE if a non-existant Xfs is requested for a style(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55658 - Don't fail in SXSSF if a numeric cell is overwritten with a string(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55341 - Constants for HAIR and DOTTED border styles are swapped(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add Eclipse project files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55647 - When creating a temp file, ensure the name isn't already taken(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">54722 - Extract text from HSLF tables(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55544 - Support for SHA-512 hashes on OOXML protected documents, as used by Office 2013(poi-developers)</li>
</ul>
<a name="3.10-beta2"></a>
<div class="h3">
<h3>Version 3.10-beta2 (2013-09-19)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53798 - Add fix for XmlValueDisconnectException during shifting rows(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54524 - Fix handling of special case in FormulaShifter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50298 - Fix corruption of Workbook when setting sheet order(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55419 - Fix SimpleFractionException when fraction goes to greater than overflow(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">54786 - Add support for quoting in date formatting(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52233 - Do not make the XSSFSheet invalid during write()(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55195 - MultiOperandNumericFunction.collectValue() currently uses concrete final classes but should use interfaces instead(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55380 - Endless loop in CellRangeUtil.mergeRanges() when regions are overlapping(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55347/45551 - Integrate 55292 into XSSF extractors -- extract text from text boxes in xlsx files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55361/Tika 792 - Avoid CTMarkup NoSuchMethodException stack trace by adding two beans to ooxml-lite"(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55294 and 52186 - Fix column grouping in XSSF.(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55292 - Enhancements to XSSFSimpleShape (textbox) including: ability to add multiple paragraphs, formatting (read/write) and text extraction.(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55191 - Avoid a ClassCastException if a HPSF string property isn't directly stored as a string(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">HSMF ascii encoding detection should use the CodePage properties where available(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">HSMF fixed length property parsing should be more forgiving of some type differences from the property default(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54233 - Some HPSF documents require UnicodeStrings to be 4-byte aligned, spot these from the otherwise invalid length(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Upgrade version of JUnit to 4.11 to avoid problems when executing unit tests using Apache Ant >= 1.7(poi-developers)</li>
</ul>
<a name="3.10-beta1"></a>
<div class="h3">
<h3>Version 3.10-beta1 (2013-06-28)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54925 - Avoid issues if the length of a StyleTextPropAtom prop is longer than the parent text(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54564 - Fix error message text for a workbook with no sheets when a sheet operation is performed(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53972 - Presence of PLV record shouldn't affect HSSF Data Validation(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55142 - Not all XWPF SDT blocks need newlines(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54920 - XSSFDrawing.createCellComment causes CommentsTable to lose reference to comment in cell A1(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54982 - ExtractorFactory does not close files when extracting via OCPPackage.open()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54607 - NullPointerException in XSSFSheet.getTopRow() when the top row is 1(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54686 - Improve how DataFormatter handles fractions(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55066 - Don't load XWPF Footnotes twice(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">54849 - Controlled content/Form (Std/StdBlock) content(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">github2 - HSSFWorkbook.getAllEmbeddedObjects() needs to recurse into container Shapes(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">github4 - Expose from XWPFParagraph the number level and format, if applied(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">github3 - Extract references from XWPF footnotes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55053 - Update License links following ECMA site re-organisation(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49658 - Support embedding EMF/WMF pictures in HSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55047 - REPT formula support (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55042 - COMPLEX formula support (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">55041 - CODE formula support (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">55001 - Support Unicode text (TextCharsAtom) in HSLF TextShape(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54682 - UnhandledDataStructure should sanity check before allocating, not after(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">54673 - Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54625 - Register user-defined functions in instance scope instead of static (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54469 - Support for financial functions IPMT and PPMT (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54407 - Avoid XmlValueDisconnectedException when merging slides (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54356 - Support of statistical function SLOPE(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54403 - Support of statistical function INTERCEPT(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54557 - Don't mis-detect format patterns like .000 as dates(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54506 - Support unusual .xls files with a BOOK directory entry (normally it is Workbook)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">54508 - EDATE formula support(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53810 - NPOIFS fix for 0 not -1 padded partially used XBATs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54402 - IfError handling of indirect references(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53966 - IfError support (from Analysis Toolpak)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53650 - Prevent unreadable content and disalow to overwrite rows from input template in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54228,53672 - Fixed XSSF to read cells with missing R attribute(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54206 - Ensure that shared formuals are updated when shifting rows in a spreadsheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Synchronize table headers with parent sheet in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54210 - Fixed rendering text in flipped shapes in PPT2PNG and PPTX2PNG(poi-developers)</li>
</ul>
<a name="3.9"></a>
<div class="h3">
<h3>Version 3.9 (2012-12-03)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54188 - Avoid NPE in PPT2PNG(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52628 - Replace System.err info messages with a POILogger(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54137 - improved performance of DataFormatter with Fractions(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54099 - Ensure that CTHMerge and CTTcBorders go to poi-ooxml-schemas jar(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54111 - Fixed extracting text from table cells in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52583 - add support for drop-down lists in doc to html convertion(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52863 - add workaround for files with broken CHP SPRMs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53182 - Reading combined character styling and direct formatting of a character run(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52311 - Conversion to html : Problem in titles number (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53914 - TableRow#getTopBorder() return bottom's border(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53282 - Avoid exception when parsing OPC relationships with non-breaking spaces(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54016 - Avoid exception when parsing workbooks with DConRefRecord in row aggregate(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">54008 - Fixed Ant build to support build directories with blanks(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53374 - Avoid exceptions when parsing hyperlinks of type "javascript://"(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53404 - Fixed compatibility bug with modifying xls files created by POI-3.6 and earlier(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53979 - Support fetching properties of Numbered Lists from PPT files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53784 - Partial HSMF support for fixed sized properties(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53943 - added method processSymbol() to allow converting word symbols (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53763 - avoid style mess when using HSSFOptimiser (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52972 - preserve leading / trailing spaces in SXSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53965 - Fixed XmlValueOutOfRangeExceptio calling getDataValidations for custom validations with XSSFSheet (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53974 - Avoid NPE when constructing HSSFWorbook on Google App Engine(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53568 - Fixed null returned by XSSFPicture.getPictureData()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53950 - fixed setForceFormulaRecalculation to reset workbook-level "manual" flag(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52211 - avoid unnessary re-coverting content types to US-ASCII, it can cause exceptions on ibm mainframes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53568 - Set shapes anchors in XSSF when reading from existing drawings(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSSFOptimiser will now also tidy away un-used cell styles, in addition to duplicate styles(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53493 - Fixed memory and temporary file leak in SXSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53780 - Fixed memory and temporary file leak in SXSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53380 - ArrayIndexOutOfBounds Excetion parsing word 97 document. (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53434 - Subtotal is not return correct value. (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53642 - [PATCH] XLS formula evaluation logging (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53561 - Unexpected adding of drawings into a workbook (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53413 - [GSoC] Improved work with shapes. HSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53361 - feature: enhancements in EscherAggregate (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53302 - [Patch] EscherAggregate does not handle Continue records (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53144 - First comment not cloned after cloneSheet() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53028 - Broken auto fit row height in the cells with word wrap (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53010 - [GSoC2012] Improve drawing support in HSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52764 - Unmodified cell comments disappear after HSSFWorkbook.write (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52300 - Corrupted File after cloneSheet() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52272 - [PATCH] Inserting images on cloned sheet with images. (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51796 - The [EscherClientAnchorRecord] for object (eg: TextBox,Shape) may get lost. (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51683 - [HSSF] Improve support for Shapes and Shape Groups (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51676 - Using drawingPatriarch.createCellComment(anchor) leads to File error: data may have been lost (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51675 - Background images cause problems in HSSF spreadsheet (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51455 - It would be really nice to be able to set the background picture of a comment (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51341 - Adding Image to Header in Excel Using HSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51280 - when we insert a new image to the existing excel file that corrupts the previous images (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50696 - File Error: data may have been lost (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48989 - If we have a comment but the row is not created we will not be able to get it. (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48873 - Comments not saving in XLS files with collapsible columns (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48654 - Not able to read Excel (xls) file having drawing objects (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48590 - Excel chrashes after using removeCellComment methods (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46444 - cloning cloned sheet with autofilters corrupts the workbook (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45129 - Lost picture in file output after saving with POI (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47624 - File Error Data May Have been Lost error while opening commented workbook(excel file) (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46143 - setLineStyleColor for comments donot work (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53699 - Patch to correct BorderStyle enum positions (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53064 - Ugly Duckling case study(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53644 - XLS formula bugfix (CalFieldFunc) + WeekDay addon (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53446 - Fixed some problems extracting PNGs (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53205 - Fixed some parsing errors and encoding issues in HDGF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53204 - Improved performanceof PageSettingsBlock in HSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53500 - Getter for repeating rows and columns(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53369 - Fixed tests failing on JDK 1.7(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53360 - Fixed SXSSF to correctly write text before escaped Unicode control character(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Change HSMF Types to have full data on ID, Name and Length, rather than just being a simple ID(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48469 - Updated case study(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53476 - Support Complex Name in formulas (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53414 - properly update sheet dimensions when adding column (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add File based constructor to OPCPackage, alongside existing String one (which constructed a File from the string internally)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53389 - Handle formatting General and @ formats even if a locale is prefixed to them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53271 - Removed unconditional asserts in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53025 - Updatad documentation and example on using Data Validations (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53227 - Corrected AddDimensionedImage.java to support XSSF/SXSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53058 - Utility for representing drawings contained in a binary Excel file as a XML tree(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">53165 - HWPF support for fetching the description (alt text) of a picture(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48528 - support negative arguments to the DATE() function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53092 - allow specifying of a TimeZone to DateUtil.getJavaDate(), for when it is known that a file comes from a different (known) timezone to the current machine(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53043 - don't duplicate hyperlink relationships when saving XSSF file(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">53101 - fixed evaluation of SUM over cell range > 255(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49529 - avoid exception when cloning sheets with no drawing records and initialized drawing patriarch(poi-developers)</li>
</ul>
<a name="3.8-FINAL"></a>
<div class="h3">
<h3>Version 3.8-FINAL (2012-03-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">52928 - DateFormatConverter: an utility to convert instances of java.text.DateFormat to Excel format patterns(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52895 - show SSTIndex instead of XFIndex in LabelSSTRecord.toString()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52835 - Tolerate missing Count and UniqueCount attributes when parsing shared strings table in XSSF eventusermodel(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52818 - Added implementation for RANK()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52682 - allow setting text with trailing carriage return in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52244 - use correct text attributes when presentation has multiple TxMasterStyleAtoms of the same type(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">support setting background color of sheet tab in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51564 - support for enforcing fields update in XWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51673 - support grouping rows in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51780 - support replacement of content types in OPC packages (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52784 - replace ISO control characters with question marks in SXSSF to be consistent with XSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52057 - updated formula test framework to be aware of recently added Functions (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52574 - support setting header / footer page margins in HSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52583 - fixed WorkbookUtil#createSafeSheetName to escape colon (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51710 - fixed reading shared formulas in XSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52708 - misc improvements in CellFormat (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52690 - added a getter for length of encrypted data in Ecma and Agile decryptors(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52255 - support adding TIFF,EPS and WPG pictures in OOXML documents (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52078 - avoid OutOfMemoryError when rendering groupped pictures in HSLF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52745 - fixed XSSFRichtextString.append to preserve leading / trailing spaces (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52716 - tolerate hyperlinks that have neither location nor relation (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52599 - avoid duplicate text when rendering slides in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52598 - respect slide background when rendering slides in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51731 - fixed painting shape outlines in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52701 - fixed seting vertical alignment for XSLFTableCell(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52687 - fixed merging slides with pictures with associated custom tags(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg"> allow runtime registration of functions in FormulaEvaluator(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52665 - When reading from a ZipFileZipEntrySource that has already been closed, give IllegalArgumentException rather than NPE(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52664 - MAPIMessage may not always have name chunks when checking for 7 bit encodings(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52649 - fixed namespace issue in WordToFoConverter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52385 - avoid trancated array and vector data when reading OLE properties(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52662 - CharacterRun NPE fix when fetching symbol fonts, where no fonts are defined(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52658 - support mergin table cells in XSLF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">validate row number and column index in SXSSF when creating new rows / cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51498 - fixed evaluation of blank cells in COUNTIF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52576 - support changing external file references in HSSFWorkbook(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49896 - support external references in FormulaRenderer(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52527 - avoid exception when matching shared formula records in HSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52568 - Added methods to set/get an XWPFRun's text color(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52566 - Added methods to set/get vertical alignment and color in XWPFTableCell(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52562 - Added methods to get/set a table row's Can't Split and Repeat Header attributes in XWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52561 - Added methods to set table inside borders and cell margins in XWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52569 - Support DConRefRecord in HSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52575 - added an option to ignore missing workbook references in formula evaluator(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Validate address of hyperlinks in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52540 - Relax the M4.1 constraint on reading OOXML files, as some Office produced ones do have 2 Core Properties, despite the specification explicitly forbidding this(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52462 - Added implementation for SUMIFS()(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">POIXMLPropertiesTextExtractor support for extracting custom OOXML properties as text(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52449 - Support writing XWPF documents with glossaries (Glossaries are not yet supported, but can now be written out again without changes)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52446 - Handle files which have been truncated by a few bytes in NPropertyTable(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52438 - Update CellDateFormatter to handle times without seconds(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52389 - Support ?/? as well as #/# fractions, and tighten DataFormatter rules for fraction matching(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52200 - Updated XWPF table example code (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52378 - Support for WORKDAY and NETWORKDAYS functions(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52349 - Merge the logic between the TEXT function and DataFormatter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52349 - Correctly support excel style date format strings in the TEXT function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52369 - XSSFExcelExtractor should format numeric cells based on the format strings applied to them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52369 - Event based XSSF parsing should handle formatting of formula values in XSSFSheetXMLHandler(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52348 - Avoid exception when creating cell style in a workbook that has an empty xf table(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52219 - fixed XSSFSimpleShape to set rich text attributes from XSSFRichtextString(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52314 - enhanced SheetUtil.getColumnWidth(poi-developers)</li>
</ul>
<a name="3.8-beta5"></a>
<div class="h3">
<h3>Version 3.8-beta5 (2011-12-17)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52204 - Deprecated XSSFWorkbook(String path) constructor because it does not close underlying .zip file(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46288 - fixed refcount of Fill pictures in HSLF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51961 - support compression of temp files in SXSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52268 - support cloning sheets with drawings in XSSF (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52285 - Support XWPF smart tags text in Paragraphs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51875 - More XSSF new-line in formula support(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">POIFS EntryUtils.copyNodes(POFS,POIFS) now uses FilteringDirectoryNode, so can exclude from copying nodes not just directly under the root(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">POIFS Helper FilteringDirectoryNode, which wraps a DirectoryEntry and allows certain parts to be ignored(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52209 - fixed inserting multiple pictures in XSLF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51803 - fixed HSLF TextExtractor to extract content from master slide (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52190 - null check on XWPF setFontFamily(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52062 - ensure that temporary files in SXSSF are deleted(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50936 - Exception parsing MS Word 8.0 file (as duplicate of 47958)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47958 - ArrayIndexOutOfBoundsException from PicturesTable.getAllPictures() during Escher tree walk(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51944 - PAPFormattedDiskPage.getPAPX - IndexOutOfBounds(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52032 - HWPF - ArrayIndexOutofBoundsException with no stack trace (broken after revision 1178063)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">support for converting pptx files into images with a PPTX2PNG tool(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">52050 - Support for the Excel RATE function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51566 - HSLF fix for finishing parsing the picture stream on the first non-valid type(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51974 - Avoid HWPF issue when identifying the picture type(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">52035 - Fix signed issue with very large word 6 files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51949 - Avoid NPE on double close of ZipFileZipEntrySource(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51950 - XWPF fix for footnotes not always being present in a document(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51963 - Correct AreaReference handling of references containing a sheet name which includes a comma(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51955 - XSSFReader supplied StylesTables need to have the theme data available(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51716 - Removed incorrect assert in SXSSFSheet#getSXSSFSheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51834 - Opening and Writing .doc file results in corrupt document(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51902 - Picture.fillRawImageContent - ArrayIndexOutOfBoundsException (duplicate)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51890 - ArrayIndexOutOfBounds ExceptionPicture.fillRawImageContent(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Allow the passing of a File object to WorkbookFactory.create, which permits lower memory processing than the InputStream version(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51873 - update HSMF to ignore Outlook 2002 Olk10SideProp entries, which don't behave like normal chunks(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51850 - support creating comments in XSSF on an earlier slide when later ones already have them(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51804 - optionally include Master Slide text in XSLF text extraction, as HSLF already offers(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">New PackagePart method getRelatedPart(PackageRelationship) to simplify navigation of relations between OPC Parts(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51832 - handle XLS files where the WRITEPROTECT record preceeds the FILEPASS one, rather than following as normal(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51809 - correct GTE handling in COUNTIF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add HWPF API to update range text and delete bookmarks(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HWPF Bookmarks tables are correctly updated on text updates(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51670 - avoid LeftoverDataException when reading .xls files with invalid LabelRecords(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51196 - prevent NPE in XWPFPicture.getPictureData() (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51771 - prevent NPE when getting object data from OLEShape in HSLF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51196 - more progress with Chart APi in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51785 - Allow XSSF setForceFormulaRecalculation to work with the minimal ooxml-schemas jar(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51772 - IllegalArgumentException Parsing MS Word 97 - 2003(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">XSLFPowerPointExtractor support for including comment authors with comment text(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Converted XSLFPowerPointExtractor to use UserModel for all text extraction(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">XSLF initial UserModel support for Notes and Comments for Slides(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: support for uncompressed OLE embeddings(poi-developers)</li>
</ul>
<a name="3.8-beta4"></a>
<div class="h3">
<h3>Version 3.8-beta4 (2011-08-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51678 - Extracting text from Bug51524.zip is slow(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51671 - HWPFDocument.write based on NPOIFSFileSystem throws a NullPointerException(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">support for tables and hyperlinks in XSLF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51535 - correct signed vs unsigned short reading in NDocumentInputStream(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51634 - support SXSSF streaming from templates(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">initial support for XSLF usermodel API(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51187 - fixed OPCPackage to correctly handle self references(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51635 - Improved performance of XSSFSheet#write(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47731 - Word Extractor considers text copied from some website as an embedded object(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add Word-to-Text converter and use it as replacement for WordExtractor(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51604 - replace text fails for doc ( poi 3.8 beta release from download site )(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed incorrect encoding of non-breaking space (0xA0) in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for conditional formatting in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support isRightToLeft and setRightToLeft on the common spreadsheet Sheet interface, as per existing HSSF support(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50209 - Fixed evaluation of Subtotals to ignore nested subtotals(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44431 - HWPFDocument.write destroys fields(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50401 - fixed EscherProperty to return property name instead of 'unknown' for complex properties (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for endnotes and footnotes in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51470 - avoid exception when cloning XSSF sheets with background images(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51481 - Fixed autofilters in HSSF to avoid warnings in Excel 2007(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51533 - Avoid exception when changing name of a sheet containing shared formulas(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for appending images to existing drawings in HSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for bookmarks in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46250 - Fixed cloning worksheets with images(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51524 - PapBinTable constructor is slow (regression)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51514 - allow HSSFObjectData to work with both POIFS and NPOIFS(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51514 - avoid NPE when copying nodes from one HSSF workbook to a new one, when opened from NPOIFS(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51504 - avoid NPE when DefaultRowHeight or DefaultColumnWidth records are missing(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51502 - Correct Subtotal function javadoc entry(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for hyperlinks in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49933 - Word 6/95 documents with sections cause ArrayIndexOutOfBoundsException(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51469 - XSSF support for row styles, to match existing HSSF functionality(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51476 - Correct XSSF cell formatting in HTML export(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51486 - XWPF support for adding new footnotes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48065 - Problems with save output of HWPF (losing formatting)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47563 - Exception when working with table(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47287 - StringIndexOutOfBoundsException in CharacterRun.replaceText()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46817 - Regression: Text from some table cells missing(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add getOverallRange() method to HWPFDocumentCore(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">PAPX referenced outside of TextPiecesTable are ignored now and not loaded(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix main part range (and section) detection for files with additional parts (like footers/headers).(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix wrong TextPiece parsing in very rare cases like Bug33519.doc(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Inner tables are correctly supported(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Allow user to retrieve Table nesting level (based on file information)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Functionality of internal tool HWPFLister is greatly improved, including output of document PAPX and paragraphs(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Expand Word structures definitions (TAP, PAP, TLP, etc) based on official documentation(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add Excel-to-HTML converter (2007 versions)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add Word-to-HTML converter (95-2007 versions)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Skip wrong-type SPRMs when characters SPRM is expected(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add toStrings() methods to internal HWPF structures: BorderCode, PAPX, Paragraph, PieceDescriptor, Section, SEPX, SprmOperation, TextPiece etc.(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51474 - SXSSF handling for null strings(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48294 - Fixed HSSFWorkbook.setSheetOrder() to respect inter-sheet references (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51448 - Avoid exception when evaluating workbooks with more than 256 sheets (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51458 - Correct BitField wrapping when setting large values(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51460 - Improve HSSF performance when loading very long rows, by switching the CellValue array to an iterator(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51444 - Prevent corrupted output when saving files created by LibreOffice 3.3 (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51422 - Support using RecalcIdRecord to trigger a full formula recalculation on load (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50474 - Example demonstrating how to update Excel workbook embedded in a WordprocessingML document (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51431 - Avoid IndexOutOfBoundException when removing freeze panes in XSSF (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48877 - Fixed XSSFRichTextString to respect leading and trailing line breaks (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49564 - Fixed default behaviour of XSSFCellStyle.getLocked() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48314 - Fixed setting column and row breaks in XSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51424 - Ignore exceptions in ParagraphSprmUncompressor(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51415 - Fixed Workbook.createSheet(sheetName) to truncate names longer than 31 characters(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51332 - Fixed internal IDs of shapes generated by HSSFPatriarch when there are more than 1023 drawing objects (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48408 - Improved documentation for Sheet.setColumnWidth (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51390 - Added handling of additional properties to HWPF ParagraphSprmCompressor(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51389 - Support for sprmPJc paragraph SPRM in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48469 - New Case Study for POI web site (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50681 - Avoid exceptions in HSSFDataFormat.getDataFormatString() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50681 - Fixed autosizing columns beyond 255 character limit (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51374 - Fixed incorrect setting of lastPrinted OOXML core property (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51351 - Word to XSL-FO converter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50458 - Fixed missing shapeId in XSSF drawings (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51339 - Fixed arithmetic rounding in formula evaluation (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51356 - Support autoSizeColumn in SXSSF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51335 - Parse picture goal and crop sizes in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51305 - Add sprmTCellPaddingDefault support in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51265 - Enhanced Handling of Picture Parts in XWPF(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51292 - Additional HWPF Table Cell Descriptor values(poi-developers)</li>
</ul>
<a name="3.8-beta3"></a>
<div class="h3">
<h3>Version 3.8-beta3 (2011-06-06)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51098 - Correctly calculate image width/height, if image fits into one cell(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47147 - Correct extra paragraphs from XWPF Table Cells(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51188 - Support for getting and setting XPWF zoom settings(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51134 - Support for adding Numbering and Styles to a XWPF document that doesn't already have them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51273 - Formula Value Cache fix for repeated evaluations(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51171 - Improved performance of SharedValueManager (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51236 - XSSF set colour support for black/white to match getter(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51196 - Initial support for Spreadsheet Chart API(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add support for OOXML Agile Encryption(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51160 - Initial version of SXSSF, a low memory foortprint API to produce xlsx files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51171 - Improved performance of opening large .xls files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">51172 - Add XWPF support for GIF pictures(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">NPOIFS Mini Streams now support extending the underlying big block stream to fit more data(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51148 - XWPFDocument now properly tracks paragraphs and tables when adding/removing them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51153 - Correct sizing of LbsDataSubRecord with unused padding fields(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51143 - NameCommentRecord correction for writing non ASCII strings(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51112 - Correct XWPFTable tracking of new rows(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51113 - Correct XWPFParagraph tracking of inserted runs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51111 - Correct XWPFParagraph tracking of new runs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51115 - Handle DataFormatter escaping of "." in the same way as "-" and "/"(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51100 - Fix IOUtils issue for NPOIFS reading from an InputStream where every block is full(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50956 - Correct XSSF cell style cloning between workbooks(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add get/setForceFormulaRecalculation for XSSF, and promote the methods to the common usermodel Sheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Tweak the logic for sizing the HSSFCells array on a HSSFRow to reduce memory over allocation in many use cases(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49765 - Support for adding a picture to a XSSFRun(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Rename/Move xssf.model.Table to xssf.usermodel.XSSFTable as it now has usermodel-like features(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">51061 - Correct target URI for new XSSF Tables(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for XSSF Charts. Provides easy access to the underlying CTChart object via the Sheet Drawing, but no high level interface onto the chart contents as yet.(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50884 - XSSF and HSSF freeze panes now behave the same(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for adding a table to a XSSFSheet(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Improve HSMF MAPIMessage access to the HTML and RTF versions of the message body (where available)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add new method to HSMF of MAPIMessage.has7BitEncodingStrings() to make it easier to decide when encoding guessing is needed(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">OutlookTextExtractor now requests 7 bit encoding guessing(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Improve HSMF encoding guessing for 7 bit fields in MAPIMessage(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Allow HSMF access to the HTML body contents in MAPIMessage(poi-developers)</li>
</ul>
<a name="3.8-beta2"></a>
<div class="h3">
<h3>Version 3.8-beta2 (2011-04-08)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Implement the load method on MemoryPackagePart(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50967 - Support for continued ExtSSTRecords(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48968 - Support for HOUR, MINUTE and SECOND date formulas(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added NPOIFS constructors to most POIDocument classes and their extractors, and more widely deprecated the Document(DirectoryNode, POIFSFileSystem) constructor in favour of the more general Document(DirectoryNode) one(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed NPOIFS handling of new and empty Document Nodes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed NPOIFS access to Document Nodes not in the top level directory(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50841 - Improved SpreadSheet DataFormatter to handle scientific notation, invalid dates and format spacers(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49381 - Correct createFreezePane in XSSF, so that the left row/column matches the documentation + HSSF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49253 - When setting repeating rows and columns for XSSF, don't break the print settings if they were already there(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49219 - ExternalNameRecord support for DDE Link entries without an operation(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50846 - More XSSFColor theme improvements, this time for Cell Borders(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50939 - ChartEndObjectRecord is supposed to have 6 bytes at the end, but handle it not(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HMEF - New component which supports TNEF (Transport Neutral Encoding Format), aka winmail.dat(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50313 - support for getting HWPFDocument fields(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50912 - fixed setting named styles to HSSFCells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50779 - fixed RecordFormatException when reading unicode strings with photenic data(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50718 - More helpful error message when you try to create a CellReference with #REF!(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50784 - XSSFColors return by XSSFFont now have theme information applied to them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50846 - Improve how XSSFColor inherits from Themes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50847 - XSSFFont now accepts the full range of Charsets from FontChartset(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50786 - Speed up calls to HSSFColor.getIndexHash() by returning a cached, unmodifiable Map. HSSFColor.getModifiableIndexHash() provides access to the old (slow but modifiable) functionality(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47100 - Change related formulas and named ranges when XSSFWorkbook.setSheetName is called(poi-developers)</li>
</ul>
<a name="3.8-beta1"></a>
<div class="h3">
<h3>Version 3.8-beta1 (2011-03-07)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">50610 - Ant tasks for running POI against a workbook(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">32903 - Correct XBAT chaining explanation in /poifs/fileformat.html(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50829 - Support for getting the tables associated with a XSSFSheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50299 - More XSSFColor updates for ARGB vs RGB(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50581 - Use stax:stax-api instead of org.apache.geronimo.specs:geronimo-stax-api_1.0_spec(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50786 - Fix XSSFColor to fetch the RGB values of old-style indexed colours(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50299 - Fix XSSFColor fetching of white and black background themes(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50795 - Avoid NPE from xmlbeans when moving XSSF Comments from one cell to another(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46664 - When creating HSSF Print Areas, ensure the named range is reference based not value based(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50756 - When formatting numbers based on their Cell Style, treat GENERAL the same as the more typical General(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">fixed HSSFWorkbook.createCellStyle to throw exception if the maximum number of cell styles was exceeded(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50539 - Better fix for html-style br tags (invalid XML) inside XSSF documents(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49928 - allow overridden built-in formats in HSSFCellStyle(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50607 - Added implementation for CLEAN(), CHAR() and ADDRESS()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50587 - Improved documentation on user-defined functions(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Inside ExtractorFactory, support finding embedded OOXML documents and providing extractors for them(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Partial HDGF LZW compression support(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50244 - Support for continued NameRecords(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50416 - Correct shifting of the first or last row in a sheet by multiple rows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50440 - Support evaluating formulas with newlines in them, which XSSF may have (but HSSF may not)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added inline string support to XSSF EventModel(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50246 - Properly position GutsRecord when reading HSSF workbooks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48539 - Added implementation for MROUND(), VAR() and VARP()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50446 - Code cleanup and optimizations to keep some IDE quiet(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50437 - Support passing ranges to NPV()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50409 - Added implementation for IRR()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47405 - Improved performance of RowRecordsAggregate.getStartRowNumberForBlock / getEndRowNumberForBlock(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50315 - Avoid crashing Excel when sorting XSSFSheet autofilter(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50076 - Allow access from XSSFReader to sheet comments and headers/footers(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">50076 - Refactor XSSFEventBasedExcelExtractor to make it easier for you to have control over outputting the cell contents(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50258 - avoid corruption of XSSFWorkbook after applying XSSFRichTextRun#applyFont(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50154 - Allow white spaces and unicode in OPC relationship targets (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50113 - Remove cell from Calculation Chain after setting cell type to blank (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49966 - Ensure that XSSFRow#removeCell cleares calculation chain entries (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50096 - Fixed evaluation of cell references with column index greater than 255 (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49761 - Tolerate Double.NaN when reading .xls files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50211 - Use cached formula result when auto-sizing formula cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50118 - OLE2 does allow a directory with an empty name, so support this in POIFS(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50119 - avoid NPE when XSSFReader comes across chart sheets(poi-developers)</li>
</ul>
<a name="3.7"></a>
<div class="h3">
<h3>Version 3.7 (2010-10-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50075 - avoid NPE in ListLevel.getNumberText() when numberText is null (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50067 - marked commons-logging and log4j as optional dependencies in POI poms(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49928 - allow overridden built-in formats in XSSFCellStyle(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49919 - support for BorderCode in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49908 - support for processing of symbols in HWPF(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50022 - support for retrieving pictures from HSSF workbooks(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50020 - Avoid IllegalStateException when creating Data validation in sheet with macro(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">50033 - Improved rounding in MOD(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Generate SHA1 hashes of distribution files, alongside existing MD5 ones(poi-developers)</li>
</ul>
<a name="3.7-beta3"></a>
<div class="h3">
<h3>Version 3.7-beta3 (2010-09-24)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48325 - If a HSSF header or footer lacks left/right/centre information, assume it is a centre one(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49966 - Correctly remove calcChain entries for XSSF cells that stop holding formulas(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47582 - XSSFCellStyle support for creating a style in one workbook based on a style from a different one(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49931 - Avoid concurrency problems when re-ordering multiple HSSF header records for a PageSettingsBlock(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49765 - Fix XWPFDocument.addPicture so that it correctly sets up relationships(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48018 - Improve HWPF handling of lists in documents read and then saved, by preserving order better(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49820 - Fix HWPF paragraph levels, so that outline levels can be properly fetched(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47271 - Avoid infinite loops on broken HWPF documents with a corrupt CHP style with a parent of itself(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49936 - Handle HWPF documents with problematic HeaderStories better(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49933 - Support sections in Word 6 and Word 95 files (HWPFOldDocument)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49941 - Correctly handle space preservation of XSSFRichTextRuns when applying fonts to parts of the string(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Correct XWPFRun detection of bold/italic in a paragraph with multiple runs of different styles(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Link XWPFPicture to XWPFRun, so that embedded pictures can be access from where they live in the text stream(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improve handling of Hyperlinks inside XWPFParagraph objects through XWPFHyperlinkRun(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Make XWPFParagraph make more use of XWPFRun, and less on internal StringBuffers(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add a getBodyElements() method to XWPF IBody, to make access to embedded paragraphs and tables easier(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">More XSLFRelation entries for common .pptx file parts(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49872 - avoid exception in XSSFFormulaEvaluator.evaluateInCell when evaluating shared formulas(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49895 - avoid corruption of XSSFWorkbook after removing all merged cells from sheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49907 - fixed inconsistent behaviour between HSSF and XSSF when creating consecutive names(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add getMimeType() method to HWPF Picture, alongside existing file extension(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add code for reading Ole10Native data(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add getMimeType() method to HSSF/XSSF PictureData, alongside existing file extension(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49887 - allow sheet names longer than 31 chars in XSSF, enforce name uniqueness on the first 31 chars(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49878 - improved API for hiding sheets(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49875 - fixed XSSFWorkbook.createSheet to throw exception if sheet name begins or ends with a single quote (')(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49873 - fixed XSSFFormulaEvaluator to support blank cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49850 - added a getter for _iStartAt in ListFormatOverrideLevel(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49761 - change cell type to error when setting Double.NaN or Infinities(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49833 - ensure that CTNumPr is included in poi-ooxml-schemas.jar(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49841 - fixed LEFT and RIGHT to return #VALUE! when called with a negative operand (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49783 - fixed evaluation of XSSF workbooks containing formulas with reference errors (#REF!)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49751 - fixed fetching names of user defined styles in HSSFCellStyle.getUserStyleName()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48900 - support for protecting a XSSF workbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49725 - fixed FormulaParser to correctly process defined names with underscore(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48526 - added implementation for RANDBETWEEN()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49725 - avoid exception in OperandResolver.parseDouble when input is minus ("-")(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49723 - fixed OperandResolver to correctly handle inputs with leading decimal place(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">initial support for Excel autofilter(POI-DEVELOPERS)</li>
</ul>
<a name="3.7-beta2"></a>
<div class="h3">
<h3>Version 3.7-beta2 (2010-08-09)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">47990 - Support for .msg attachments within a MAPIMessage .msg(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improve handling and warnings when closing OPCPackage objects(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49702 - Correct XSSFWorkbook.getNumCellStyles to check the right styles list(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49690 - Add WorkbookUtil, which provies a way of generating valid sheet names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49694 - Use DataFormatter when autosizing columns, to better match the real display width of formatted cells(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49441 - Allow overriding and guessing of HSMF non-unicode string encodings(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49689 - Allow the setting of user style names on newly created HSSF cell styles(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Make it easier to tell which content types each POIXMLTextExtractor handles(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49649 - Added clone support for UserSView* and Feat* families of records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49653 - Support for escaped unicode characters in Shared String Table(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49579 - prevent ArrayIndexOutOfBoundException in UnknowEscherRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49593 - preserve leading and trailing white spaces in XWPFRun(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49455 - Insert the content of fldSimple fields into the XWPFWordTextExtractor output(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49640 - Fixed parsing formulas containing defined names beginning with an underscore(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49538 - Added implementation for POISSON()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49524 - Support for setting cell text to be vertically rotated, via style.setRotation(0xff)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49609 - Case insensitive matching of OOXML part names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49581 - Ability to add, modify and remove series from HSSF Charts(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49185 - Support for HSSFNames where the comment is stored in a NameCommentRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49599 - correct writing of noterecord author text when switching between ascii and unicode(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">hwpf: improve reading of auto-saved ("complex") documents(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">paragraph level as well as whole-file text extraction for word 6/95 files through hwpf(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">text extraction support for older word 6 and word 95 files via hwpf(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49508 - allow the addition of paragraphs to xwpf table cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49446 - don't consider 17.16.23 field codes as properly part of the paragraph's text(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">xslfslideshow shouldn't break on .thmx (theme) files. support for them is still very limited though(poi-developers)</li>
</ul>
<a name="3.7-beta1"></a>
<div class="h3">
<h3>Version 3.7-beta1 (2010-06-20)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49432 - lazy caching of xssfcomment ctcomment objects by reference, to make repeated comment searching faster(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">better handling of outlook messages in hsmf when there's no recipient email address(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">when formatting numbers with dataformatter, handle brackets following colours(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48574 - further xwpf support for tables, paragraphs, including enhanced support for adding new ones(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48245 - tweak hwpf table cell detection to work across more files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48996 - initial support for external name references in hssf formula evaluation(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46664 - fix up tab ids when adding new sheets, so that print areas don't end up invalid(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45269 - improve replacetext on hwpf ranges(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47815 - correct documentation on what happens when you request a string from a non-string formula cell(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49386 - avoid npe when extracting ooxml file properties which are dates(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49377 - only call decimalformat.setroundingmode on java 1.6 - it's needed to match excel's rendering of numbers(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49378 - correct 1.6ism(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">parse the hsmf headers chunk if present, and use it to find dates in text extraction if needed(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48494 - detect and support time formats like hh:mm;hh:mm(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48494 - have excelextractor make use of hssfdataformatter, so that numbers and dates come out closer to how excel would render them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48494 - have eventbasedexcelextractor make use of hssfdataformatter, so that numbers and dates come out closer to how excel would render them(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49096 - add clone support to chart begin and end records, to allow cloning of more chart containing sheets(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">list attachment names in the output of outlooktextextractor (to get attachment contents, use extractorfactory as normal)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48872 - allow dateformatter.formatrawcellcontents to handle 1904 as well as 1900 dates(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48872 - handle mmmmm and elapsed time formatting rules in dataformatter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48872 - handle zero formatting rules, and better color detection in dataformatter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48872 - support for more kinds of formatting in dataformatter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43161 - fixed construction of the dib picture header(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49311 - initial support for reading aes-encrypted/write-protected ooxml files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48718 - make the creation of multiple, un-modified fonts in a row in xssf match the old hssf behaviour(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44916 - allow access to the hssfpatriarch from hssfsheet once created(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48779 - allow you to get straight from a cellstyle to a color, irrespective of if the color is indexed or inline-defined(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48924 - allow access of the hwpf dateandtime underlying date values(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48926 - initial support for the hwpf revision marks authors list(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49160 - ensure that ctdigsigblob is included in poi-ooxml jar(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49189 - detect w:tab and w:cr entries in xwpf paragraphs, even when the xsd is silly and maps them to ctempty(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49273 - correct handling for font character sets with indicies greater than 127(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49334 - track the valuerangerecords of charts in hssfchart, to allow the basic axis operations(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49242 - track the linkdatarecords of charts in hssfchart(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">improved performance of xssfworkbook.write (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48846 - avoid npe when finding cell comments(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49325 - ensure that ctphoneticpr is included in poi-ooxml jar(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49191 - fixed tests failing in non-english locales(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48432 - support for xssf themes(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49244 - support for data validation for ooxml format(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49066 - worksheet/cell formatting, with view and html converter(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49020 - workaround excel outputting invalid xml in button definitions by not closing br tags(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49050 - improve performance of abstractescherholderrecord when there are lots of continue records(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49194 - correct text size limit for ooxml .xlsx files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49254 - fix cellutils.setfont to use the correct type internally(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49139 - properly support 4k big block size in poifs(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48936 - avoid writing malformed cdata blocks in sharedstrings.xml(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49026 - added implementation for text() (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49025 - added implementation for trunc() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49147 - properly close internal inputstream in extractorfactory#createextractor(file)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49138 - fixed locale-sensitive formatters in packagepropertiespart(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">49153 - ensure that ctvectorvariant is included in poi-ooxml-schemas.jar(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">49146 - added accessors to coreproperties.keywords (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48916 - propagate parent to parent-aware records decoded from escher(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48485 - add extra paper size constans to printsetup, such as a3, b4 and b5(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">make poifs.filesystem.directorynode preserve the original ordering of its files, which hsmf needs to be able to correctly match up chunks(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">support evaluation of indirect defined names in indirect(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43670 - improve hdgf chunkv11 separator detection, and short string detection, to solve the "negative length of chunkheader" problem(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48617 - optionally allow the overriding of the locale used by dataformatter to control how the default number and date formats should look(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">new event based xssf text extractor (xssfeventbasedexcelextractor)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">extractorfactory can now be told to prefer event based extractors (current excel only) on a per-thread or overall basis(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48544 - avoid failures in xlsx2csv when shared string table is missing(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48571 - properly close all io streams created in opcpackage(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48572 - always copy all declared inner classes and interfaces when generating poi-ooxml-schemas(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">low level record support for the extrst (phonetic text) part of unicode strings. no usermodel access to it as yet though.(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">record.unicodestring has moved to record.common.unicodestring, to live with the other record-part classes, as it isn't a full record.(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">avoid creating temporary files when opening opc packages from input stream(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">improved how hsmf handles multiple recipients(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">add publishertextextractor support to extractorfactory(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">add xslf support for text extraction from tables(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">support attachments as embeded documents within the new outlooktextextractor(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">add a text extractor (outlooktextextractor) to hsmf for simpler extraction of text from .msg files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">some improvements to hsmf parsing of .msg files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">initialise the link type of hssfhyperlink, so that gettype() on it works(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48425 - improved performance of dateutil.iscelldateformatted() (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47215 - fixed interfaceendrecord to tolerate unexpected record contents (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48415 - improved javadoc on hsspicture.resize() (poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">added ant target to install artifacts in local repository (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48026 - fixed pagesettingsblock to allow multiple headerfooterrecord records (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48202 - fixed cellrangeutil.mergecellranges to work for adjacent cell regions (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48339 - fixed externalnamerecord to properly distinguish dde data from ole data items (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47920 - allow editing workbooks embedded into powerpoint files(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48343 - added implementation of subtotal function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">switch to compiling the ooxml schemas for java 1.5(poi-developers)</li>
</ul>
<a name="3.6"></a>
<div class="h3">
<h3>Version 3.6 (2009-12-14)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48332 - fixed xssfsheet autosizecolumn() to tolerate empty richtextstring(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48332 - fixed columninforecord to tolerate missing reserved field(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47701 - fixed recordformatexception when reading list subrecords (lbsdatasubrecord)(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg"> memory usage optimization in xssf - avoid creating parentless xml beans(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47188 - avoid corruption of workbook when adding cell comments (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48106 - improved work with cell comments in xssf(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">add support for creating summaryinformation and documentsummaryinformation properties
on poidocuments that don't have them, via poidocument.createinformationproperties()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48180 - be more forgiving of short chart records, which skip some unused fields(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48274 - fix erronious wrapping of byte colours in hssfpalette.findsimilarcolor(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48269 - fix fetching of error codes from xssf formula cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48229 - fixed javadoc for hssfsheet.setcolumnwidth and xssfsheet setcolumnwidth (poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47757 - fixed xlsx2csv to avoid exception when processing cells with multiple "t" elements(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48195 - short-circuit evaluation of if() and choose()(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48161 - support for text extraction from ppt master slides(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47970 - added a method to set arabic mode in hssfsheet(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48134 - release system resources when using picture.resize()(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48087 - avoid npe in xssfchartsheet when calling methods of the superclass(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48038 - handle reading hwpf stylesheets from non zero offsets(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">when running the "compile-ooxml-xsds" ant task, also generate the source jar for the ooxml schemas(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45672 - improve handling by missingrecordawarehssflistener of records that cover multiple cells (mulblankrecord and mulrkrecord)(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48096 - relaxed validation check in recalcidrecord(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48085 - improved error checking in blockallocationtablereader to trap unreasonable field values(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47924 - fixed logic for matching cells and comments in hssfcell.getcellcomment()(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47942 - added implementation of protection features to xlsx and docx files(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48070 - preserve leading and trailing white spaces in xssfrichtextstring(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">48044 - added implementation for countblank function(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">48036 - added intersectioneval to allow evaluation of the intersection formula operator(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47999 - avoid un-needed call to the jvm garbage collector when working on ooxml opc packages(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47922 - added example hsmf application that converts a .msg file to text and extracts attachments(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47903 - added ant target to compile scratchpad examples(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47839 - improved api for ooxml custom properties(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47862 - fixed xssfsheet.setcolumnwidth to handle columns included in a column span(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47804 - fixed xssfsheet.setcolumnhidden to handle columns included in a column span(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47889 - fixed xssfcell.getstringcellvalue() to properly handle cached formula results(poi-developers)</li>
</ul>
<a name="3.5-final"></a>
<div class="h3">
<h3>Version 3.5-final (2009-09-28)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47747 - fixed logic for locating shared formula records(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47809 - improved work with user-defined functions(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47581 - fixed xssfsheet.setcolumnwidth to produce xml compatible with mac excel 2008(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47734 - removed unnecessary svn:executable flag from files in svn trunk(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47543 - added javadoc how to avoid excel crash when creating too many hssfrichtextstring cells(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47813 - fixed problems with xssfworkbook.removesheetat when workbook contains chart(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47737 - adjust sheet indices of named ranges when deleting sheets(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47770 - built-in positive formats don't need starting '('(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47771 - added method setfunction(boolean) for defined names(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47768 - implementation of excel "days360" and "npv" functions(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47751 - do not allow hssf's cell text longer than 32,767 characters(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47757 - added an example demonstrating how to convert an xlsx workbook to csv(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44770 - fixed ppt parser to tolerate comment2000 containers with missing comment text(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47773 - fix for extraction paragraphs and sections from headers/footers with xwpfwordextractor(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47727 - support for extraction of header / footer images in hwpf(poi-developers)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">moved all test data to a top-level directory(poi-developers)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47721 - Added implementation for INDIRECT()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45583 - Avoid exception when reading ClipboardData packet in OLE property sets(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47652 - Added support for reading encrypted workbooks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47604 - Implementation of an XML to XLSX Importer using Custom XML Mapping(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47620 - Avoid FormulaParseException in XSSFWorkbook.setRepeatingRowsAndColumns when removing repeated rows and columns(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47606 - Fixed XSSFCell to correctly parse column indexes greater than 702 (ZZ)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47598 - Improved formula evaluator number comparison(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47571 - Fixed XWPFWordExtractor to extract inserted/deleted text(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47548 - Fixed RecordFactoryInputStream to properly read continued DrawingRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46419 - Fixed compatibility issue with OpenOffice 3.0(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47559 - Fixed compatibility issue with Excel 2008 Mac sp2. Please see
<a href="./spreadsheet/index.html"> the HSSF+XSSF project page</a> for more information. (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47540 - Fix for saving custom and extended OOXML properties(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47535 - Fixed WordExtractor to tolerate files with empty footnote block(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47517 - Fixed ExtractorFactory to support .xltx and .dotx files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45556 - Support for extraction of footnotes from docx files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45555 - Support for extraction of endnotes from docx files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47520 - Initial support for custom XML mappings in XSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47460 - Fixed NPE when retrieving core properties from a newly created workbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47498 - Fixed HyperlinkRecord to properly handle URL monikers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47504 - Fixed XSSFWorkbook to read files with hyperlinks to document locations(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47479 - Fix BoolErrRecord to tolerate incorrect format written by OOO(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47448 - Allow HSSFEventFactory to handle non-zero padding at the end of the workbook stream(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47456 - Support for getting OLE object data in PowerPointExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47411 - Explicitly set the 1900 date system when creating XSSF workbooks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47400 - Support for text extraction of footnotes, endnotes and comments in HWPF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47415 - Fixed PageSettingsBlock to allow multiple PLS records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47412 - Fixed concurrency issue with EscherProperties.initProps()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47143 - Fixed OOM in HSSFWorkbook#getAllPictures when reading .xls files containing metafiles(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added implementation for ISNA()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46793 - fixed SimpleShape#getLineWidth to handle default line width (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47356 - removed unused private fields in HWPF BorderCode(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47355 - Improved HWPF TableCell to expose TableCellDescriptor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46610 - Improved HWPF to better handle unicode(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47261 - Fixed SlideShow#removeSlide to remove references to Notes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47375 - Fixed HSSFHyperlink to correctly set inter-sheet and file links(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47384 - Fixed ExternalNameRecord to handle unicode names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47372 - Fixed locale-sensitive unit tests to pass when running on non-US locale(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta6"></a>
<div class="h3">
<h3>Version 3.5-beta6 (2009-06-22)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47363 - Fixed HSSFSheet to allow addition of data validations after sheet protection(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47294 - Fixed XSSFWorkbook#setRepeatingRowsAndColumns to tolerate sheet names with quotes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47309 - Fixed logic in HSSFCell.getCellComment to handle sheets with more than 65536 comments(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46776 - Added clone() method to MulBlankRecord to fix crash in Sheet.cloneSheet()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47244 - Fixed HSSFSheet to handle missing header / footer records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47312 - Fixed formula parser to properly reject cell references with a '0' row component(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47199 - Fixed PageSettingsBlock/Sheet to tolerate margin records after other non-PSB records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47069 - Fixed HSSFSheet#getFirstRowNum and HSSFSheet#getLastRowNum to return correct values after removal of all rows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47278 - Fixed XSSFCell to avoid generating xsi:nil entries in shared string table(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47206 - Fixed XSSFCell to properly read inline strings(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47250 - Fixed FontRecord to expect unicode flags even when name length is zero(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47198 - Fixed formula evaluator comparison of -0.0 and 0.0(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47229 - Fixed ExternalNameRecord to handle DDE links(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46287 - Control of header and footer extraction in ExcelExtractor / XSSFExcelExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46554 - New ant target "jar-examples"(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46161 - Support in XSSF for setGroupColumnCollapsed and setGroupRowCollapsed(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46806 - Allow columns greater than 255 and rows greater than 0x100000 in XSSF formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">41711 - Base class for "old version" exceptions, and new HSLF detection + use of old versions exception(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47179 - Fix string encoding issues with HSMF chunks on non-windows platforms(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">47183 - Attachment support for HSMF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47154 - Handle the cell format @ as the same as General(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47048 - Fixed evaluation of defined names with the 'complex' flag set(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46953 - More tweaks to PageSettingsBlock parsing logic in Sheet constructor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47089 - Fixed XSSFWorkbook.createSheet to properly increment sheetId(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46568 - Fixed XSLFPowerPointExtractor to properly process line breaks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">39056 - Fixed POIFSFileSystem to set CLSID of root when constructing instances from InputStream(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47054 - Fixed cloneStyleFrom to avoid exception when cloning styles of the same family(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46186 - Fixed Sheet to read GutsRecord in the Sheet(RecordStream rs)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46714 - Automatically call sheet.setAlternativeExpression when sheet.setRowSumsBelow is called (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46279 - Allow 255 arguments for excel functions in XSSF (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47028 - Fixed XSSFCell to preserve cell style when cell value is set to blank(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47026 - Avoid NPE in XSSFCell.setCellType() when workbook does not have SST(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46987 - Allow RecordFactory to handle non-zero padding at the end of the workbook stream(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47034 - Fix reading the name of a NameRecord when the name is very long(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">47001 - Fixed WriteAccessRecord and LinkTable to handle unusual format written by Google Docs(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46973 - Fixed defined names to behave better when refersToFormula is unset(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46832 - Allow merged regions with columns greater than 255 or rows bigger than 65536 in XSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46951 - Fixed formula parser to better handle range operators and whole row/column refs.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46948 - Fixed evaluation of range operator to allow for area-ref operands(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46918 - Fixed ExtendedPivotTableViewFieldsRecord(SXVDEX) to allow shorter format(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46898 - Fixed formula evaluator to not cache intermediate circular-reference error results(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46917 - Fixed PageItemRecord(SXPI) to allow multiple field infos(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46904 - Fix POIFS issue with duplicate block 0 references on very old BIFF5/BIFF7 files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46840 - PageSettingsBlock should include HEADERFOOTER record(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46885 - update cell type when setting cached formula result in XSSFCell(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">added modifiers for anchor type to XSSFClientAnchor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46772 - support built-in data formats in XSSFDataFormat(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46719 - fixed XSSFSheet.shiftRows to correctly preserve row heights(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46715 - preserve custom column widths across re-serialization of XSSFWorkbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46703 - added setDisplayZeros / isDisplayZeros to common interface org.apache.poi.ss.usermodel.Sheet(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46708 - added getMergedRegion(int) to common interface org.apache.poi.ss.usermodel.Sheet(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">fixed Sheet.autoSizeColumn() to use cached formula values when processing formula cells (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed formula parser to handle names with backslashes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46660 - added Workbook getHidden() and setHidden(boolean)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46693 - Fixed bugs serialization bugs in records: CHARTFORMAT, SHTPROPS, SXVD and SXVDEX(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46627 - Fixed offset of added images if Pictures stream contains pictures with zero length(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta5"></a>
<div class="h3">
<h3>Version 3.5-beta5 (2009-02-19)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46536 - When shifting rows, update formulas on that sheet to point to the new location of those rows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46663 - Fixed XSSFSheet.shiftRows to properly update references of the shifted cells(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46535 - Remove reference from calculation chain when a formula is deleted(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46654 - HSSFRow/RowRecord to properly update cell boundary indexes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46643 - Fixed formula parser to encode range operator with tMemFunc(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46647 - Fixed COUNTIF NE operator and other special cases involving type conversion(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46635 - Added a method to remove slides(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">40520 - Fixed HSSFFont.applyFont() to properly apply font to overlapping regions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46545 - Fixed ObjRecord to ignore excessive padding written by previous POI versions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46613 - Fixed evaluator to perform case insensitive string comparisons(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46544 - command line interface for hssf ExcelExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46547 - Allow addition of conditional formatting after data validation(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46548 - Page Settings Block fixes - continued PLS records and PSB in sheet sub-streams(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46523 - added implementation for SUMIF function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for reading HSSF column styles(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Hook up POIXMLTextExtractor.getMetadataTextExtractor() to the already written POIXMLPropertiesTextExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46472 - Avoid NPE in HPSFPropertiesExtractor when no properties exist(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46479 - fixed bugs related to cached formula values and HSSFFormulaEvaluator.evaluateInCell()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45031 - added implementation for CHOOSE() function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46361 - resolve licensing issues around the HDGF resource file, chunks_parse_cmds.tbl(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46410 - added implementation for TIME() function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46320 - added HSSFPictureData.getFormat()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46445 - fixed HSSFSheet.shiftRow to move hyperlinks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">fixed formula parser to correctly resolve sheet-level names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46433 - support for shared formulas in XSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46299 - support for carriage return and line break in XWPFRun(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46300 - support for line spacing in XWPFParagraph(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46308 - initial support for creation of XWPFTable(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added getters to parent objects: HSSFSheet.getWorkbook(), HSSFRow.getSheet() and HSSFCell.getRow()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46385 - (also patch 46362) fix serialization of StyleRecord with unicode name(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46368 - Fix HSSFRichTextRun and strings longer than 32768 characters(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support sheet-level names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed XSSFCell to properly handle cell references with column numbers up to XFD(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44914 - Fixed warning message "WARN. Unread n bytes of record 0xNN"(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46156 - Improved number to text conversion to be closer to that of Excel(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46312 - Fixed ValueRecordsAggregate to handle removal of new empty row(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46269 - Improved error message when attempting to read BIFF2 file(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46206 - Fixed Sheet to tolerate missing DIMENSION records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46301 - added pivot table records: SXDI, SXVDEX, SXPI, SXIDSTM, SXVIEW, SXVD, SXVS, et al(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46280 - Fixed RowRecordsAggregate etc to properly skip PivotTable records(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta4"></a>
<div class="h3">
<h3>Version 3.5-beta4 (2008-11-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46213 - Fixed FormulaRecordAggregate to gracefully ignore extra StringRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46174 - Fixed HSSFName to handle general formulas (not just area references)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46189 - added chart records: CHARTFRTINFO, STARTBLOCK, ENDBLOCK, STARTOBJECT, ENDOBJECT, and CATLAB(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46199 - More tweaks to EmbeddedObjectRefSubRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Changes to formula evaluation allowing for reduced memory usage(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45290 - Support odd files where the POIFS header block comes after the data blocks, and is on the data blocks list(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46184 - More odd escaped date formats(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Include the sheet number in the output of XLS2CSVmra(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46043 - correctly write out HPSF properties with HWPF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45973 - added CreationHelper.createFormulaEvaluator(), implemeted both for HSSF and XSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46182 - fixed Slideshow.readPictures() to skip pictures with invalid headers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46137 - Handle odd files with a ContinueRecord after EOFRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed problem with linking shared formulas when ranges overlap(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45784 - More fixes to SeriesTextRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46033 - fixed TableCell to correctly set text type(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46122 - fixed Picture.draw to skip rendering if picture data was not found(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">15716 - memory usage optimisation - converted Ptg arrays into Formula objects(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">46065 - added implementation for VALUE function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45966 - added implementation for FIND function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45778 - fixed ObjRecord to read ftLbsData properly(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">46053 - fixed evaluation cache dependency analysis when changing blank cells(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta3"></a>
<div class="h3">
<h3>Version 3.5-beta3 (2008-09-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45518 - Fix up ColumnHelper to output valid col tags, by making 1 based and 0 based bits clearer, and using the right ones(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45676 - Handle very long cells in the XSSF EventUserModel example(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial ExtractorFactory support for building TextExtractors for embeded documents(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta2"></a>
<div class="h3">
<h3>Version 3.5-beta2 (2008-08-20)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support stripping XSSF header and footer fields (eg page number) out of header and footer text if required(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add POIXMLPropertiesTextExtractor, which provides to the OOXML file formats a similar function to HPSF's HPSFPropertiesExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45539 - Improve XWPFWordExtractor to extract headers and footers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improve how XWPF handles paragraph text(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support in XWPF handles headers and footers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45592 - Improve XWPF text extraction to include tables always, and picture text where possible(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45545 - Improve XSLF usermodel support, and include XSLF comments in extracted text(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45540 - Fix XSSF header and footer support, and include headers and footers in the output of XSSFExcelExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45431 - Support for .xlsm files, sufficient for simple files to be loaded by excel without warning(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">New class org.apache.poi.hssf.record.RecordFormatException, which DDF uses instead of the HSSF version, and the HSSF version inherits from(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45431 - Partial support for .xlm files. Not quite enough for excel to load them though(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45430 - Correct named range sheet reporting when no local sheet id is given in the xml(POI-DEVELOPERS)</li>
</ul>
<a name="3.5-beta1"></a>
<div class="h3">
<h3>Version 3.5-beta1 (2008-07-18)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">45018 - Support for fetching embeded documents from within an OOXML file(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Port support for setting a policy on missing / blank cells when fetching, to XSSF too(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Common text extraction factory, which returns the correct POITextExtractor for the supplied data(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Text Extraction support for the new OOXML files (.xlsx, .docx and .pptx)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for processing OOXML Excel files (.xlsx), both directly through XSSF, and also through the new common UserModel(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Created a common interface for handling PowerPoint files, irrespective of if they are .ppt or .pptx(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Created a common interface for handling Excel files, irrespective of if they are .xls or .xlsx(POI-DEVELOPERS)</li>
</ul>
<a name="3.2-FINAL"></a>
<div class="h3">
<h3>Version 3.2-FINAL (2008-10-19)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45866 - allowed for change of unicode compression across Continue records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45964 - support for link formulas in Text Objects(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43354 - support for evalating formulas with missing args(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45912 - fixed ArrayIndexOutOfBoundsException in EmbeddedObjectRefSubRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45889 - fixed ArrayIndexOutOfBoundsException when constructing HSLF Table with a single row (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for creating hyperlinks in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45876 - fixed BoundSheetRecord to allow sheet names longer than 31 chars(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45890 - fixed HSSFSheet.shiftRows to also update conditional formats(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45865 modified Formula Parser/Evaluator to handle cross-worksheet formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Optimised the FormulaEvaluator to take cell dependencies into account(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">16936 - Initial support for whole-row cell styling(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Update hssf.extractor.ExcelExtractor to optionally output blank cells too(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Include the sheet name in the output of examples.XLS2CSVmra(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45784 - Support long chart titles in SeriesTextRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45777 - Throw an exception if HSSF Footer or Header is attemped to be set too long, rather than having it break during writing out(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45844 - Addtional diagnostics for HSLF SlideShowRecordDumper(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45829 - HSSFPicture.getImageDimension() failed when DPI of image is zero(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45815 - Bit mask values in StyleTextPropAtom were not preserved across read-write(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45814 - Specify RecordType for slide show Handout (4041)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45805 - Fixed 16-bit signed/unsigned bug in HSSFSheet.getColWidth etc(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45780 - Fixed HSSFSheet.shiftRows to also update Area refs(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45804 - Update HSMF to handle Outlook 3.0 msg files, which have a different string chunk type(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Expose the name of Named Cell Styles via HSSFCellStyle (normally held on the parent style though)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45978 - Fixed IOOBE in Ref3DPtg.toFormulaString() due eager initialisation of SheetReferences(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Made HSSFFormulaEvaluator no longer require initialisation with sheet or row(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Extended support for cached results of formula cells(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45639 - Fixed AIOOBE due to bad index logic in ColumnInfoRecordsAggregate(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed special cases of INDEX function (single column/single row, errors)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45761 - Support for Very Hidden excel sheets in HSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45738 - Initial HWPF support for Office Art Shapes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45720 - Fixed HSSFWorkbook.cloneSheet to correctly clone sheets with drawings(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45728 - Fix for SlideShow.reorderSlide in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for embedded movies and controls in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45358 - signed/unsigned error when parsing 3-d area refs, performance problem evaluating area refs, and ClassCastExcecption in IF()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for HPBF Publisher hyperlinks, including during text extraction(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">26321 and 44958 - preserve position of ArrayRecords and TableRecords among cell value records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Impove empty header or footer handling in HWPF HeaderStories(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Avoid NPE in hssf.usermodel.HeaderFooter when stripping fields out(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Avoid NPE in EscherBSERecord on older escher records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Basic text extractraction support in HPBF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial, low level support for Publisher files, in the form of HPBF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45699 - Fix RowRecordsAggregate to tolerate intervening MERGEDCELLS records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45698 - Fix LinkTable to tolerate multiple EXTERNSHEET records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45682 - Fix for cloning of CFRecordsAggregate(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for evaluating external add-in functions like YEARFRAC(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45672 - Fix for MissingRecordAwareHSSFListener to prevent multiple LastCellOfRowDummyRecords when shared formulas are present(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45645 - Fix for HSSFSheet.autoSizeColumn() for widths exceeding Short.MAX_VALUE(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45623 - Support for additional HSSF header and footer fields, including bold and full file path(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45623 - Support stripping HSSF header and footer fields (eg page number) out of header and footer text if required(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45622 - Support stripping HWPF fields (eg macros) out of text, via Range.stripFields(text)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">New HPSF based TextExtractor for document metadata, org.apache.poi.hpsf.extractor.HPSFPropertiesExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Properly update the array of Slide's text runs in HSLF when new text shapes are added(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45590 - Fix for Header/footer extraction for .ppt files saved in Office 2007(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Big improvement in how HWPF handles unicode text, and more sanity checking of text ranges within HWPF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Include headers and footers int he extracted text from HWPF's WordExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added support to HWPF for headers and footers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improve how HWPF deals with unicode internally. Should avoid some odd behaviour when manipulating unicode text(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45577 - Added implementations for Excel functions NOW and TODAY(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45582 - Fix for workbook streams with extra bytes trailing the EOFRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45537 - Include headers and footers (of slides and notes) in the extracted text from HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45472 - Fixed incorrect default row height in OpenOffice 2.3(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44692 - HSSFPicture.resize() stretched image when there was a text next to it(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45543 - Optionally extract comment text with PowerPointExtractor, and initial hslf model support for comments(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45538 - Include excel headers and footers in the output of ExcelExtractor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44894 - refactor duplicate logic from EventRecordFactory to RecordFactory(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for Headers / Footers in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44953 - Extensive fixes for data validation(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45519 - Fixed to keep datavalidation records together(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for creating new HSLF CurrentUserAtoms(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45466 - Partial support for removing excel comments (won't work for all excel versions yet)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45437 - Detect encrypted word documents, and throw an EncryptedDocumentException instead of a OOM(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45404 - New class, hssf.usermodel.HSSFDataFormatter, for formatting numbers and dates in the same way that Excel does(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45414 - Don't add too many UncalcedRecords to sheets with charts in them(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45398 - Support detecting date formats containing "am/pm" as date times(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45410 - Removed dependency from contrib on commons beanutils,collections and lang(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">New helper, HSSFOptimiser, which handles removing duplicated font and style records, to avoid going over the limits in Excel(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45322 - Fixed NPE in HSSFSheet.autoSizeColumn() when cell number format was not found(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45380 - Missing return keyword in ArrayPtg.toFormulaString()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44958 - Record level support for Data Tables. (No formula parser support though)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">35583 - Include a version class, org.apache.poi.Version, to allow easy introspection of the POI version(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Allow the cloning of one HSSFCellStyle onto another, including cloning styles from one HSSFWorkbook onto another(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45289 - finished support for special comparison operators in COUNTIF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45126 - Avoid generating multiple NamedRanges with the same name, which Excel dislikes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix cell.getRichStringCellValue() for formula cells with string results(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45365 - Handle more excel number formatting rules in FormatTrackingHSSFListener / XLS2CSVmra(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45373 - Improve the performance of HSSFSheet.shiftRows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45367 - Fixed bug when last row removed from sheet is row zero(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45348 - Tweaks to RVA formula logic(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45354 - Fixed recognition of named ranges within formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45338 - Fix HSSFWorkbook to give you the same HSSFFont every time, and then fix it to find newly added fonts(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45336 - Fix HSSFColor.getTripletHash()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45334 - Fixed formula parser to handle dots in identifiers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45252 - Improvement for HWPF Range.replaceText()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45001 - Further fix for HWPF Range.delete() and unicode characters(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45175 - Support for variable length operands in org.apache.poi.hwpf.sprm.SprmOperation(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Avoid spurious missing lines with the MissingRecordAware event code, and odd files that contain RowRecords in the middle of the cell Records.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for parsing formulas during EventUserModel processing, via the new EventWorkbookBuilder(POI-DEVELOPERS)</li>
</ul>
<a name="3.1-final"></a>
<div class="h3">
<h3>Version 3.1-final (2008-06-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">30978 - Fixed re-serialization of tRefErr3d and tAreaErr3d(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45234 - Removed incorrect shared formula conversion in CFRuleRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45001 - Improved HWPF Range.replaceText()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44692 - Fixed HSSFPicture.resize() to properly resize pictures if the underlying columns/rows have modified size(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support custom image renderers in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Correctly increment the reference count of a blip when a picture is inserted(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45110 - Fixed TextShape.resizeToFitText() to properly resize TextShape(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45091 - Fixed serialization of RefN~ tokens. Simplified Ptg class hierarchy(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45133 - Fixed OBJ Record (5Dh) to pad the sub-record data to a 4-byte boundary(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45145 - Fixed Sheet to always enforce RowRecordsAggregate before ValueRecordsAggregate(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45123 - Fixed SharedFormulaRecord.convertSharedFormulas() to propagate token operand classes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45087 - Correctly detect date formats like [Black]YYYY as being date based(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45060 - Improved token class transformation during formula parsing(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44840 - Improved handling of HSSFObjectData, especially for entries with data held not in POIFS(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45043 - Support for getting excel cell comments when extracting text(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Extend the support for specifying a policy to HSSF on missing / blank cells when fetching, to be able to specify the policy at the HSSFWorkbook level(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45025 - improved FormulaParser parse error messages(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45046 - allowed EXTERNALBOOK(0x01AE) to be optional in the LinkTable(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45066 - fixed sheet encoding size mismatch problems(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">45003 - Support embeded HDGF visio documents(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45001 - Partial fix for HWPF Range.insertBefore() and Range.delete() with unicode characters(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44977 - Support for AM/PM in excel date formats(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for specifying a policy to HSSF on missing / blank cells when fetching(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44937 - Partial support for extracting Escher images from HWPF files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44824 - Avoid an infinite loop when reading some HWPF pictures(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44898 - Correctly handle short last blocks in POIFS(POI-DEVELOPERS)</li>
</ul>
<a name="3.1-beta2"></a>
<div class="h3">
<h3>Version 3.1-beta2 (2008-05-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44306 - fixed reading/writing of AttrPtg(type=choose) and method toFormulaString() for CHOOSE formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">24207 - added HSSFName.isDeleted() to check if the name points to cell that no longer exists(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">40414 - fixed selected/active sheet after removing sheet from workbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44523 - fixed workbook sheet selection and focus(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">45000 - Fixed NPE in ListLevel when numberText is null(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44985 - Properly update TextSpecInfoAtom when the parent text is changed(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">41187 - fixed HSSFSheet to properly read xls files without ROW records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44950 - fixed HSSFFormulaEvaluator.evaluateInCell() and Area3DEval.getValue() also added validation for number of elements in AreaEvals(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42570 - fixed LabelRecord to use empty string instead of null when the length is zero.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42564 - fixed ArrayPtg to use ConstantValueParser. Fixed a few other ArrayPtg encoding issues.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Follow-on from 28754 - StringPtg.toFormulaString() should escape double quotes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44929 - Improved error handling in HSSFWorkbook when attempting to read a BIFF5 file(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44675 - Parameter operand classes (function metadata) required to encode SUM() etc properly. Added parse validation for number of parameters(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44921 - allow Ptg.writeBytes() to be called on relative ref Ptgs (RefN* and AreaN*)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44914 - Fix/suppress warning message "WARN. Unread n bytes of record 0xNN"(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44892 - made HSSFWorkbook.getSheet(String) case insensitive(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44886] - Correctly process PICT metafile in EscherMetafileBlip(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44893 - Take into account indentation in HSSFSheet.autoSizeColumn(POI-DEVELOPERS)</li>
</ul>
<a name="3.1-beta1"></a>
<div class="h3">
<h3>Version 3.1-beta1 (2008-04-28)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44857 - Avoid OOM on unknown escher records when EscherMetafileBlip is incorrect(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: Support for getting embedded sounds from slide show (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: Initial support for rendering slides into images(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: Support for getting OLE object data from slide show (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: Implemented more methods in PPGraphics2D(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF: Added Freeform shape which can contain both lines and Bezier curves(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">41071 - Improved text extraction in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">30311 - Conditional Formatting - improved API, added HSSFSheetConditionalFormatting(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Update the formula parser code to use a HSSFWorkbook, rather than the low level model.Workbook, to make things cleaner and make supporting XSSF formulas in future much easier(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix the logger used by POIFSFileSystem, so that commons-logging isn't required when not used(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Update HSLFSlideShow and HSSFWorkbook to take advantage of POIFS updates, and allow reading embeded documents(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Improve how POIFS works with directory entries, and update HWPFDocument to support reading an embeded word document(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for getting and changing chart and series titles(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Implement a proxy HSSFListener which tracks the format records, and lets you lookup the format string for a given cell. Convert the xls to csv example to use it(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44792 - fixed encode/decode problems in ExternalNameRecord and CRNRecord.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43670, 44501 - Fix how HDGF deals with trailing data in the list of chunk headers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">30311 - More work on Conditional Formatting(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">refactored all junits' usage of HSSF.testdata.path to one place(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44739 - Small fixes for conditional formatting (regions with max row/col index)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44694 - HPSF: Support for property sets without sections(RK)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Implement Sheet.removeShape(Shape shape) in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Various fixes: Recognising var-arg built-in functions #44675, ExternalNameRecord serialisation bug #44695, PMT() bug #44691(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">30311 - More work on Conditional Formatting(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Move the Formula Evaluator code out of scratchpad(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Move the missing record aware eventusermodel code out of scratchpad(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44652 / 44603 - Improved handling of Pictures in Word Documents(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44636 - Fix formula parsing of RefVPtg, which was causing #VALUE to be shown on subsequent edits(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44627 - Improve the thread safety of POILogFactory(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">30311 - Initial support for Conditional Formatting(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44609 - Handle leading spaces in formulas, such as '= 4'(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44608 - Support for PercentPtg in the formula evaluator(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44606 - Support calculated string values for evaluated formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add accessors to horizontal and vertical alignment in HSSFTextbox(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44593 - Improved handling of short DVRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">28627 / 44580 - Fix Range.delete() in HWPF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44539 - Support for area references in formulas of rows >= 32768(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44536 - Improved support for detecting read-only recommended files(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43901 - Correctly update the internal last cell number when adding and removing cells (previously sometimes off-by-one)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Added initial support for recognising external functions like YEARFRAC and ISEVEN (using NameXPtg), via LinkTable support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Improvements to FormulaParser - operators, precedence, error literals, quotes in string literals, range checking on IntPtg, formulas with extra un-parsed stuff at the end, improved parse error handling(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Fixed number conversion inconsistencies in many functions, and improved RefEval(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Added initial support for recognising external functions like YEARFRAC and ISEVEN (using NameXPtg), via LinkTable support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Improvements to FormulaParser - operators, precedence, error literals, quotes in string literals, range checking on IntPtg, formulas with extra un-parsed stuff at the end, improved parse error handling(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44504 - Fixed number conversion inconsistencies in many functions, and improved RefEval(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44508 - Fix formula evaluation with evaluateInCell on boolean formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44510 - Fix how DVALRecord works with dropdowns(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44495 - Handle named cell ranges in formulas that have lower case parts(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44491 - Don't have the new-style "HPSF properties are always available" affect the old-style use of HPSF alongside HSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44471 - Crystal Reports generates files with short StyleRecords, which isn't allowed in the spec. Work around this(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44495 - Handle named cell ranges in formulas that have lower case parts(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44491 - Don't have the new-style "HPSF properties are always available" affect the old-style use of HPSF alongside HSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44471 - Crystal Reports generates files with short StyleRecords, which isn't allowed in the spec. Work around this(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44450 - Support for Lookup, HLookup and VLookup functions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44449 - Avoid getting confused when two sheets have shared formulas for the same areas, and when the shared formula is set incorrectly(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44366 - InputStreams passed to POIFSFileSystem are now automatically closed. A warning is generated for people who might've relied on them not being closed before, and a wrapper to restore the old behaviour is supplied(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44371 - Support for the Offset function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">38921 - Have HSSFPalette.findSimilar() work properly(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44456 - Fix the contrib SViewer / SViewerPanel to not fail on sheets with missing rows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44403 - Further support for unusual, but valid, arguments to the Mid function(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44410 - Support for whole-column ranges, such as C:C, in formula strings and the formula evaluator(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44421 - Update Match function to properly support Area references(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44417 - Improved handling of references for the need to quote the sheet name for some formulas, but not when fetching a sheet by name(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44413 - Fix for circular references in INDEX, OFFSET, VLOOKUP formulas, where a cell is actually allowed to reference itself(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44403 - Fix for Mid function handling its arguments wrong(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44364 - Support for Match, NA and SumProduct functions, as well as initial function error support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44375 - Cope with a broken dictionary in Document Summary Information stream. RuntimeExceptions that occured when trying to read bogus data are now caught. Dictionary entries up to but not including the bogus one are preserved, the rest is ignored.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">38641 - Handle timezones better with cell.setCellValue(Calendar), so now 20:00-03:00, 20:00+00:00 and 20:00+03:00 will all be recorded as 20:00, and not 17:00 / 20:00 / 23:00 (pass a Date not a Calendar for old behaviour)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44373 - Have HSSFDateUtil.isADateFormat recognize more formats as being dates(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">37923 - Support for Excel hyperlinks(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Implement hashCode() and equals(obj) on HSSFFont and HSSFCellStyle(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44345 - Implement CountA, CountIf, Index, Rows and Columns functions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44336 - Properly escape sheet names as required when figuring out the text of formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44326 - Improvements to how SystemOutLogger and CommonsLogger log messages with exceptions, and avoid an infinite loop with certain log messages with exceptions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for a completed Record based "pull" stream, via org.apache.poi.hssf.eventusermodel.HSSFRecordStream, to complement the existing "push" Event User Model listener stuff(POI-DEVELOPERS)</li>
</ul>
<a name="3.0.2-FINAL"></a>
<div class="h3">
<h3>Version 3.0.2-FINAL (2008-02-04)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44297 - IntPtg must operate with unsigned short. Reading signed short results in incorrect formula calculation(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44296 - Fix for reading slide background images(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44293 - Avoid swapping AreaPtgs from relative to absolute(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44292 - Correctly process the last paragraph in a word file(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44254 - Avoid some unread byte warnings, and properly understand DVALRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add another formula evaluation method, evaluateFormulaCell(cell), which will re-calculate the value for a formula, without affecting the formula itself.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">41726 - Fix how we handle signed cell offsets in relative areas and references(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44233 - Support for getting and setting a flag on the sheet, which tells excel to re-calculate all formulas on it at next reload(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44201 - Enable cloning of sheets with data validation rules(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44200 - Enable cloning of sheets with notes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43008 - Add a moveCell method to HSSFRow, and deprecate setCellNum(), which didn't update things properly(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43058 - Support setting row grouping on files from CR IX, which lack GutsRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">31795 - Support cloning of sheets with certain drawing objects on them(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43902 - Don't consider merged regions when auto-sizing columns(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42464 - Avoid "Expected ExpPtg to be converted from Shared to Non-Shared Formula" on large, formula heavy worksheets(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">42033 - Add support for named ranges with unicode names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">34023 - When shifting rows, update formulas on that sheet to point to the new location of those rows(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support getting all the cells referenced by an AreaReference, not just the corner ones(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43510 - Add support for named ranges in formulas, including non-contiguous named ranges(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43937 - Add support for hiding and un-hiding sheets, and checking their current hidden status(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44167 - Fix for non-contiguous named ranges(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">44070 - Fix for shifting comments when shifting rows(POI-DEVELOPERS)</li>
</ul>
<a name="3.0.2-BETA2"></a>
<div class="h3">
<h3>Version 3.0.2-BETA2 (2008-01-12)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for tables in HSLF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43781 - Fix for extracting text from TextBoxes HSLF in(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improve JavaDocs relating to hssf font and fill colourings(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44095, 44097, 44099 - [PATCH] Support for Mid, Replace and Substitute excel functions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">44055 - [PATCH] Support for getting the from field from HSMF messages(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43551 - [PATCH] Support for 1904 date windowing in HSSF (previously only supported 1900 date windowing)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">41064 - [PATCH] Support for String continue records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">27511 - [PATCH] Support for data validation, via DVRecord and DVALRecord(POI-DEVELOPERS)</li>
</ul>
<a name="3.0.2-BETA1"></a>
<div class="h3">
<h3>Version 3.0.2-BETA1 (2007-12-04)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43877 - Fix for handling mixed OBJ and CONTINUE records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">39512 - Fix for handling mixed OBJ and CONTINUE records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43837 - [PATCH] Support for unicode NameRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43807 - Throw an IllegalArgumentException if asked to create a merged region with invalid columns or rows, rather than writing out a corrupt file(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43837 - [PATCH] Support for unicode NameRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43721 - [PATCH] Support for Chart Title Format records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42794 - [PATCH] Fix for BOF records from things like Access(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43648 - Fix for IntPtg and short vs int(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43751 - [PATCH] - Fix for handling rotated text in HSSFSheet.autoSizeColumn(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Include an Excel text extractor, and put all existing text extractors under a common superclass(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Improvements to the LZW compression engine used by HDGF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSSFPicture.resize() - a handy method to reset a picture to its original width and height(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add a getSheetIndex(HSSFSheet) method to HSSFWorkbook, and allow a HSSFSheet to get at its parent HSSFWorkbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Move POIDocument out of Scratchpad, and update HSSFWorkbook to use it(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43399 - [PATCH] - Fix for Cell References for rows > 32678(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43410 - [PATCH] - Improved Formula Parser support for numbers and ranges(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">When writing HSLF files out, optionally preserve all OLE2 nodes (default is just the HSLF related nodes)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43323 - [PATCH] - Support for adding Pictures to ShapeGroups in HSLF.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43222 - [PATCH] - Support for getting OLE object data from HSSFWorkbook.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43247 - [PATCH] - Support for getting OLE object data from slideshows.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">43125 - [PATCH] - Support for reading EMF, WMF and PICT images via HSSFWorkbook.getAllPictures()(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43088 - [PATCH] - Fix for reading files with long cell comments and text boxes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42844 - [PATCH] - Fix for the EventUserModel and records that aren't immediately followed by their ContinueRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43055 - [PATCH] - Fix for saving Crystal Reports xls files when preserving nodes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43116 - [PATCH] - Fix for Escher layer handling of embeded OLE2 documents(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43108 - [PATCH] - Where permissions deny fetching System Properties, use sensible defaults(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">43093 - [PATCH] - Fix formula evaluator support for Area3D references to other sheets(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Improvements to HSSFDateUtils.isADateFormat, and have HSSFDateUtil.isCellDateFormatted use this(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42999 - [PATCH] - Fix for HSSFPatriarch positioning problems(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for write-protecting a HSSF workbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for querying, setting and un-setting protection on sheets in a HSSF workbook(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial HSMF (outlook) support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Tidy up the javadocs(POI-DEVELOPERS)</li>
</ul>
<a name="3.0.1-FINAL"></a>
<div class="h3">
<h3>Version 3.0.1-FINAL (2007-07-05)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Administrative updates to the Maven POMs, and the release artificat build process(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">23951 - [PATCH] Fix for HSSF setSheetOrder and tab names(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42524 - [PATCH] Better HSLF support for problem shape groups(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42520 - [PATCH] Better HSLF support for corrupt picture records(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for a "missing record aware" HSSF event model(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Additional HSLF support for Title and Slide Master Sheets(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42474 - [PATCH] Improved HSLF note to slide matching, and a NPE(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42481 - [PATCH] Tweak some HSLF exceptions, to make it clearer what you're catching(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">42667 - [PATCH] Fix for HSLF writing of files with tables(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Improved way of detecting HSSF cells that contain dates, isADateFormat(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial, read-only support for Visio documents, as HDGF(POI-DEVELOPERS)</li>
</ul>
<a name="3.0-FINAL"></a>
<div class="h3">
<h3>Version 3.0-FINAL (2007-05-18)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">39977 - [PATCH] Fix POM for Maven users(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">38976 - [PATCH] Add createPicture to HSSFShapeGroup(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Detect Office 2007 XML documents, and throw a meaningful exception(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Additional HSLF support for PowerPoint(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial support for HWPF image extraction(POI-DEVELOPERS)</li>
</ul>
<a name="3.0-alpha3"></a>
<div class="h3">
<h3>Version 3.0-alpha3 (2006-12-12)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Additional HSLF support for PowerPoint(POI-DEVELOPERS)</li>
</ul>
<a name="3.0-alpha2"></a>
<div class="h3">
<h3>Version 3.0-alpha2 (2006-06-16)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSSF Formula support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Additional HSLF support for PowerPoint(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">39389 - [PATCH] Extended Ascii support for WingDings(POI-DEVELOPERS)</li>
</ul>
<a name="3.0-alpha1"></a>
<div class="h3">
<h3>Version 3.0-alpha1 (2005-06-04)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Bugzilla Bug 29976 [PATCH] HSSF hyperlink formula size problem(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Image writing support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">HSLF - Initial PowerPoint Support. Includes: Support for text extraction across the whole file; Support for getting individual slides, and their notes, and extracting text from those; Initial support for changing (but not adding) text(NB)</li>
</ul>
<a name="2.5.1-FINAL"></a>
<div class="h3">
<h3>Version 2.5.1-FINAL (2004-02-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Outlining support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">27574 - [PATCH] HSSFDateUtil.getExcelDate() is one hour off when DST changes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">26465 - [PATCH] wrong lastrow entry(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">28203 - [PATCH] Unable to open read-write excel file including forms(POI-DEVELOPERS)</li>
</ul>
<a name="2.5-FINAL"></a>
<div class="h3">
<h3>Version 2.5-FINAL (2004-02-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Add support for the Escher file format(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">27005 java.lang.IndexOutOfBoundsException during Workbook.cloneSheet()(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-FINAL"></a>
<div class="h3">
<h3>Version 2.0-FINAL (2004-01-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">No changes(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-RC2"></a>
<div class="h3">
<h3>Version 2.0-RC2 (2004-01-11)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Bug 25695 - HSSFCell.getStringCellValue() on cell which has string formula will return swap bye unicode characters.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Updated website for upcoming release(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Formula Parser fixes with tests, by Peter M Murray Bug 25457(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed cloning merge regions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">The cloned reference for merged cells did not create a new collection, so deletes cascaded to the original.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix to 24519 call to getCustomPalette() from a newly created workbook now works(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fix supplied for bug 24397 where some compilation got ambiguous classes. Explicitly imports the classes. Patch supplied by Jean-Pierre Paris.(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-RC1"></a>
<div class="h3">
<h3>Version 2.0-RC1 (2003-11-02)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">12561 (Min) HSSFWorkbook throws Exceptions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">12730 (Nor) values dont get copied to another sheet.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">13224 (Maj) Exception thrown when cell has =Names call(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">13796 (Nor) Error Reading Formula Record (optimized if, external link)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">13921 (Nor) Sheet name cannot exceed 31 characters and cannot contain :(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">14330 (Nor) Error reading FormulaRecord(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">14460 (Nor) Name in Formula - ArrayOutOfBoundsException(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">15228 (Cri) [Urgent] ArrayIndexoutofbounds Exception. POI - Version 1.8(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">16488 (Maj) Unable to open written spreadsheet in Excel, but can in Open(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">16559 (Nor) testCustomPalette.xls crashes Excel 97(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">16560 (Nor) testBoolErr.xls crashes Excel '97(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">17374 (Min) HSSFFont - BOLDWEIGHT_NORMAL(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">18800 (Maj) The sheet made by HSSFWorkbook#cloneSheet() doesn't work cor(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">18846 (Min) [PATCH][RFE]Refactor the transformation between byte array a(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">19599 (Min) java.lang.IllegalArgumentException(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">19961 (Nor) [PATCH] Sheet.getColumnWidth() returns wrong value(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21066 (Blo) Can not modify a blank spreadsheet(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21444 (Enh) [PATCH] Macro functions(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21447 (Nor) [RFE]String Formula Cells(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21674 (Enh) [PATCH] Documentation changes for @(Greater|Less|Not)EqualPt(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21863 (Enh) [PATCH] build.xml fixes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">22195 (Nor) [RFE] [PATCH] Support for Storage Class ID(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">22742 (Cri) Failed to create HSSFWorkbook!(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">22922 (Cri) HSSFSheet.shiftRows() throws java.lang.IndexOutOfBoundsExcep(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">22963 (Nor) org.apache.poi.hpsf.SummaryInformation.getEditTime() should(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">24149 (Maj) Error passing inputstream to POIFSFileSystem(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">21722 (Nor) [PATCH] Add a ProtectRecord to Sheets and give control over(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">9576 (Nor) [PATCH] DBCELL, INDEX EXTSST (was Acess 97 import)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">13478 (Blo) [PATCH] [RFE] POIFS, RawDataBlock: Missing workaround for lo(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">14824 (Nor) Unable to modify empty sheets(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">12843 (Cri) [PATCH] Make POI handle chinese better(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">15353 (Nor) [RFE] creating a cell with a hyperlink(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">15375 (Blo) Post 1.5.1 POI causes spreadsheet to become unopenable.(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-pre3"></a>
<div class="h3">
<h3>Version 2.0-pre3 (2003-07-29)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">HPSF is now able to read properties which are given in the property set stream but which don't have a value ("variant" type VT_EMPTY). The getXXX() methods of the PropertySet class return null if their return type is a reference (like a string) or 0 if the return type is numeric. Details about the return types and about how to distinguish between a property value of zero and a property value that is not present can be found in the API documentation.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Gridlines can now be turned on and off(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">NamePTG refactoring/fixes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">minor fixes to ExternSheet and formula strings(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Sheet comparisons now ignore case(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-pre2"></a>
<div class="h3">
<h3>Version 2.0-pre2 (2003-07-06)</h3>
</div>
<ul>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">A nasty concurrency problem has been fixed. Any users working in a multithreaded environment should seriously consider upgrading to this release.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">The EXTSST record has been implemented. This record is used by excel for optimized reading of strings.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">When rows are shifted, the merged regions now move with them. If a row contains 2 merged cells, the resulting shifted row should have those cells merged as well.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">There were some issues when removing merged
regions (specifically, removing all of them and then adding some more) and have been resolved.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">When a sheet contained shared formulas (when a formula is
dragged across greater than 6 cells), the clone would fail. We now support cloning of
sheets that contain this Excel optimization. (POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support added for reading formulas with UnaryPlus and UnaryMinus operators.(POI-DEVELOPERS)</li>
</ul>
<a name="2.0-pre1"></a>
<div class="h3">
<h3>Version 2.0-pre1 (2003-05-17)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Patch applied for deep cloning of worksheets was provided(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Patch applied to allow sheet reordering(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Added additional print area setting methods using row/column numbers(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">HDF: Negative Array size fix(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added argument pointers to support the IF formula(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Formulas: Added special character support for string literals, specifically for SUMIF formula support and addresses a bug as well(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">BlockingInputStream committed to help ensure reads(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed problem with NaN values differing from the investigated value from file reads in FormulaRecords(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Patch for getColumnWidth in HSSF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Patch for dealing with mult-level numbered lists in HDF(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Due to named reference work, several named-ranged bugs were closed(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Patch applied to prevent sheet corruption after a template modification(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Shared Formulas now Supported(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added GreaterEqual, LessEqual and NotEqual to Formula Parser(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added GreaterThan and LessThan functionality to formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Patches for i10n(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">POI Build System Updated(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">font names can now be null(POI-DEVELOPERS)</li>
</ul>
<a name="1.10-dev"></a>
<div class="h3">
<h3>Version 1.10-dev (2003-02-19)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for zoom level(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Freeze and split pane support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Row and column headers on printouts(POI-DEVELOPERS)</li>
</ul>
<a name="1.8-dev"></a>
<div class="h3">
<h3>Version 1.8-dev (2002-09-20)</h3>
</div>
<ul>
<li>
<img class="icon" alt="add" src="images/add.jpg">Custom Data Format Support(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Enhanced Unicode Support for Russian and Japanese(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Enhanced formula support including read-only for
"optimized if" statements.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for cloning objects(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Fixes for header/footer(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Spanish Documentation translations(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Support for preserving VBA macros(POI-DEVELOPERS)</li>
</ul>
<a name="1.7-dev"></a>
<div class="h3">
<h3>Version 1.7-dev (Release date not recorded)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Removed runtime dependency on commons logging.(NKB)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Formula support(POI-DEVELOPERS)</li>
</ul>
<a name="1.5.1"></a>
<div class="h3">
<h3>Version 1.5.1 (2002-06-16)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Removed depedency on commons logging. Now define poi.logging system property to enable logging to standard out.(GJS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Fixed SST string handling so that spreadsheets with rich text or extended text will be read correctly.(GJS)</li>
</ul>
<a name="1.5"></a>
<div class="h3">
<h3>Version 1.5 (2002-05-06)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">New project build.(NKB)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">New project documentation system based on Cocoon.(NKB)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Package rename(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="fix" src="images/fix.jpg">Various bug fixes(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Early stages of HSF development (not ready for development)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="add" src="images/add.jpg">Initial low level record support for charting (not complete)(POI-DEVELOPERS)</li>
</ul>
<a name="1.2.0"></a>
<div class="h3">
<h3>Version 1.2.0 (2002-01-19)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="1.1.0"></a>
<div class="h3">
<h3>Version 1.1.0 (2002-01-04)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Created new event model(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Optimizations made to HSSF including aggregate records for
values, rows, etc.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">predictive sizing, offset based writing (instead of lots of
array copies)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">minor re-factoring and bug fixes.(POI-DEVELOPERS)</li>
</ul>
<a name="1.0.2"></a>
<div class="h3">
<h3>Version 1.0.2 (2002-01-11)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="1.0.1"></a>
<div class="h3">
<h3>Version 1.0.1 (2002-01-04)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="1.0.0"></a>
<div class="h3">
<h3>Version 1.0.0 (2001-12-30)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Minor documentation updates.(POI-DEVELOPERS)</li>
</ul>
<a name="0.14.0"></a>
<div class="h3">
<h3>Version 0.14.0 (2001-12-22)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added DataFormat helper class and exposed set and get format
on HSSFCellStyle(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Fixed column width apis (unit wise) and various javadoc on
the subject(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Fix for Dimensions record (again)... (one of these days I'll
write a unit test for this ;-p).(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Some optimization on sheet creation.(POI-DEVELOPERS)</li>
</ul>
<a name="0.13.0"></a>
<div class="h3">
<h3>Version 0.13.0 (2001-12-16)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="0.12.0"></a>
<div class="h3">
<h3>Version 0.12.0 (2001-12-12)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added MulBlank, Blank, ColInfo(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added log4j facility and removed all sys.out type logging(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added support for adding font's, styles and corresponding
high level api for styling cells(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">added support for changing row height, cell width and default
row height/cell width.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added fixes for internationalization (UTF-16 should work now
from HSSFCell.setStringValue, etc when the encoding is set)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">added support for adding/removing and naming sheets.(POI-DEVELOPERS)</li>
</ul>
<a name="0.11.0"></a>
<div class="h3">
<h3>Version 0.11.0 (2001-12-08)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Bugfix release. We were throwing an exception when reading
RKRecord objects.(POI-DEVELOPERS)</li>
</ul>
<a name="0.10.0"></a>
<div class="h3">
<h3>Version 0.10.0 (2001-12-02)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Got continuation records to work (read/write)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added various pre-support for formulas(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Massive API reorganization, repackaging.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">BiffViewer class added for validating HSSF & POI and/or
HSSF Output.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Better API support for modification.(POI-DEVELOPERS)</li>
</ul>
<a name="0.7 (and interim releases)"></a>
<div class="h3">
<h3>Version 0.7 (and interim releases) (2001-11-17)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Added encoding flag to high and low level api to use utf-16
when needed (HSSFCell.setEncoding())(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">added read only support for Label records (which are
reinterpreted as LabelSST when written)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Broken continuation record implementation (oops)(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">BiffViewer class added for validating HSSF & POI and/or
HSSF Output.(POI-DEVELOPERS)</li>
</ul>
<a name="0.6"></a>
<div class="h3">
<h3>Version 0.6 (2001-11-11)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Support for read/write and modify.(POI-DEVELOPERS)</li>
<li>
<img class="icon" alt="update" src="images/update.jpg">Read only support for MulRK records (converted to Number when
writing)
(POI-DEVELOPERS)</li>
</ul>
<a name="0.5"></a>
<div class="h3">
<h3>Version 0.5 (2001-11-05)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="0.4"></a>
<div class="h3">
<h3>Version 0.4 (2001-10-31)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="0.3"></a>
<div class="h3">
<h3>Version 0.3 (2001-10-26)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="0.2"></a>
<div class="h3">
<h3>Version 0.2 (2001-09-24)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<a name="0.1"></a>
<div class="h3">
<h3>Version 0.1 (2001-08-28)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">First ever public release(POI-DEVELOPERS)</li>
</ul>
</div>
</div>
</div>
</td>
<!--================= end Content ==================-->
</tr>
</tbody>
</table>
<!--================= end Main ==================-->
<!--================= start Footer ==================-->
<div id="footer">
<table summary="footer" cellspacing="0" cellpadding="4" width="100%" border="0">
<tbody>
<tr>
<!--================= start Copyright ==================-->
<td colspan="2">
<div align="center">
<div class="copyright">
Copyright © 2002-2012 The Apache Software Foundation. All rights reserved.<br>
Apache POI, POI, Apache, the Apache feather logo, and the Apache
POI project logo are trademarks of The Apache Software Foundation.
</div>
</div>
</td>
<!--================= end Copyright ==================-->
</tr>
<tr>
<td align="left">
<!--================= start Host ==================-->
<!--================= end Host ==================--></td><td align="right">
<!--================= start Credits ==================-->
<div align="right">
<div class="credit"></div>
</div>
<!--================= end Credits ==================-->
</td>
</tr>
</tbody>
</table>
</div>
<!--================= end Footer ==================-->
</body>
</html>
