History of Changes
Current releases
The change log for the current release can be found in the home section.
Version 2.5.1-FINAL (2004-02-29)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
 | HSSF | Outlining support | |
 | 27574 | HSSF | HSSFDateUtil.getExcelDate() is one hour off when DST changes |
| 26465 | HSSF | wrong lastrow entry |
| 28203 | HSSF | Unable to open read-write excel file including forms |
Version 2.5-FINAL (2004-02-29)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| DDF | Add support for the Escher file format | |
| 27005 | HSSF | java.lang.IndexOutOfBoundsException during Workbook.cloneSheet() |
Version 2.0-FINAL (2004-01-26)
Version 2.0-RC2 (2004-01-11)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| 25695 | HSSF | HSSFCell.getStringCellValue() on cell which has string formula will return swap bye unicode characters |
| POI_Overall | Updated website for upcoming release | |
| 25457 | HSSF | Formula Parser fixes with tests, by Peter M Murray Bug 25457 |
| HSSF | Fixed cloning merge regions | |
| HSSF | The cloned reference for merged cells did not create a new collection, so deletes cascaded to the original | |
| 24519 | HSSF | Call to getCustomPalette() from a newly created workbook now works |
| 24397 | POI_Overall | Some compilation got ambiguous classes. Explicitly imports the classes. Patch supplied by Jean-Pierre Paris |
Version 2.0-RC1 (2003-11-02)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| 12561 | HSSF | HSSFWorkbook throws Exceptions |
| 12730 | HSSF | values dont get copied to another sheet |
| 13224 | POI_Overall | Exception thrown when cell has =Names call |
| 13796 | HSSF | Error Reading Formula Record (optimized if, external link) |
| 13921 | HSSF | Sheet name cannot exceed 31 characters and cannot contain : |
| 14330 | HSSF | Error reading FormulaRecord |
| 14460 | HSSF | Name in Formula - ArrayOutOfBoundsException |
| 15228 | HSSF | ArrayIndexoutofbounds Exception. POI - Version 1.8 |
| 16488 | HSSF | Unable to open written spreadsheet in Excel, but can in Open |
| 16559 | HSSF | testCustomPalette.xls crashes Excel 97 |
| 16560 | HSSF | testBoolErr.xls crashes Excel '97 |
| 17374 | HSSF | HSSFFont - BOLDWEIGHT_NORMAL |
| 18800 | HSSF | The sheet made by HSSFWorkbook#cloneSheet() doesn't work cor |
| 18846 | POI_Overall | [RFE]Refactor the transformation between byte array a |
| 19599 | HSSF | java.lang.IllegalArgumentException |
| 19961 | HSSF | Sheet.getColumnWidth() returns wrong value |
| 21066 | HSSF | Can not modify a blank spreadsheet |
| 21444 | HSSF | Macro functions |
| 21447 | HSSF | [RFE]String Formula Cells |
| 21674 | HSSF | Documentation changes for @(Greater|Less|Not)EqualPt |
| 21863 | POI_Overall | build.xml fixes |
| 22195 | POIFS | [RFE] Support for Storage Class ID |
| 22742 | HSSF | Failed to create HSSFWorkbook! |
| 22922 | HSSF | HSSFSheet.shiftRows() throws java.lang.IndexOutOfBoundsExcep |
| 22963 | HPSF | org.apache.poi.hpsf.SummaryInformation.getEditTime() should |
| 24149 | POIFS | Error passing inputstream to POIFSFileSystem |
| 21722 | HSSF | Add a ProtectRecord to Sheets and give control over |
| 9576 | HSSF | DBCELL, INDEX EXTSST (was Acess 97 import) |
| 13478 | POIFS | [RFE] POIFS, RawDataBlock: Missing workaround for lo |
| 14824 | HSSF | Unable to modify empty sheets |
| 12843 | HSSF | Make POI handle chinese better |
| 15353 | HSSF | [RFE] creating a cell with a hyperlink |
| 15375 | HSSF | Post 1.5.1 POI causes spreadsheet to become unopenable |
Version 2.0-pre3 (2003-07-29)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HPSF | 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 | |
| HSSF | Gridlines can now be turned on and off | |
| HSSF | NamePTG refactoring/fixes | |
| HSSF | minor fixes to ExternSheet and formula strings | |
| HSSF | Sheet comparisons now ignore case |
Version 2.0-pre2 (2003-07-06)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | A nasty concurrency problem has been fixed. Any users working in a multithreaded environment should seriously consider upgrading to this release | |
 | HSSF | The EXTSST record has been implemented. This record is used by excel for optimized reading of strings | |
| HSSF | 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 | |
| HSSF | There were some issues when removing merged regions (specifically, removing all of them and then adding some more) and have been resolved. | |
| HSSF | 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. | |
| HSSF | Support added for reading formulas with UnaryPlus and UnaryMinus operators |
Version 2.0-pre1 (2003-05-17)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Patch applied for deep cloning of worksheets was provided | |
| HSSF | Patch applied to allow sheet reordering | |
| HSSF | Added additional print area setting methods using row/column numbers | |
| HDF | Negative Array size fix | |
| HSSF | Added argument pointers to support the IF formula | |
| HSSF | Formulas: Added special character support for string literals, specifically for SUMIF formula support and addresses a bug as well | |
| POIFS | BlockingInputStream committed to help ensure reads | |
| HSSF | Fixed problem with NaN values differing from the investigated value from file reads in FormulaRecords | |
| HSSF | Patch for getColumnWidth in HSSF | |
| HDF | Patch for dealing with mult-level numbered lists in HDF | |
| HSSF | Due to named reference work, several named-ranged bugs were closed | |
| HSSF | Patch applied to prevent sheet corruption after a template modification | |
| HSSF | Shared Formulas now Supported | |
| HSSF | Added GreaterEqual, LessEqual and NotEqual to Formula Parser | |
| HSSF | Added GreaterThan and LessThan functionality to formulas | |
| POI_Overall | Patches for i10n | |
| POI_Overall | POI Build System Updated | |
| HSSF | font names can now be null |
Version 1.10-dev (2003-02-19)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Support for zoom level | |
| HSSF | Freeze and split pane support | |
| HSSF | Row and column headers on printouts |
Version 1.8-dev (2002-09-20)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Custom Data Format Support | |
| HSSF | Enhanced Unicode Support for Russian and Japanese | |
| HSSF | Enhanced formula support including read-only for "optimized if" statements. | |
| HSSF | Support for cloning objects | |
| HSSF | Fixes for header/footer | |
| POI_Overall | Spanish Documentation translations | |
| HSSF | Support for preserving VBA macros |
Version 1.7-dev (Release date not recorded)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| POI_Overall | Removed runtime dependency on commons logging | |
| HSSF | Formula support |
Version 1.5.1 (2002-06-16)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| POI_Overall | Removed depedency on commons logging. Now define poi.logging system property to enable logging to standard out | |
| HSSF | Fixed SST string handling so that spreadsheets with rich text or extended text will be read correctly |
Version 1.5 (2002-05-06)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| POI_Overall | New project build | |
| POI_Overall | New project documentation system based on Cocoon | |
| POI_Overall | Package rename | |
| POI_Overall | Various bug fixes | |
| HSSF | Early stages of HSSF development (not ready for development) | |
| HSSF | Initial low level record support for charting (not complete) |
Version 1.2.0 (2002-01-19)
Version 1.1.0 (2002-01-04)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Created new event model | |
| HSSF | Optimizations made to HSSF including aggregate records for values, rows, etc. | |
| POI_Overall | predictive sizing, offset based writing (instead of lots of array copies) | |
| POI_Overall | minor re-factoring and bug fixes |
Version 1.0.2 (2002-01-11)
Version 1.0.1 (2002-01-04)
Version 1.0.0 (2001-12-30)
Version 0.14.0 (2001-12-22)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Added DataFormat helper class and exposed set and get format on HSSFCellStyle | |
| HSSF | Fixed column width apis (unit wise) and various javadoc on the subject | |
| HSSF | Fix for Dimensions record (again)... (one of these days I'll write a unit test for this ;-p). | |
| HSSF | Some optimization on sheet creation |
Version 0.13.0 (2001-12-16)
Version 0.12.0 (2001-12-12)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Added MulBlank, Blank, ColInfo | |
| POI_Overall | Added log4j facility and removed all sys.out type logging | |
| HSSF | Added support for adding font's, styles and corresponding high level api for styling cells | |
| HSSF | added support for changing row height, cell width and default row height/cell width. | |
| HSSF | Added fixes for internationalization (UTF-16 should work now from HSSFCell.setStringValue, etc when the encoding is set) | |
| HSSF | added support for adding/removing and naming sheets |
Version 0.11.0 (2001-12-08)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Bugfix release. We were throwing an exception when reading RKRecord objects. |
Version 0.10.0 (2001-12-02)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Got continuation records to work (read/write) | |
| HSSF | Added various pre-support for formulas | |
| POI_Overall | Massive API reorganization, repackaging | |
| POI_Overall | Better API support for modification |
Version 0.7 (and interim releases) (2001-11-17)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| HSSF | Added encoding flag to high and low level api to use utf-16 when needed (HSSFCell.setEncoding()) | |
| HSSF | added read only support for Label records (which are reinterpreted as LabelSST when written) | |
| HSSF | Broken continuation record implementation (oops) | |
| POIFS HSSF | BiffViewer class added for validating POI and/or HSSF Output. |
Version 0.6 (2001-11-11)
Changes
| Type | Bug | Module | Description |
|---|---|---|---|
| POIFS | Support for read/write and modify | |
| HSSF | Read only support for MulRK records (converted to Number when writing) |