NOPI所有dll文件

2.1 (Jun., 2014) New Features a. XSSFSheet.CopySheet b. Excel2Html for XSSF c. insert picture in word 2007 d. Implement IfError function in formula engine Bug Fixes a. fix conditional formatting issue b. fix ctFont order issue c. fix vertical alignment issue in XSSF d. add IndexedColors to NPOI.SS.UserModel e. fix decimal point issue in non-English culture f. fix SetMargin issue in XSSF g.fix multiple images insert issue in XSSF h.fix rich text style missing issue in XSSF i. fix cell comment shape (big arrow) in XSSF j. WorkbookFactory for Excel 2007 doesn't occupy file. k. fix XSSFCell.IsMergedCell l. fix incorrect page margin value due to different culture m. fix HSSFSheet.CopyTo doesn't copy rich text in cells New examples a. XSSF.DownloadXlsx b. XSSF.ConditionFormats c. XSSF.LineChart d. XWPF.InsertPicturesInWord 2.0 [v2.0.6] (Jan., 2014) a. fix a lot of xml serialization issue for OOXML (2.0.5 will corrupt some xlsx and docx files) b. implement XSSFCell.IsMergedCell c. IWorkbook implements IList<ISheet> 2.0 Beta 2 [v2.0.5] (Dec, 2013) New features a. Support Scatter chart in XSSF (xlsx) (other chart types are not supported yet) b. Extract pictures from Excel (xlsx) c. XWPF becomes stabler than before d. Able to support xml:space="preserve" attribute e. Add mono assembly in the release package f. file generated by NPOI will contain NPOI tags in custom properties to identify the generator g. Adjust some XWPF interfaces Sample changes a. add new samples like BigGridTest, WritePerformanceTest to test performance b. add ScatterChart to show how to create Scatter chart c. add LinkedDropDownList for both XSSF and HSSF d. add MonthlySalaryReport to show how to use formula in XSSF e. add CreateCustomProperties to show how to use custom props in XSSF and XWPF Bug fixes a. fix shift row issue in XSSFSheet b. fix performance issue due to XmlSerializer. NPOI is getting rid of XmlSerializer. c. reading/writing CT_Drawing d. fix ddd pattern issue in CellDateFormatter e. Change some common interfaces in NPOI.SS f. fix OutOfMemory issue in MemoryPackagePart g. Able to read AbsoluteAnchor, OneCellAnchor, TwoCellAnchor in drawing.xml h. Formula will be calculated automatically after generation i. improve performance for XSSF while creating new rows For detail, please read https://npoi.codeplex.com/discussions/443655 j. fix name encoding issue of custom properties in HSSF For detail, please read https://npoi.codeplex.com/workitem/12296 k. fix exception in HSSFRows.RemoveAllCells l. fix CellStyle Hashtable comparison issue in class HSSFCellUtil. This can help prevent over 4000 styles issue from code. m. Fix globalization issue in ExpandedDouble ========================================================================= 2.0 Beta 1 [v2.0.1] (Feb, 2013) New features a. Copy rows, columns inside a sheet b. Copy sheet between workbooks (contributed by Paul Kratt) c. insert rows and column inside a sheet d. OpenXml4Net is stable and ready for use e. Support new Excel functions such as RATE, RANK, ISERR f. Support converting from Excel to Html g. POIFS Browser supports Chart records Example changes a. Use MemoryStream.WriteTo instead in ExportXlsToDownload in order to avoid out of memory exception b. add new examples like CalendarDemo, BusinessPlan, CopySheet NPOI Bug Fixes Issue with 2.0 Beta: Get an non-Closing Element error http://npoi.codeplex.com/workitem/11085 Npoi 2 error in NumericCellValue (XSSFCell) http://npoi.codeplex.com/workitem/11083 [HSSF]Comment is not saved correctly while using a xls template with comment http://npoi.codeplex.com/workitem/11169 Access issue creating worksheet http://npoi.codeplex.com/workitem/11383 Error when running NPOI with Mono C# compiler version 2.0.1.0 http://npoi.codeplex.com/workitem/4547 POI Bug Fixes 53282 - Avoid exception when parsing OPC relationships with non-breaking spaces(poi-developers) 54016 - Avoid exception when parsing workbooks with DConRefRecord in row aggregate(poi-developers) 53404 - Fixed compatibility bug with modifying xls files created by POI-3.6 and earlier(poi-developers) 53763 - avoid style mess when using HSSFOptimiser (poi-developers) 53974 - Avoid NPE when constructing HSSFWorbook on Google App Engine(poi-developers) 53950 - fixed setForceFormulaRecalculation to reset workbook-level "manual" flag(poi-developers) 52211 - avoid unnessary re-coverting content types to US-ASCII, it can cause exceptions on ibm mainframes(poi-developers) HSSFOptimiser will now also tidy away un-used cell styles, in addition to duplicate styles(poi-developers) 53434 - Subtotal is not return correct value. (poi-developers) 53144 - First comment not cloned after cloneSheet() (poi-developers) 53028 - Broken auto fit row height in the cells with word wrap (poi-developers) 53010 - GSoC2012? Improve drawing support in HSSF (poi-developers) 52764 - Unmodified cell comments disappear after HSSFWorkbook.write (poi-developers) 51676 - Using drawingPatriarch.createCellComment(anchor) leads to File error: data may have been lost (poi-developers) 51455 - It would be really nice to be able to set the background picture of a comment (poi-developers) 48989 - If we have a comment but the row is not created we will not be able to get it. (poi-developers) 48873 - Comments not saving in XLS files with collapsible columns (poi-developers) 46143 - setLineStyleColor for comments donot work (poi-developers) 53699 - Patch to correct BorderStyle? enum positions (poi-developers) 53644 - XLS formula bugfix (CalFieldFunc?) + WeekDay? addon (poi-developers) 53446 - Fixed some problems extracting PNGs (poi-developers) 53204 - Improved performanceof PageSettingsBlock? in HSSF (poi-developers) 53500 - Getter for repeating rows and columns(poi-developers) 53476 - Support Complex Name in formulas (poi-developers) 53414 - properly update sheet dimensions when adding column (poi-developers) Add File based constructor to OPCPackage, alongside existing String one (which constructed a File from the string internally)(poi-developers) 53389 - Handle formatting General and @ formats even if a locale is prefixed to them(poi-developers) 53058 - Utility for representing drawings contained in a binary Excel file as a XML tree(poi-developers) 48528 - support negative arguments to the DATE() function(poi-developers) 53101 - fixed evaluation of SUM over cell range > 255(poi-developers)~ 52928 - DateFormatConverter?: an utility to convert instances of java.text.DateFormat? to Excel format patterns(poi-developers) 52895 - show SSTIndex instead of XFIndex in LabelSSTRecord.toString()(poi-developers) 52818 - Added implementation for RANK()(poi-developers) 51564 - support for enforcing fields update in XWPF(poi-developers) 51673 - support grouping rows in SXSSF(poi-developers) 51780 - support replacement of content types in OPC packages (poi-developers) 52057 - updated formula test framework to be aware of recently added Functions (poi-developers) 52574 - support setting header / footer page margins in HSSF(poi-developers) 52583 - fixed WorkbookUtil#createSafeSheetName? to escape colon (poi-developers) 52708 - misc improvements in CellFormat? (poi-developers) 52690 - added a getter for length of encrypted data in Ecma and Agile decryptors(poi-developers) allow runtime registration of functions in FormulaEvaluator?(poi-developers) 52665 - When reading from a ZipFileZipEntrySource? that has already been closed, give IllegalArgumentException? rather than NPE(poi-developers) 52385 - avoid trancated array and vector data when reading OLE properties(poi-developers) 51498 - fixed evaluation of blank cells in COUNTIF(poi-developers) 52576 - support changing external file references in HSSFWorkbook(poi-developers) 49896 - support external references in FormulaRenderer?(poi-developers) 52527 - avoid exception when matchi