Jakarta POI

the jakarta site
 
   

History of Changes

PDF
PDF

RSS

Version 2.5.1-FINAL (29 Feburary 2004)

  • addOutlining support(POI-DEVELOPERS)
  • fix27574 - [PATCH] HSSFDateUtil.getExcelDate() is one hour off when DST changes(POI-DEVELOPERS)
  • fix26465 - [PATCH] wrong lastrow entry(POI-DEVELOPERS)
  • fix28203 - [PATCH] Unable to open read-write excel file including forms(POI-DEVELOPERS)

Version 2.5-FINAL (29 Feburary 2004)

  • addAdd support for the Escher file format(POI-DEVELOPERS)
  • fix27005 java.lang.IndexOutOfBoundsException during Workbook.cloneSheet()(POI-DEVELOPERS)

Version 2.0-FINAL (26 Janurary 2004)

  • updateNo changes(POI-DEVELOPERS)

Version 2.0-RC2 (11 Janurary 2004)

  • fixBug 25695 - HSSFCell.getStringCellValue() on cell which has string formula will return swap bye unicode characters.(POI-DEVELOPERS)
  • fixUpdated website for upcoming release(POI-DEVELOPERS)
  • fixFormula Parser fixes with tests, by Peter M Murray Bug 25457(POI-DEVELOPERS)
  • fixFixed cloning merge regions(POI-DEVELOPERS)
  • fixThe cloned reference for merged cells did not create a new collection, so deletes cascaded to the original.(POI-DEVELOPERS)
  • fixFix to 24519 call to getCustomPalette() from a newly created workbook now works(POI-DEVELOPERS)
  • fixFix supplied for bug 24397 where some compilation got ambiguous classes. Explicitly imports the classes. Patch supplied by Jean-Pierre Paris.(POI-DEVELOPERS)

Version (2 November 2003)

  • fix12561 (Min) HSSFWorkbook throws Exceptions(POI-DEVELOPERS)
  • fix12730 (Nor) values dont get copied to another sheet.(POI-DEVELOPERS)
  • fix13224 (Maj) Exception thrown when cell has =Names call(POI-DEVELOPERS)
  • fix13796 (Nor) Error Reading Formula Record (optimized if, external link)(POI-DEVELOPERS)
  • fix13921 (Nor) Sheet name cannot exceed 31 characters and cannot contain :(POI-DEVELOPERS)
  • fix14330 (Nor) Error reading FormulaRecord(POI-DEVELOPERS)
  • fix14460 (Nor) Name in Formula - ArrayOutOfBoundsException(POI-DEVELOPERS)
  • fix15228 (Cri) [Urgent] ArrayIndexoutofbounds Exception. POI - Version 1.8(POI-DEVELOPERS)
  • fix16488 (Maj) Unable to open written spreadsheet in Excel, but can in Open(POI-DEVELOPERS)
  • fix16559 (Nor) testCustomPalette.xls crashes Excel 97(POI-DEVELOPERS)
  • fix16560 (Nor) testBoolErr.xls crashes Excel '97(POI-DEVELOPERS)
  • fix17374 (Min) HSSFFont - BOLDWEIGHT_NORMAL(POI-DEVELOPERS)
  • fix18800 (Maj) The sheet made by HSSFWorkbook#cloneSheet() doesn't work cor(POI-DEVELOPERS)
  • fix18846 (Min) [PATCH][RFE]Refactor the transformation between byte array a(POI-DEVELOPERS)
  • fix19599 (Min) java.lang.IllegalArgumentException(POI-DEVELOPERS)
  • fix19961 (Nor) [PATCH] Sheet.getColumnWidth() returns wrong value(POI-DEVELOPERS)
  • fix21066 (Blo) Can not modify a blank spreadsheet(POI-DEVELOPERS)
  • fix21444 (Enh) [PATCH] Macro functions(POI-DEVELOPERS)
  • fix21447 (Nor) [RFE]String Formula Cells(POI-DEVELOPERS)
  • fix21674 (Enh) [PATCH] Documentation changes for @(Greater|Less|Not)EqualPt(POI-DEVELOPERS)
  • fix21863 (Enh) [PATCH] build.xml fixes(POI-DEVELOPERS)
  • fix22195 (Nor) [RFE] [PATCH] Support for Storage Class ID(POI-DEVELOPERS)
  • fix22742 (Cri) Failed to create HSSFWorkbook!(POI-DEVELOPERS)
  • fix22922 (Cri) HSSFSheet.shiftRows() throws java.lang.IndexOutOfBoundsExcep(POI-DEVELOPERS)
  • fix22963 (Nor) org.apache.poi.hpsf.SummaryInformation.getEditTime() should(POI-DEVELOPERS)
  • fix24149 (Maj) Error passing inputstream to POIFSFileSystem(POI-DEVELOPERS)
  • fix21722 (Nor) [PATCH] Add a ProtectRecord to Sheets and give control over(POI-DEVELOPERS)
  • fix9576 (Nor) [PATCH] DBCELL, INDEX EXTSST (was Acess 97 import)(POI-DEVELOPERS)
  • fix13478 (Blo) [PATCH] [RFE] POIFS, RawDataBlock: Missing workaround for lo(POI-DEVELOPERS)
  • fix14824 (Nor) Unable to modify empty sheets(POI-DEVELOPERS)
  • fix12843 (Cri) [PATCH] Make POI handle chinese better(POI-DEVELOPERS)
  • fix15353 (Nor) [RFE] creating a cell with a hyperlink(POI-DEVELOPERS)
  • fix15375 (Blo) Post 1.5.1 POI causes spreadsheet to become unopenable.(POI-DEVELOPERS)

Version 2.0-pre3 (29 July 2003)

  • addHPSF 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)
  • fixGridlines can now be turned on and off(POI-DEVELOPERS)
  • fixNamePTG refactoring/fixes(POI-DEVELOPERS)
  • fixminor fixes to ExternSheet and formula strings(POI-DEVELOPERS)
  • fixSheet comparisons now ignore case(POI-DEVELOPERS)

Version 2.0-pre2 (6 July 2003)

  • fixA nasty concurrency problem has been fixed. Any users working in a multithreaded environment should seriously consider upgrading to this release.(POI-DEVELOPERS)
  • updateThe EXTSST record has been implemented. This record is used by excel for optimized reading of strings.(POI-DEVELOPERS)
  • updateWhen 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)
  • fixThere were some issues when removing merged regions (specifically, removing all of them and then adding some more) and have been resolved.(POI-DEVELOPERS)
  • fixWhen 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)
  • addSupport added for reading formulas with UnaryPlus and UnaryMinus operators.(POI-DEVELOPERS)

Version 2.0-pre1 (17 May 2003)

  • addPatch applied for deep cloning of worksheets was provided(POI-DEVELOPERS)
  • addPatch applied to allow sheet reordering(POI-DEVELOPERS)
  • addAdded additional print area setting methods using row/column numbers(POI-DEVELOPERS)
  • fixHDF: Negative Array size fix(POI-DEVELOPERS)
  • updateAdded argument pointers to support the IF formula(POI-DEVELOPERS)
  • updateFormulas: Added special character support for string literals, specifically for SUMIF formula support and addresses a bug as well(POI-DEVELOPERS)
  • fixBlockingInputStream committed to help ensure reads(POI-DEVELOPERS)
  • fixFixed problem with NaN values differing from the investigated value from file reads in FormulaRecords(POI-DEVELOPERS)
  • fixPatch for getColumnWidth in HSSF(POI-DEVELOPERS)
  • addPatch for dealing with mult-level numbered lists in HDF(POI-DEVELOPERS)
  • fixDue to named reference work, several named-ranged bugs were closed(POI-DEVELOPERS)
  • fixPatch applied to prevent sheet corruption after a template modification(POI-DEVELOPERS)
  • updateShared Formulas now Supported(POI-DEVELOPERS)
  • updateAdded GreaterEqual, LessEqual and NotEqual to Formula Parser(POI-DEVELOPERS)
  • updateAdded GreaterThan and LessThan functionality to formulas(POI-DEVELOPERS)
  • fixPatches for i10n(POI-DEVELOPERS)
  • updatePOI Build System Updated(POI-DEVELOPERS)
  • fixfont names can now be null(POI-DEVELOPERS)

Version 1.10-dev (19 Feb 2003)

  • addSupport for zoom level(POI-DEVELOPERS)
  • addFreeze and split pane support(POI-DEVELOPERS)
  • addRow and column headers on printouts(POI-DEVELOPERS)

Version 1.8-dev (20 Sep 2002)

  • addCustom Data Format Support(POI-DEVELOPERS)
  • addEnhanced Unicode Support for Russian and Japanese(POI-DEVELOPERS)
  • addEnhanced formula support including read-only for "optimized if" statements.(POI-DEVELOPERS)
  • addSupport for cloning objects(POI-DEVELOPERS)
  • addFixes for header/footer(POI-DEVELOPERS)
  • addSpanish Documentation translations(POI-DEVELOPERS)
  • addSupport for preserving VBA macros(POI-DEVELOPERS)

Version 1.7-dev (???)

  • updateRemoved runtime dependency on commons logging.(NKB)
  • updateFormula support(POI-DEVELOPERS)

Version 1.5.1 (16 June 2002)

  • updateRemoved depedency on commons logging. Now define poi.logging system property to enable logging to standard out.(GJS)
  • fixFixed SST string handling so that spreadsheets with rich text or extended text will be read correctly.(GJS)

Version 1.5 (06 May 2002)

  • updateNew project build.(NKB)
  • updateNew project documentation system based on Cocoon.(NKB)
  • updatePackage rename(POI-DEVELOPERS)
  • fixVarious bug fixes(POI-DEVELOPERS)
  • addEarly stages of HSF development (not ready for development)(POI-DEVELOPERS)
  • addInitial low level record support for charting (not complete)(POI-DEVELOPERS)

Version 1.1.0 (Release date not recorded)

  • updateCreated new event model(POI-DEVELOPERS)
  • updateOptimizations made to HSSF including aggregate records for values, rows, etc.(POI-DEVELOPERS)
  • updatepredictive sizing, offset based writing (instead of lots of array copies)(POI-DEVELOPERS)
  • updateminor re-factoring and bug fixes.(POI-DEVELOPERS)

Version 1.0.0 (Release date not recorded)

  • updateMinor documentation updates.(POI-DEVELOPERS)

Version 0.14.0 (Release date not recorded)

  • updateAdded DataFormat helper class and exposed set and get format on HSSFCellStyle(POI-DEVELOPERS)
  • updateFixed column width apis (unit wise) and various javadoc on the subject(POI-DEVELOPERS)
  • updateFix for Dimensions record (again)... (one of these days I'll write a unit test for this ;-p).(POI-DEVELOPERS)
  • updateSome optimization on sheet creation.(POI-DEVELOPERS)

Version 0.13.0 (Release date not recorded)

  • updateChanges not recorded.(POI-DEVELOPERS)

Version 0.12.0 (Release date not recorded)

  • updateAdded MulBlank, Blank, ColInfo(POI-DEVELOPERS)
  • updateAdded log4j facility and removed all sys.out type logging(POI-DEVELOPERS)
  • updateAdded support for adding font's, styles and corresponding high level api for styling cells(POI-DEVELOPERS)
  • updateadded support for changing row height, cell width and default row height/cell width.(POI-DEVELOPERS)
  • updateAdded fixes for internationalization (UTF-16 should work now from HSSFCell.setStringValue, etc when the encoding is set)(POI-DEVELOPERS)
  • updateadded support for adding/removing and naming sheets.(POI-DEVELOPERS)

Version 0.11.0 (Release date not recorded)

  • updateBugfix release. We were throwing an exception when reading RKRecord objects.(POI-DEVELOPERS)

Version 0.10.0 (Release date not recorded)

  • updateGot continuation records to work (read/write)(POI-DEVELOPERS)
  • updateAdded various pre-support for formulas(POI-DEVELOPERS)
  • updateMassive API reorganization, repackaging.(POI-DEVELOPERS)
  • updateBiffViewer class added for validating HSSF & POI and/or HSSF Output.(POI-DEVELOPERS)
  • updateBetter API support for modification.(POI-DEVELOPERS)

Version 0.7 (and interim releases) (Release date not recorded)

  • updateAdded encoding flag to high and low level api to use utf-16 when needed (HSSFCell.setEncoding())(POI-DEVELOPERS)
  • updateadded read only support for Label records (which are reinterpreted as LabelSST when written)(POI-DEVELOPERS)
  • updateBroken continuation record implementation (oops)(POI-DEVELOPERS)
  • updateBiffViewer class added for validating HSSF & POI and/or HSSF Output.(POI-DEVELOPERS)

Version 0.6 (release) (Release date not recorded)

  • updateSupport for read/write and modify.(POI-DEVELOPERS)
  • updateRead only support for MulRK records (converted to Number when writing) (POI-DEVELOPERS)