NPOI 2.2工具dll

2.1.3.1 (Feb., 2015) Bug Fixes a. fix word serialization issues b. fix CloneStyleFrom issue c. Fix vertical alignment default value for XSSFCell d. fix setAutoFilter change range issue e. fix EDate function f. fix FormatException in FormulaParser g. fix Comment random Shape issue (comment serialization issue) h. fix not be able to unlock the cell issue POI BUG FIXES 55729 - DataFormatter should format Error cells, returning the Excel error string 49237 - HSSF Row Style XfIndex is 12 not 16 bits of data 54607 - NullPointerException in XSSFSheet.getTopRow() when the top row is 1 55745 - fix handling of tables in XSSF if there are comments as well 54673 - Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF 55047 - REPT formula support 55042 - COMPLEX formula support 55041 - CODE formula support 54508 - EDATE formula support 53966 - IfError support (from Analysis Toolpak) 54402 - IfError handling of indirect references New feature a. Add ReplaceText to XWPFParagraph and XWPFRun b. adjust ExcelExtractor interface c. Improving comment missing handling in HSSFSheet d. copy hyperlink in CopySheet and fix some bugs e. Implement ChartSheet in OpenXmlFormats f. Implement shrinktofit for XSSF 2.1.3 (Dec., 2014) Bug Fixes a. fix 2 charts insert in the same sheet issue b. fix a lot of Excel 2007 serialization issues c. fix some Word 2007 serialiation issues d. fix RemoteSheetAt bug e. support changing background in XWPF f. fix Uri-related issues on Mono New examples SetIsRightToLeftInXlsx - show how to use IsRightToLeft property ExtractPicturesFromXlsx - show how to extract pictures from Excel 2007 file SetRowStyle - show how to set whole row style with simple code 2.1.1 (Jun., 2014) New Features a. XSSFSheet.CopySheet b. Excel2Html for XSSF and HSSF 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 n. fix scroll bar and tabs missing in previous 2.1 release 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 - H