Search poi

History of Changes

RSS

Version 3.1-final (2008-06-29)

  • fix30978 - Fixed re-serialization of tRefErr3d and tAreaErr3d(POI-DEVELOPERS)
  • fix45234 - Removed incorrect shared formula conversion in CFRuleRecord(POI-DEVELOPERS)
  • fix45001 - Improved HWPF Range.replaceText()(POI-DEVELOPERS)
  • fix44692 - Fixed HSSFPicture.resize() to properly resize pictures if the underlying columns/rows have modified size(POI-DEVELOPERS)
  • addSupport custom image renderers in HSLF(POI-DEVELOPERS)
  • fixCorrectly increment the reference count of a blip when a picture is inserted(POI-DEVELOPERS)
  • fix45110 - Fixed TextShape.resizeToFitText() to properly resize TextShape(POI-DEVELOPERS)
  • fix45091 - Fixed serialization of RefN~ tokens. Simplified Ptg class hierarchy(POI-DEVELOPERS)
  • fix45133 - Fixed OBJ Record (5Dh) to pad the sub-record data to a 4-byte boundary(POI-DEVELOPERS)
  • fix45145 - Fixed Sheet to always enforce RowRecordsAggregate before ValueRecordsAggregate(POI-DEVELOPERS)
  • fix45123 - Fixed SharedFormulaRecord.convertSharedFormulas() to propagate token operand classes(POI-DEVELOPERS)
  • fix45087 - Correctly detect date formats like [Black]YYYY as being date based(POI-DEVELOPERS)
  • add45060 - Improved token class transformation during formula parsing(POI-DEVELOPERS)
  • add44840 - Improved handling of HSSFObjectData, especially for entries with data held not in POIFS(POI-DEVELOPERS)
  • add45043 - Support for getting excel cell comments when extracting text(POI-DEVELOPERS)
  • addExtend 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)
  • fix45025 - improved FormulaParser parse error messages(POI-DEVELOPERS)
  • fix45046 - allowed EXTERNALBOOK(0x01AE) to be optional in the LinkTable(POI-DEVELOPERS)
  • fix45066 - fixed sheet encoding size mismatch problems(POI-DEVELOPERS)
  • add45003 - Support embeded HDGF visio documents(POI-DEVELOPERS)
  • fix45001 - Partial fix for HWPF Range.insertBefore() and Range.delete() with unicode characters(POI-DEVELOPERS)
  • fix44977 - Support for AM/PM in excel date formats(POI-DEVELOPERS)
  • addSupport for specifying a policy to HSSF on missing / blank cells when fetching(POI-DEVELOPERS)
  • add44937 - Partial support for extracting Escher images from HWPF files(POI-DEVELOPERS)
  • fix44824 - Avoid an infinite loop when reading some HWPF pictures(POI-DEVELOPERS)
  • fix44898 - Correctly handle short last blocks in POIFS(POI-DEVELOPERS)

Version 3.1-beta2 (2008-05-26)

  • fix44306 - fixed reading/writing of AttrPtg(type=choose) and method toFormulaString() for CHOOSE formulas(POI-DEVELOPERS)
  • fix24207 - added HSSFName.isDeleted() to check if the name points to cell that no longer exists(POI-DEVELOPERS)
  • fix40414 - fixed selected/active sheet after removing sheet from workbook(POI-DEVELOPERS)
  • fix44523 - fixed workbook sheet selection and focus(POI-DEVELOPERS)
  • fix45000 - Fixed NPE in ListLevel when numberText is null(POI-DEVELOPERS)
  • fix44985 - Properly update TextSpecInfoAtom when the parent text is changed(POI-DEVELOPERS)
  • fix41187 - fixed HSSFSheet to properly read xls files without ROW records(POI-DEVELOPERS)
  • fix44950 - fixed HSSFFormulaEvaluator.evaluateInCell() and Area3DEval.getValue() also added validation for number of elements in AreaEvals(POI-DEVELOPERS)
  • fix42570 - fixed LabelRecord to use empty string instead of null when the length is zero.(POI-DEVELOPERS)
  • fix42564 - fixed ArrayPtg to use ConstantValueParser. Fixed a few other ArrayPtg encoding issues.(POI-DEVELOPERS)
  • fixFollow-on from 28754 - StringPtg.toFormulaString() should escape double quotes(POI-DEVELOPERS)
  • fix44929 - Improved error handling in HSSFWorkbook when attempting to read a BIFF5 file(POI-DEVELOPERS)
  • fix44675 - Parameter operand classes (function metadata) required to encode SUM() etc properly. Added parse validation for number of parameters(POI-DEVELOPERS)
  • fix44921 - allow Ptg.writeBytes() to be called on relative ref Ptgs (RefN* and AreaN*)(POI-DEVELOPERS)
  • fix44914 - Fix/suppress warning message "WARN. Unread n bytes of record 0xNN"(POI-DEVELOPERS)
  • fix44892 - made HSSFWorkbook.getSheet(String) case insensitive(POI-DEVELOPERS)
  • fix44886] - Correctly process PICT metafile in EscherMetafileBlip(POI-DEVELOPERS)
  • fix44893 - Take into account indentation in HSSFSheet.autoSizeColumn(POI-DEVELOPERS)

Version 3.1-beta1 (2008-04-28)

  • fix44857 - Avoid OOM on unknown escher records when EscherMetafileBlip is incorrect(POI-DEVELOPERS)
  • addHSLF: Support for getting embedded sounds from slide show (POI-DEVELOPERS)
  • addHSLF: Initial support for rendering slides into images(POI-DEVELOPERS)
  • addHSLF: Support for getting OLE object data from slide show (POI-DEVELOPERS)
  • addHSLF: Implemented more methods in PPGraphics2D(POI-DEVELOPERS)
  • addHSLF: Added Freeform shape which can contain both lines and Bezier curves(POI-DEVELOPERS)
  • fix41071 - Improved text extraction in HSLF(POI-DEVELOPERS)
  • add30311 - Conditional Formatting - improved API, added HSSFSheetConditionalFormatting(POI-DEVELOPERS)
  • fixUpdate 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)
  • fixFix the logger used by POIFSFileSystem, so that commons-logging isn't required when not used(POI-DEVELOPERS)
  • addUpdate HSLFSlideShow and HSSFWorkbook to take advantage of POIFS updates, and allow reading embeded documents(POI-DEVELOPERS)
  • addImprove how POIFS works with directory entries, and update HWPFDocument to support reading an embeded word document(POI-DEVELOPERS)
  • addInitial support for getting and changing chart and series titles(POI-DEVELOPERS)
  • addImplement 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)
  • fix44792 - fixed encode/decode problems in ExternalNameRecord and CRNRecord.(POI-DEVELOPERS)
  • fix43670, 44501 - Fix how HDGF deals with trailing data in the list of chunk headers(POI-DEVELOPERS)
  • add30311 - More work on Conditional Formatting(POI-DEVELOPERS)
  • fixrefactored all junits' usage of HSSF.testdata.path to one place(POI-DEVELOPERS)
  • fix44739 - Small fixes for conditional formatting (regions with max row/col index)(POI-DEVELOPERS)
  • add44694 - HPSF: Support for property sets without sections(RK)
  • addImplement Sheet.removeShape(Shape shape) in HSLF(POI-DEVELOPERS)
  • addVarious fixes: Recognising var-arg built-in functions #44675, ExternalNameRecord serialisation bug #44695, PMT() bug #44691(POI-DEVELOPERS)
  • add30311 - More work on Conditional Formatting(POI-DEVELOPERS)
  • addMove the Formula Evaluator code out of scratchpad(POI-DEVELOPERS)
  • addMove the missing record aware eventusermodel code out of scratchpad(POI-DEVELOPERS)
  • add44652 / 44603 - Improved handling of Pictures in Word Documents(POI-DEVELOPERS)
  • fix44636 - Fix formula parsing of RefVPtg, which was causing #VALUE to be shown on subsequent edits(POI-DEVELOPERS)
  • fix44627 - Improve the thread safety of POILogFactory(POI-DEVELOPERS)
  • add30311 - Initial support for Conditional Formatting(POI-DEVELOPERS)
  • fix44609 - Handle leading spaces in formulas, such as '= 4'(POI-DEVELOPERS)
  • add44608 - Support for PercentPtg in the formula evaluator(POI-DEVELOPERS)
  • fix44606 - Support calculated string values for evaluated formulas(POI-DEVELOPERS)
  • addAdd accessors to horizontal and vertical alignment in HSSFTextbox(POI-DEVELOPERS)
  • add44593 - Improved handling of short DVRecords(POI-DEVELOPERS)
  • add28627 / 44580 - Fix Range.delete() in HWPF(POI-DEVELOPERS)
  • add44539 - Support for area references in formulas of rows >= 32768(POI-DEVELOPERS)
  • add44536 - Improved support for detecting read-only recommended files(POI-DEVELOPERS)
  • fix43901 - Correctly update the internal last cell number when adding and removing cells (previously sometimes off-by-one)(POI-DEVELOPERS)
  • fix44504 - Added initial support for recognising external functions like YEARFRAC and ISEVEN (using NameXPtg), via LinkTable support(POI-DEVELOPERS)
  • fix44504 - 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)
  • fix44504 - Fixed number conversion inconsistencies in many functions, and improved RefEval(POI-DEVELOPERS)
  • fix44504 - Added initial support for recognising external functions like YEARFRAC and ISEVEN (using NameXPtg), via LinkTable support(POI-DEVELOPERS)
  • fix44504 - 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)
  • fix44504 - Fixed number conversion inconsistencies in many functions, and improved RefEval(POI-DEVELOPERS)
  • fix44508 - Fix formula evaluation with evaluateInCell on boolean formulas(POI-DEVELOPERS)
  • fix44510 - Fix how DVALRecord works with dropdowns(POI-DEVELOPERS)
  • fix44495 - Handle named cell ranges in formulas that have lower case parts(POI-DEVELOPERS)
  • fix44491 - Don't have the new-style "HPSF properties are always available" affect the old-style use of HPSF alongside HSSF(POI-DEVELOPERS)
  • fix44471 - Crystal Reports generates files with short StyleRecords, which isn't allowed in the spec. Work around this(POI-DEVELOPERS)
  • fix44495 - Handle named cell ranges in formulas that have lower case parts(POI-DEVELOPERS)
  • fix44491 - Don't have the new-style "HPSF properties are always available" affect the old-style use of HPSF alongside HSSF(POI-DEVELOPERS)
  • fix44471 - Crystal Reports generates files with short StyleRecords, which isn't allowed in the spec. Work around this(POI-DEVELOPERS)
  • add44450 - Support for Lookup, HLookup and VLookup functions(POI-DEVELOPERS)
  • fix44449 - Avoid getting confused when two sheets have shared formulas for the same areas, and when the shared formula is set incorrectly(POI-DEVELOPERS)
  • fix44366 - 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)
  • add44371 - Support for the Offset function(POI-DEVELOPERS)
  • fix38921 - Have HSSFPalette.findSimilar() work properly(POI-DEVELOPERS)
  • fix44456 - Fix the contrib SViewer / SViewerPanel to not fail on sheets with missing rows(POI-DEVELOPERS)
  • fix44403 - Further support for unusual, but valid, arguments to the Mid function(POI-DEVELOPERS)
  • fix44410 - Support for whole-column ranges, such as C:C, in formula strings and the formula evaluator(POI-DEVELOPERS)
  • fix44421 - Update Match function to properly support Area references(POI-DEVELOPERS)
  • fix44417 - 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)
  • fix44413 - Fix for circular references in INDEX, OFFSET, VLOOKUP formulas, where a cell is actually allowed to reference itself(POI-DEVELOPERS)
  • fix44403 - Fix for Mid function handling its arguments wrong(POI-DEVELOPERS)
  • add44364 - Support for Match, NA and SumProduct functions, as well as initial function error support(POI-DEVELOPERS)
  • fix44375 - 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)
  • fix38641 - 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)
  • fix44373 - Have HSSFDateUtil.isADateFormat recognize more formats as being dates(POI-DEVELOPERS)
  • add37923 - Support for Excel hyperlinks(POI-DEVELOPERS)
  • addImplement hashCode() and equals(obj) on HSSFFont and HSSFCellStyle(POI-DEVELOPERS)
  • fix44345 - Implement CountA, CountIf, Index, Rows and Columns functions(POI-DEVELOPERS)
  • fix44336 - Properly escape sheet names as required when figuring out the text of formulas(POI-DEVELOPERS)
  • add44326 - Improvements to how SystemOutLogger and CommonsLogger log messages with exceptions, and avoid an infinite loop with certain log messages with exceptions(POI-DEVELOPERS)
  • addSupport 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)

Version 3.0.2-FINAL (2008-02-04)

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