Search poi

History of Changes

RSS

Version 3.0.2-FINAL (2008-??-??)

  • fix44297 - IntPtg must operate with unsigned short. Reading signed short results in incorrect formula calculation(POI-DEVELOPERS)
  • fix44296 - Fix for reading slide background images(POI-DEVELOPERS)
  • fix44293 - Avoid swapping AreaPtgs from relative to absolute(POI-DEVELOPERS)
  • fix44292 - Correctly process the last paragraph in a word file(POI-DEVELOPERS)
  • fix44254 - Avoid some unread byte warnings, and properly understand DVALRecord(POI-DEVELOPERS)
  • addAdd another formula evaluation method, evaluateFormulaCell(cell), which will re-calculate the value for a formula, without affecting the formula itself.(POI-DEVELOPERS)
  • fix41726 - Fix how we handle signed cell offsets in relative areas and references(POI-DEVELOPERS)
  • add44233 - 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)
  • fix44201 - Enable cloning of sheets with data validation rules(POI-DEVELOPERS)
  • fix44200 - Enable cloning of sheets with notes(POI-DEVELOPERS)
  • add43008 - Add a moveCell method to HSSFRow, and deprecate setCellNum(), which didn't update things properly(POI-DEVELOPERS)
  • fix43058 - Support setting row grouping on files from CR IX, which lack GutsRecords(POI-DEVELOPERS)
  • fix31795 - Support cloning of sheets with certain drawing objects on them(POI-DEVELOPERS)
  • fix43902 - Don't consider merged regions when auto-sizing columns(POI-DEVELOPERS)
  • fix42464 - Avoid "Expected ExpPtg to be converted from Shared to Non-Shared Formula" on large, formula heavy worksheets(POI-DEVELOPERS)
  • add42033 - Add support for named ranges with unicode names(POI-DEVELOPERS)
  • add34023 - When shifting rows, update formulas on that sheet to point to the new location of those rows(POI-DEVELOPERS)
  • addSupport getting all the cells referenced by an AreaReference, not just the corner ones(POI-DEVELOPERS)
  • add43510 - Add support for named ranges in formulas, including non-contiguous named ranges(POI-DEVELOPERS)
  • add43937 - Add support for hiding and un-hiding sheets, and checking their current hidden status(POI-DEVELOPERS)
  • fix44167 - Fix for non-contiguous named ranges(POI-DEVELOPERS)
  • fix44070 - Fix for shifting comments when shifting rows(POI-DEVELOPERS)

Version 3.0.2-BETA2 (2008-01-12)

  • addSupport for tables in HSLF(POI-DEVELOPERS)
  • fix43781 - Fix for extracting text from TextBoxes HSLF in(POI-DEVELOPERS)
  • fixImprove JavaDocs relating to hssf font and fill colourings(POI-DEVELOPERS)
  • add44095, 44097, 44099 - [PATCH] Support for Mid, Replace and Substitute excel functions(POI-DEVELOPERS)
  • add44055 - [PATCH] Support for getting the from field from HSMF messages(POI-DEVELOPERS)
  • add43551 - [PATCH] Support for 1904 date windowing in HSSF (previously only supported 1900 date windowing)(POI-DEVELOPERS)
  • add41064 - [PATCH] Support for String continue records(POI-DEVELOPERS)
  • add27511 - [PATCH] Support for data validation, via DVRecord and DVALRecord(POI-DEVELOPERS)

Version 3.0.2-BETA1 (2007-12-04)

  • fix43877 - Fix for handling mixed OBJ and CONTINUE records(POI-DEVELOPERS)
  • fix39512 - Fix for handling mixed OBJ and CONTINUE records(POI-DEVELOPERS)
  • fix43837 - [PATCH] Support for unicode NameRecords(POI-DEVELOPERS)
  • fix43807 - Throw an IllegalArgumentException if asked to create a merged region with invalid columns or rows, rather than writing out a corrupt file(POI-DEVELOPERS)
  • fix43837 - [PATCH] Support for unicode NameRecords(POI-DEVELOPERS)
  • add43721 - [PATCH] Support for Chart Title Format records(POI-DEVELOPERS)
  • fix42794 - [PATCH] Fix for BOF records from things like Access(POI-DEVELOPERS)
  • fix43648 - Fix for IntPtg and short vs int(POI-DEVELOPERS)
  • fix43751 - [PATCH] - Fix for handling rotated text in HSSFSheet.autoSizeColumn(POI-DEVELOPERS)
  • addInclude an Excel text extractor, and put all existing text extractors under a common superclass(POI-DEVELOPERS)
  • addImprovements to the LZW compression engine used by HDGF(POI-DEVELOPERS)
  • addHSSFPicture.resize() - a handy method to reset a picture to its original width and height(POI-DEVELOPERS)
  • addAdd a getSheetIndex(HSSFSheet) method to HSSFWorkbook, and allow a HSSFSheet to get at its parent HSSFWorkbook(POI-DEVELOPERS)
  • addMove POIDocument out of Scratchpad, and update HSSFWorkbook to use it(POI-DEVELOPERS)
  • fix43399 - [PATCH] - Fix for Cell References for rows > 32678(POI-DEVELOPERS)
  • fix43410 - [PATCH] - Improved Formula Parser support for numbers and ranges(POI-DEVELOPERS)
  • addWhen writing HSLF files out, optionally preserve all OLE2 nodes (default is just the HSLF related nodes)(POI-DEVELOPERS)
  • add43323 - [PATCH] - Support for adding Pictures to ShapeGroups in HSLF.(POI-DEVELOPERS)
  • add43222 - [PATCH] - Support for getting OLE object data from HSSFWorkbook.(POI-DEVELOPERS)
  • add43247 - [PATCH] - Support for getting OLE object data from slideshows.(POI-DEVELOPERS)
  • add43125 - [PATCH] - Support for reading EMF, WMF and PICT images via HSSFWorkbook.getAllPictures()(POI-DEVELOPERS)
  • fix43088 - [PATCH] - Fix for reading files with long cell comments and text boxes(POI-DEVELOPERS)
  • fix42844 - [PATCH] - Fix for the EventUserModel and records that aren't immediately followed by their ContinueRecords(POI-DEVELOPERS)
  • fix43055 - [PATCH] - Fix for saving Crystal Reports xls files when preserving nodes(POI-DEVELOPERS)
  • fix43116 - [PATCH] - Fix for Escher layer handling of embeded OLE2 documents(POI-DEVELOPERS)
  • fix43108 - [PATCH] - Where permissions deny fetching System Properties, use sensible defaults(POI-DEVELOPERS)
  • fix43093 - [PATCH] - Fix formula evaluator support for Area3D references to other sheets(POI-DEVELOPERS)
  • fixImprovements to HSSFDateUtils.isADateFormat, and have HSSFDateUtil.isCellDateFormatted use this(POI-DEVELOPERS)
  • fix42999 - [PATCH] - Fix for HSSFPatriarch positioning problems(POI-DEVELOPERS)
  • addSupport for write-protecting a HSSF workbook(POI-DEVELOPERS)
  • addSupport for querying, setting and un-setting protection on sheets in a HSSF workbook(POI-DEVELOPERS)
  • addInitial HSMF (outlook) support(POI-DEVELOPERS)
  • fixTidy up the javadocs(POI-DEVELOPERS)

Version 3.0.1-FINAL (2007-07-05)

  • fixAdministrative updates to the Maven POMs, and the release artificat build process(POI-DEVELOPERS)
  • fix23951 - [PATCH] Fix for HSSF setSheetOrder and tab names(POI-DEVELOPERS)
  • fix42524 - [PATCH] Better HSLF support for problem shape groups(POI-DEVELOPERS)
  • fix42520 - [PATCH] Better HSLF support for corrupt picture records(POI-DEVELOPERS)
  • addInitial support for a "missing record aware" HSSF event model(POI-DEVELOPERS)
  • addAdditional HSLF support for Title and Slide Master Sheets(POI-DEVELOPERS)
  • fix42474 - [PATCH] Improved HSLF note to slide matching, and a NPE(POI-DEVELOPERS)
  • fix42481 - [PATCH] Tweak some HSLF exceptions, to make it clearer what you're catching(POI-DEVELOPERS)
  • fix42667 - [PATCH] Fix for HSLF writing of files with tables(POI-DEVELOPERS)
  • addImproved way of detecting HSSF cells that contain dates, isADateFormat(POI-DEVELOPERS)
  • addInitial, read-only support for Visio documents, as HDGF(POI-DEVELOPERS)

Version 3.0-FINAL (2007-05-18)

  • fix39977 - [PATCH] Fix POM for Maven users(POI-DEVELOPERS)
  • fix38976 - [PATCH] Add createPicture to HSSFShapeGroup(POI-DEVELOPERS)
  • addDetect Office 2007 XML documents, and throw a meaningful exception(POI-DEVELOPERS)
  • addAdditional HSLF support for PowerPoint(POI-DEVELOPERS)
  • addInitial support for HWPF image extraction(POI-DEVELOPERS)

Version 3.0-alpha3 (2006-12-12)

  • addAdditional HSLF support for PowerPoint(POI-DEVELOPERS)

Version 3.0-alpha2 (2006-06-16)

  • addHSSF Formula support(POI-DEVELOPERS)
  • addAdditional HSLF support for PowerPoint(POI-DEVELOPERS)
  • fix39389 - [PATCH] Extended Ascii support for WingDings(POI-DEVELOPERS)

Version 3.0-alpha1 (2005-06-04)

  • fixBugzilla Bug 29976 [PATCH] HSSF hyperlink formula size problem(POI-DEVELOPERS)
  • addImage writing support(POI-DEVELOPERS)
  • addHSLF - 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)

Version 2.5.1-FINAL (2004-02-29)

  • 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 (2004-02-29)

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

Version 2.0-FINAL (2004-01-26)

  • updateNo changes(POI-DEVELOPERS)

Version 2.0-RC2 (2004-01-11)

  • 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 (2003-11-02)

  • 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 (2003-07-29)

  • 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 (2003-07-06)

  • 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 (2003-05-17)

  • 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 (2003-02-19)

  • 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 (2002-09-20)

  • 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 (Release date not recorded)

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

Version 1.5.1 (2002-06-16)

  • 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 (2002-05-06)

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