<!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 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 align="right">
<div 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> | <a title="PDF file of this page" href="changes.pdf">PDF</a>
</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">Apache POI</span>
<div class="menuItem">
<a href="index.html">TOP</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Marketing</span>
<div class="menuItem">
<a href="casestudies.html">Case Studies</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Project</span>
<div class="menuItem">
<a href="overview.html">Overview</a>
</div>
<div class="menuItem">
<a href="poifs/index.html">POIFS</a>
</div>
<div class="menuItem">
<a href="hssf/index.html">HSSF</a>
</div>
<div class="menuItem">
<a href="hwpf/index.html">HWPF</a>
</div>
<div class="menuItem">
<a href="hpsf/index.html">HPSF</a>
</div>
<div class="menuItem">
<a href="hslf/index.html">HSLF</a>
</div>
<div class="menuItem">
<a href="hsmf/index.html">HSMF</a>
</div>
<div class="menuItem">
<a href="hdgf/index.html">HDGF</a>
</div>
<div class="menuItem">
<a href="poi-ruby.html">POI-Ruby</a>
</div>
<div class="menuItem">
<a href="utils/index.html">POI-Utils</a>
</div>
<div class="menuItem">
<a href="text-extraction.html">Text Extraction</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/dyn/closer.cgi/poi/">Download</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Community</span>
<div class="menuItem">
<a href="news.html">News</a>
</div>
<div class="menuItem">
<a href="mirrors.html">Mirrors</a>
</div>
<div class="menuItem">
<span class="menuSelected">Changes</span>
</div>
<div class="menuItem">
<a href="todo.html">To Do</a>
</div>
<div class="menuItem">
<a href="getinvolved/index.html">Get Involved</a>
</div>
<div class="menuItem">
<a href="mailinglists.html">Mailing Lists</a>
</div>
<div class="menuItem">
<a href="plan/POI20Vision.html">Vision</a>
</div>
<div class="menuItem">
<a href="historyandfuture.html">History and Future</a>
</div>
<div class="menuItem">
<a href="who.html">Who We Are</a>
</div>
<div class="menuItem">
<a href="resolutions/index.html">Resolutions</a>
</div>
<div class="menuItem">
<a href="http://www.apache.org/foundation/thanks.html">Sponsors</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Docs</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="legal.html">Legal</a>
</div>
<div class="menuItem">
<a href="references/index.html">References</a>
</div>
<div class="menuItem">
<a href="howtobuild.html">How to Build</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Translations</span>
<div class="menuItem">
<a href="trans/index.html">Index</a>
</div>
<div class="menuItem">
<a href="trans/guidelines.html">Guidelines</a>
</div>
<div class="menuItem">
<a href="trans/de/index.html">German (DE)</a>
</div>
<div class="menuItem">
<a href="trans/es/index.html">Spanish (ES)</a>
</div>
<div class="menuItem">
<a href="http://jakarta.terra-intl.com/poi/">Japanese (Web)</a>
</div>
<div class="menuItem">
<a href="http://jakarta.apache-korea.org/poi/">Korean (Web)</a>
</div>
</div>
<div class="menu">
<span class="menuLabel">Code</span>
<div class="menuItem">
<a href="subversion.html">Subversion (current source code)</a>
</div>
<div class="menuItem">
<a href="http://issues.apache.org/bugzilla/buglist.cgi?votes=1&product=POI&order=bugs.votes">Top Voted Bugs</a>
</div>
<div class="menuItem">
<a href="http://issues.apache.org/bugzilla/buglist.cgi?product=POI">Bug Database</a>
</div>
<div class="menuItem">
<a href="http://issues.apache.org/bugzilla/buglist.cgi?product=POI&short_desc=%5BPATCH%5D&short_desc_type=allwordssubstr">Patches</a>
</div>
<div class="menuItem">
<a href="junit/index.html">Junit Test Results</a>
</div>
<div class="menuItem">
<a href="jdepend/index.html">Dependency Metrics</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"><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">
<br>
Search poi</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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<div class="h3">
<h3>Version (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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<div class="h3">
<h3>Version 1.1.0 (Release date not recorded)</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>
<div class="h3">
<h3>Version 1.0.0 (Release date not recorded)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Minor documentation updates.(POI-DEVELOPERS)</li>
</ul>
<div class="h3">
<h3>Version 0.14.0 (Release date not recorded)</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>
<div class="h3">
<h3>Version 0.13.0 (Release date not recorded)</h3>
</div>
<ul>
<li>
<img class="icon" alt="update" src="images/update.jpg">Changes not recorded.(POI-DEVELOPERS)</li>
</ul>
<div class="h3">
<h3>Version 0.12.0 (Release date not recorded)</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>
<div class="h3">
<h3>Version 0.11.0 (Release date not recorded)</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>
<div class="h3">
<h3>Version 0.10.0 (Release date not recorded)</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>
<div class="h3">
<h3>Version 0.7 (and interim releases) (Release date not recorded)</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>
<div class="h3">
<h3>Version 0.6 (release) (Release date not recorded)</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>
</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-2007 The Apache Software Foundation. All rights reserved.
</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>
distrib
>
Mandriva
>
2010.0
>
i586
>
media
>
contrib-release
>
by-pkgid
>
0a38b107381e947533adbb55ab5f647c
>
files
>
7
