HSSFWorkbook电子表格操作组件

1.2.5 (April,2012) In this release, we fixed most of the bugs found in POI 3.8 beta 4. POI Bug Fixes 51535 - correct signed vs unsigned short reading in NDocumentInputStream(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) 50401 - fixed EscherProperty to return property name instead of 'unknown' for complex properties (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) 46250 - Fixed cloning worksheets with images(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) 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) 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) 50681 - Avoid exceptions in HSSFDataFormat.getDataFormatString() (poi-developers) 50681 - Fixed autosizing columns beyond 255 character limit (poi-developers) 51339 - Fixed arithmetic rounding in formula evaluation (poi-developers) 51098 - Correctly calculate image width/height, if image fits into one cell(poi-developers) 51273 - Formula Value Cache fix for repeated evaluations(poi-developers) 51171 - Improved performance of SharedValueManager (poi-developers) 51171 - Improved performance of opening large .xls files(poi-developers) NPOIFS Mini Streams now support extending the underlying big block stream to fit more data(poi-developers) 51153 - Correct sizing of LbsDataSubRecord with unused padding fields(poi-developers) 51143 - NameCommentRecord correction for writing non ASCII strings(poi-developers) 51115 - Handle DataFormatter escaping of "." in the same way as "-" and "/"(poi-developers) 51100 - Fix IOUtils issue for NPOIFS reading from an InputStream where every block is full(poi-developers) Tweak the logic for sizing the HSSFCells array on a HSSFRow to reduce memory over allocation in many use cases(poi-developers) Fixed NPOIFS handling of new and empty Document Nodes(poi-developers) Fixed NPOIFS access to Document Nodes not in the top level directory(poi-developers) 50841 - Improved SpreadSheet DataFormatter to handle scientific notation, invalid dates and format spacers(poi-developers) 50939 - ChartEndObjectRecord is supposed to have 6 bytes at the end, but handle it not(poi-developers) 50912 - fixed setting named styles to HSSFCells(poi-developers) 50779 - fixed RecordFormatException when reading unicode strings with photenic data(poi-developers) 50718 - More helpful error message when you try to create a CellReference with #REF!(poi-developers) 50786 - Speed up calls to HSSFColor.getIndexHash() by returning a cached, unmodifiable Map. HSSFColor.getModifiableIndexHash() provides access to the old (slow but modifiable) functionality(poi-developers) 32903 - Correct XBAT chaining explanation in /poifs/fileformat.html(poi-developers) 46664 - When creating HSSF Print Areas, ensure the named range is reference based not value based(poi-developers) 50756 - When formatting numbers based on their Cell Style, treat GENERAL the same as the more typical General(poi-developers) fixed HSSFWorkbook.createCellStyle to throw exception if the maximum number of cell styles was exceeded(poi-developers) 49928 - allow overridden built-in formats in HSSFCellStyle(poi-developers) 50587 - Improved documentation on user-defined functions(poi-developers) 50416 - Correct shifting of the first or last row in a sheet by multiple rows(POI-DEVELOPERS) 50246 - Properly position GutsRecord when reading HSSF workbooks(POI-DEVELOPERS) 50437 - Support passing ranges to NPV()(POI-DEVELOPERS) 47405 - Improved performance of RowRecordsAggregate.getStartRowNumberForBlock / getEndRowNumberForBlock(poi-developers) 50113 - Remove cell from Calculation Chain after setting cell type to blank (poi-developers) 50096 - Fixed evaluation of cell references with column index greater than 255 (poi-developers) 49761 - Tolerate Double.NaN when reading .xls files(poi-developers) 50211 - Use cached formula result when auto-sizing formula cells(poi-developers) 50118 - OLE2 does allow a directory with an empty name, so support this in POIFS(poi-developers) Support for appending images to existing drawings in HSSF(poi-developers) NPOI Bug fixes a. CloneSheet with images throws exception b. Comments are still visible even set Visible property to false c. AutoSizeColumn doesn't work as expected d. Reading sheet protected workbook throws exception New Features a. Added NPOIFS constructors to most POIDocument classes and their extractors, and more widely deprecated the Document(DirectoryNode, POIFSFileSystem) constructor in favour of the more general Document(DirectoryNode) one b. Added implementation for CLEAN(), CHAR(), ADDRESS(),MROUND(), VAR(), VARP(), IRR() c. Added Support for HOUR, MINUTE and SECOND date formulas d. Support for continued NameRecords, continued ExtSSTRecords e. Support using RecalcIdRecord to trigger a full formula recalculation on load (poi-developers) f. ExternalNameRecord support for DDE Link entries without an operation(poi-developers) g. POIFS Browser: add ability to parse EscherContainer and sub nodes 1.2.4 (Nov,2011) In this release, we fixed most of the bugs found in POI 3.6 and POI 3.7. NPOI Bug Fixes 5157 - HSSFSheet.FitToPage property is added. It doesn't work previously. 7271 - Cell formula that has been "dragged" down cannot be read. Patch is applied xxx - Bad padding calculation 3804 - NPOI doesn't work with a Excel template with macro POI Bug Fixes 46547 - ClassCastException in HSSFSheet.shiftRows(...) 47363 - Fixed HSSFSheet to allow addition of data validations after sheet protection 45066 - sheet encoding size mismatch problems 49026 - added implementation for text() (poi-developers) 46654 - HSSFRow/RowRecord to properly update cell boundary indexes(POI-DEVELOPERS) 46385 - (also patch 46362) fix serialization of StyleRecord with unicode name(POI-DEVELOPERS) 47069 - Fixed HSSFSheet#getFirstRowNum and HSSFSheet#getLastRowNum to return correct values after removal of all rows(POI-DEVELOPERS) 48325 - bad text 'Page &P of &N' and similar errors when reading in spreadsheets 48485 - add extra paper size constans to printsetup, such as a3, b4 and b5(poi-developers) 48425 - improved performance of dateutil.iscelldateformatted() (poi-developers) 49524 - add vertical text orientation method 47001 - Fixed WriteAccessRecord and LinkTable to handle unusual format written by Google Docs(POI-DEVELOPERS) 46368 - Fix HSSFRichTextRun and strings longer than 32768 characters(POI-DEVELOPERS) 48292 - Support of array formulas 49820 - ParagraphProperties.getLvl() returns 0 for both Level 1 and Body text - fixed HSSFWorkbook.createCellStyle to throw exception if the maximum number of cell styles was exceeded(poi-developers) 47405 - Improved performance of RowRecordsAggregate.getStartRowNumberForBlock / getEndRowNumberForBlock(poi-developers) 46250 - Workbook