Apache Software Foundation > Apache POI

- Home
- Help
- Component APIs
- Getting Involved

# 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)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | No changes

## 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)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## 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)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 1.0.1 (2002-01-04)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 1.0.0 (2001-12-30)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Minor documentation updates

## 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)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## 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)

## Version 0.5 (2001-11-05)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 0.4 (2001-10-31)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 0.3 (2001-10-26)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 0.2 (2001-09-24)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | Changes not recorded

## Version 0.1 (2001-08-28)

### Changes

Type | Bug | Module | Description
--- | --- | --- | ---
|  | POI_Overall | First ever public release