Apache POI 3.8 Beta 5 / 3.7 - Changelog

What's new in Apache POI 3.8 Beta 4:

August 30th, 2011

· 51678 - Extracting text from Bug51524.zip is slow(poi-developers)
· 51671 - HWPFDocument.write based on NPOIFSFileSystem throws a NullPointerException(poi-developers)
· support for tables and hyperlinks in XSLF(poi-developers)
· 51535 - correct signed vs unsigned short reading in NDocumentInputStream(poi-developers)
· 51634 - support SXSSF streaming from templates(poi-developers)
· initial support for XSLF usermodel API(poi-developers)
· 51187 - fixed OPCPackage to correctly handle self references(poi-developers)
· 51635 - Improved performance of XSSFSheet#write(poi-developers)
· 47731 - Word Extractor considers text copied from some website as an embedded object(poi-developers)
· Add Word-to-Text converter and use it as replacement for WordExtractor(poi-developers)
· 51604 - replace text fails for doc ( poi 3.8 beta release from download site )(poi-developers)
· Fixed incorrect encoding of non-breaking space (0xA0) in SXSSF(poi-developers)
· Support for conditional formatting in XSSF(poi-developers)
· Support isRightToLeft and setRightToLeft on the common spreadsheet Sheet interface, as per existing HSSF support(poi-developers)
· 50209 - Fixed evaluation of Subtotals to ignore nested subtotals(poi-developers)
· 44431 - HWPFDocument.write destroys fields(poi-developers)
· 50401 - fixed EscherProperty to return property name instead of 'unknown' for complex properties (poi-developers)
· Initial support for endnotes and footnotes in HWPF(poi-developers)
· 51470 - avoid exception when cloning XSSF sheets with background images(poi-developers)
· 51481 - Fixed autofilters in HSSF to avoid warnings in Excel 2007(poi-developers)
· 51533 - Avoid exception when changing name of a sheet containing shared formulas(poi-developers)
· Support for appending images to existing drawings in HSSF(poi-developers)
· Initial support for bookmarks in HWPF(poi-developers)
· 46250 - Fixed cloning worksheets with images(poi-developers)
· 51524 - PapBinTable constructor is slow (regression)(poi-developers)
· 51514 - allow HSSFObjectData to work with both POIFS and NPOIFS(poi-developers)
· 51514 - avoid NPE when copying nodes from one HSSF workbook to a new one, when opened from NPOIFS(poi-developers)
· 51504 - avoid NPE when DefaultRowHeight or DefaultColumnWidth records are missing(poi-developers)
· 51502 - Correct Subtotal function javadoc entry(poi-developers)
· Support for hyperlinks in SXSSF(poi-developers)
· 49933 - Word 6/95 documents with sections cause ArrayIndexOutOfBoundsException(poi-developers)
· 51469 - XSSF support for row styles, to match existing HSSF functionality(poi-developers)
· 51476 - Correct XSSF cell formatting in HTML export(poi-developers)
· 51486 - XWPF support for adding new footnotes(poi-developers)
· 48065 - Problems with save output of HWPF (losing formatting)(poi-developers)
· 47563 - Exception when working with table(poi-developers)
· 47287 - StringIndexOutOfBoundsException in CharacterRun.replaceText()(poi-developers)
· 46817 - Regression: Text from some table cells missing(poi-developers)
· Add getOverallRange() method to HWPFDocumentCore(poi-developers)
· PAPX referenced outside of TextPiecesTable are ignored now and not loaded(poi-developers)
· Fix main part range (and section) detection for files with additional parts (like footers/headers).(poi-developers)
· Fix wrong TextPiece parsing in very rare cases like Bug33519.doc(poi-developers)
· Inner tables are correctly supported(poi-developers)
· Allow user to retrieve Table nesting level (based on file information)(poi-developers)
· Functionality of internal tool HWPFLister is greatly improved, including output of document PAPX and paragraphs(poi-developers)
· Expand Word structures definitions (TAP, PAP, TLP, etc) based on official documentation(poi-developers)
· Add Excel-to-HTML converter (2007 versions)(poi-developers)
· Add Word-to-HTML converter (95-2007 versions)(poi-developers)
· Skip wrong-type SPRMs when characters SPRM is expected(poi-developers)
· Add toStrings() methods to internal HWPF structures: BorderCode, PAPX, Paragraph, PieceDescriptor, Section, SEPX, SprmOperation, TextPiece etc.(poi-developers)
· 51474 - SXSSF handling for null strings(poi-developers)
· 48294 - Fixed HSSFWorkbook.setSheetOrder() to respect inter-sheet references (poi-developers)
· 51448 - Avoid exception when evaluating workbooks with more than 256 sheets (poi-developers)
· 51458 - Correct BitField wrapping when setting large values(poi-developers)
· 51460 - Improve HSSF performance when loading very long rows, by switching the CellValue array to an iterator(poi-developers)
· 51444 - Prevent corrupted output when saving files created by LibreOffice 3.3 (poi-developers)
· 51422 - Support using RecalcIdRecord to trigger a full formula recalculation on load (poi-developers)
· 50474 - Example demonstrating how to update Excel workbook embedded in a WordprocessingML document (poi-developers)
· 51431 - Avoid IndexOutOfBoundException when removing freeze panes in XSSF (poi-developers)
· 48877 - Fixed XSSFRichTextString to respect leading and trailing line breaks (poi-developers)
· 49564 - Fixed default behaviour of XSSFCellStyle.getLocked() (poi-developers)
· 48314 - Fixed setting column and row breaks in XSSF(poi-developers)
· 51424 - Ignore exceptions in ParagraphSprmUncompressor(poi-developers)
· 51415 - Fixed Workbook.createSheet(sheetName) to truncate names longer than 31 characters(poi-developers)
· 51332 - Fixed internal IDs of shapes generated by HSSFPatriarch when there are more than 1023 drawing objects (poi-developers)
· 48408 - Improved documentation for Sheet.setColumnWidth (poi-developers)
· 51390 - Added handling of additional properties to HWPF ParagraphSprmCompressor(poi-developers)
· 51389 - Support for sprmPJc paragraph SPRM in HWPF(poi-developers)
· 48469 - New Case Study for POI web site (poi-developers)
· 50681 - Avoid exceptions in HSSFDataFormat.getDataFormatString() (poi-developers)
· 50681 - Fixed autosizing columns beyond 255 character limit (poi-developers)
· 51374 - Fixed incorrect setting of lastPrinted OOXML core property (poi-developers)
· 51351 - Word to XSL-FO converter(poi-developers)
· 50458 - Fixed missing shapeId in XSSF drawings (poi-developers)
· 51339 - Fixed arithmetic rounding in formula evaluation (poi-developers)
· 51356 - Support autoSizeColumn in SXSSF(poi-developers)
· 51335 - Parse picture goal and crop sizes in HWPF(poi-developers)
· 51305 - Add sprmTCellPaddingDefault support in HWPF(poi-developers)
· 51265 - Enhanced Handling of Picture Parts in XWPF(poi-developers)
· 51292 - Additional HWPF Table Cell Descriptor values(poi-developers)

What's new in Apache POI 3.7:

August 30th, 2011

OOXML:
· support for reading aes-encrypted/write-protected ooxml files
· support Java 1.5 in auto-generated xmlbeans for ooxml schemas

Spreadsheet (Excel):
· initial support for autofilters
· support for data validation for ooxml format
· initial support for themes for ooxml format
· added implementation for new functions: RANDBETWEEN, POISSON, SUBTOTAL, TEXT, TRUNC
· support evaluation of indirect defined names in INDIRECT
· numerous fixes and performance optimizations in the Formula Evaluation module
· ability to add, modify and remove series from HSSF Charts
· numerous improvements in the cell data formatter (handling more formatting rules, better color detection, allow overriding of default locale)
· more examples including a rich "spreadsheet to HTML" converter

Document (Word):
· initial support for the HWPF revision marks authors list
· support for border codes in HWPF
· support for processing of symbols in HWPF
· support sections in Word 6 and Word 95 files
· improved reading of auto-saved ("complex") documents in HWPF
· improved support for manipulation of tables and paragraphs in XWPF

SlideShow (PowerPoint):
· allow editing workbooks embedded into HSLF slide shows

Text Extraction:
· support for text extraction from XSLF tables
· add PublisherTextExtractor support to extractorfactory
· support attachments as embedded documents within the new OutlookTextExtactor
· new event based XSSF text extractor (XSSFEventBasedExcelExtractor)
· make it easier to tell which content types each POIXMLTextExtractor handles
· paragraph level as well as whole-file text extraction for word 6/95 files

What's new in Apache POI 3.5 Beta 5:

May 18th, 2009

· 47089 - Fixed XSSFWorkbook.createSheet to properly increment sheetId(POI-DEVELOPERS)
· 46568 - Fixed XSLFPowerPointExtractor to properly process line breaks(POI-DEVELOPERS)
· 39056 - Fixed POIFSFileSystem to set CLSID of root when constructing instances from InputStream(POI-DEVELOPERS)
· 47054 - Fixed cloneStyleFrom to avoid exception when cloning styles of the same family(POI-DEVELOPERS)
· 46186 - Fixed Sheet to read GutsRecord in the Sheet(RecordStream rs)(POI-DEVELOPERS)
· 46714 - Automatically call sheet.setAlternativeExpression when sheet.setRowSumsBelow is called (POI-DEVELOPERS)
· 46279 - Allow 255 arguments for excel functions in XSSF (POI-DEVELOPERS)
· 47028 - Fixed XSSFCell to preserve cell style when cell value is set to blank(POI-DEVELOPERS)
· 47026 - Avoid NPE in XSSFCell.setCellType() when workbook does not have SST(POI-DEVELOPERS)
· 46987 - Allow RecordFactory to handle non-zero padding at the end of the workbook stream(POI-DEVELOPERS)
· 47034 - Fix reading the name of a NameRecord when the name is very long(POI-DEVELOPERS)
· 47001 - Fixed WriteAccessRecord and LinkTable to handle unusual format written by Google Docs(POI-DEVELOPERS)
· 46973 - Fixed defined names to behave better when refersToFormula is unset(POI-DEVELOPERS)
· 46832 - Allow merged regions with columns greater than 255 or rows bigger than 65536 in XSSF(POI-DEVELOPERS)
· 46951 - Fixed formula parser to better handle range operators and whole row/column refs.(POI-DEVELOPERS)
· 46948 - Fixed evaluation of range operator to allow for area-ref operands(POI-DEVELOPERS)
· 46918 - Fixed ExtendedPivotTableViewFieldsRecord(SXVDEX) to allow shorter format(POI-DEVELOPERS)
· 46898 - Fixed formula evaluator to not cache intermediate circular-reference error results(POI-DEVELOPERS)
· 46917 - Fixed PageItemRecord(SXPI) to allow multiple field infos(POI-DEVELOPERS)
· 46904 - Fix POIFS issue with duplicate block 0 references on very old BIFF5/BIFF7 files(POI-DEVELOPERS)
· 46840 - PageSettingsBlock should include HEADERFOOTER record(POI-DEVELOPERS)
· 46885 - update cell type when setting cached formula result in XSSFCell(POI-DEVELOPERS)
· added modifiers for anchor type to XSSFClientAnchor(POI-DEVELOPERS)
· 46772 - support built-in data formats in XSSFDataFormat(POI-DEVELOPERS)
· 46719 - fixed XSSFSheet.shiftRows to correctly preserve row heights(POI-DEVELOPERS)
· 46715 - preserve custom column widths across re-serialization of XSSFWorkbook(POI-DEVELOPERS)
· 46703 - added setDisplayZeros / isDisplayZeros to common interface org.apache.poi.ss.usermodel.Sheet(POI-DEVELOPERS)
· 46708 - added getMergedRegion(int) to common interface org.apache.poi.ss.usermodel.Sheet(POI-DEVELOPERS)
· fixed Sheet.autoSizeColumn() to use cached formula values when processing formula cells (POI-DEVELOPERS)
· Fixed formula parser to handle names with backslashes(POI-DEVELOPERS)
· 46660 - added Workbook getHidden() and setHidden(boolean)(POI-DEVELOPERS)
· 46693 - Fixed bugs serialization bugs in records: CHARTFORMAT, SHTPROPS, SXVD and SXVDEX(POI-DEVELOPERS)
· 46627 - Fixed offset of added images if Pictures stream contains pictures with zero length(POI-DEVELOPERS)

What's new in Apache POI 3.5 Beta 4:

December 3rd, 2008

· Fixed FormulaRecordAggregate to gracefully ignore extra StringRecords(POI-DEVELOPERS)