-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Changelog
Tony Qu edited this page Nov 18, 2023
·
7 revisions
New Features
- IWorkbook and XWPFDocument implements IDisposable
- #839 Add DateOnly support
- optimize memory consumption by using RecyclableMemoryStream
- #753 implement XSSFTableColumn and XSSFTableStyle
- #811 XLOOKUP and XMATCH functions support
- #783 Pivot table openxml implementation
- #656 System.Drawing.Common is deprecated on non-Windows platforms
- #894 Get rid of drawing common
- #883 Enable xlsx decryption
- #907 Implement AutoSizeRow method
- new leaveOpen parameter for IWorkbook.Write
Bug Fixes
- #547 SXSSFSheet AutoSizeColumn only considering last lines, missing call in SXSSFRow
- #288 Border style unintentionally shared between CellStyle instances
- #739 CT_WebPublishing.Parse fails to parse targetScreenSize attribute
- #598 Making a deep copy of a table row in Word
- #585 Do not close MemoryStream in IWorkbook.Write(Stream)
- Avoid unnecessary memory consumption in clonesheet and copysheet.
- #726 Unable to Open Excel XLS with hyperlink cells
- #445 Duplicate Keys Item when use SXSSF
- #587 Sheet.CopyRowTo mess the style of the sheet
- #731 Wrong style.xml
- #695 Tint value is not read correctly
- #864 Hyperlink on picture using CT_Hyperlink not working properly
- #829 Excel 2007 Shared formula Error after setting cell formula to null
- #851 Invalid hyperlink throws exception - Invalid URI: The hostname could not be parsed
- #855 XWPFDocument clone table row error
- #892 Incorrect array bounds check in NPOI.XSSF.Model.StylesTable.GetCellStyleXfAt
- #877 Fix ShiftRows destroys merged cell issue
- #911 Word: Order of SdtBlock elements is not correct
- #909 XWPFDocument : line breaks converted to page breaks
- #898 Remove limit of 3 conditional formatting rules
- #903 Instead of throwing exception just get first available font
- #867 Pivot tables serialization fixes
POI Bugs Fixes
- Github 107 Add AREAS function
- POI 61063 Use of arrays of values leads to non empty stack
- POI 63984 AND / OR should treat missing parameters as FALSE
- POI 62254 OFFSET function fails when 2nd or 3rd arguments are missing
- POI 63819 Spreadsheet DATEVALUE function missing
- POI 62857 DOLLAR function not implemented entirely
- POI 65606 Bug in evaluating WEEKNUM
- POI 65846 Add support for NUMBERVALUE function
- POI 65879 Add support for WORKDAY.INTL functions
- POI 65871 Add support for DOLLARDE and DOLLARFR functions
- POI 65870 Add support for BESSELJ function
- POI 49202 add support for the function 'PERCENTRANK'
- POI 64258 Provide implementation for TDIST function
- POI 65850 Add support for Normal Distribution functions
- POI 60029 Fix problem with Days360 method for the month of february
- POI 64238 Make LOOKUP functions deal with empty last arg correctly
- POI 64393 Handle MissingArgEval in relational operators
- 63013 add XWPFRun setLang method
- github-114 Better support for Footnotes and Endnotes
- POI 49202 add support for the function 'PERCENTRANK'
- POI Github 69 Numeric Array Formula and Matrix Function Patch
- #741 Update needed of SharpLibZip to 1.3.3
- #798 public XSSFColor(System.Drawing.Color clr) will create color with Alpha of zero
- #620 NPOI is getting slower while adding many pictures on .NET Core
- #700 make ObjectExtensions internal or define it in a custom namespace
- #723 GetColumnWidth: no need to explore the whole sheet
- #745 Added parsing word table properties Caption and Description
- #687 Fix the order of children of the AutoFilter xml element
- #697 DataConsolidateFunction mapping to wrong ST_DataConsolidateFunction
- #714 Adding CloneStyleFrom to avoid losing custom style properties
- #711 BorderDiagonal not working in v2.5.5
- #715 CopySheet throws NullReferenceException
- #746 Excel file with figures crushes after npoi 2.5.5
- #769 NPOI - Missing shape in word
- #619 Truncate sheet names on XSSFWorkbook.GetSheet
- #724 NPOI Save Combined picture Excel（xlsx 2007），Excel need repair
- #617 Unreadable content detected for xlsx if it contains additional TextBox
- #555 BinaryFormatter issue in net5.0
- #216 XSSFHyper Link with chinese charset issue
- #614 NPOI cannot open some XLS files from Stream
- #238 Add new method: XWPFDocument.ChangeOrientation
- #590 ST_CfvoType missing autoMin and autoMax
- #521 Performance of creating new cells
- #434 SXSSFWorkbook possible performance overhead
- #570 avoid NotImplementedException for ExternalLinks
- #504 Docx File corruption due to the image wrapping (fix again for w14 attributes)
- #317 XSSFFont CloneStyleFrom is linking two fonts instead of creating a copy
- #519 Get a copy of the CT_Border when about to mutate it
- #635 MathX - RoundUp - Bug with double conversion
- #131 Add Title to NPOI.SS.UserModel.IChart
- #248 make GetCTChart() and GetCTChartSpace public
- #599 Corrupted output when XLSX file with "power" symbol in text box is saved
- #287 Null Reference Exception in XSSFSheet.CopySheetImages if there are charts in the original sheet
- #454 Incorrect intersect validation checking for merged regions
- #678 calling XWPFHeaderFooterPolicy.CreateWatermark corrupts the word file
POI Bug FIXES
- 61064 Support behavior of function CEILING in newer versions of Microsoft Excel
- 63268 Fix issue with CellUtil.setFont adding unnecessary styles
- 61652 Attempting to getConditionalFormattingForCell causes NPE
- 65467 Support IFNA function
- 65475 SUMIF and SUMIFS functions do not properly handle #N/A values
- 64605 #595 XWPFRun.FontSize support float
- 62040 Quotient.evaluate function does not accept cell refences
- 56392 IllegalArgumentException in IdentifierManager / XWPFDocument
- github-150 Add XWPFPicture getWidth and getDepth methods
- github-151 Add XWPFRun getStyle method
- github-153 Add XWPFParagraph createHyperlinkRun method
- #589 fileRecoveryPr should not appear after extLst
- #563 Word tables change height row of the template
- #183 picture tag in content control is written without a namespase in output word document
- #582 Table of Contents - Completion
- #180 CT_Text.Write throws null exception
- #554 ReplaceText may throw null exception
- #504 Docx File corruption due to the image wrapping
- #402 broken xlsx using conditional formatting..
- #558 NPOI.SS.UserModel.RangeType missing namespace
- #520 Locale on conditionalcolor scale
- #470 ColumnIndex negative if culture is tr-TR
- #186 NPOI removes background color from conditional formattings
- #315 Can't open default Word template docx file
- #597 Relax version bounds for NPOI's dependency on SharpZipLib
- #489 make GetCTWorksheet method public
- #473 Exception System.ArgumentNullException thrown in .NET standard 2.1
- #457 make XWPFTable.GetCTTbl public
- #464 Missing 'Spacing after' property when 'Line spacing' property settled
- #408 Wrong calculation of IFERROR and Match function
- #436 Empty cells are skipped while using SXSSF objects
- #404 Bug Fix: Paragraph ReplaceText/SearchText In Several Runs
- #435 SXSSFWorkbook possible performance overhead
- #450 fix XSSFSheet.RemoveRow bug
- #448 Add ifs, maxifs, minifs functions to analysis tool pack
- #410 fix Match function for compatible
- #423 AddPicture doesn't work, corrupts DOCX file
- #397 LocalUtil.GetUserTimeZone NullReferenceException
- #167 Unable to add image to a word document header or footer using XWPF
- #346 NullReferenceException when copying sheet in some Excel files
- #413 fix: Rich strings hash for texts with the color set as RGB
- #444 Update RANDBETWEEN
- #158 NPOI Excel Merging Causing “Repaired Records”
- #345 Excel unreadable content error after editing existing file
- #358 Remove static locale state
- #367 fix incorrect footnote handling
- #372 NPOI requires GDI+ dependency even on sheet creation without using column auto-sizing
- #281 InvalidOperationException on XSSFSheet.GetColumnStyle
- #377 AutoSizeColumnTracker to Lazy, fix build errors
- #339 improve performance of CreateRow for bigger excel sheets
- #302 Deleted text is stilll extracted from Word document
- #283 XWPFTableCell.GetParagraphArray(0) always return null
- #256 ISheet.CopyRow() throws NullReferenceException
- #187 customHeight attribute of row for SXSSFWorkbook wrong
- #225 Infinite Loop in Substitute.ReplaceAllOccurrences on empty searchStr
- #199 SXSSFCell: numeric value is serialized with CurrentCulture rules
- #141 XSSFFont.FontHeight setting bug
- #165 Excel warns if we use a font without setting its size
- #203 Add XWPFRun.AddSvg
- #200 Optimizations and bugfixes of SXSSF logic
- #198 Add XWPFStyles.GetStyleWithName(string styleName)
- #325 Fix XSSFDataValidationHelper.CreateValidation to use all CellRangeAddresses.
- Add Excel function support for AVERAGEIF and AVERAGEIFS
- CopySheet support in XSSFSheet
- Implemented OMath formula edit/creation in XWPF
- Fix SharpZipLib 0.86 dependency issue in .NET Framework 4 and .NET 4.5
- Fix FontHeight property issue in XSSF and HSSF
- .NET Standard 2.0 support
- stop .NET Framework 2.0 support (some contributed code start using System.Linq)
- Add Excel function support for AVERAGEIF and AVERAGEIFS
- CopySheet support in XSSFSheet
- Implemented OMath formula edit/creation in XWPF
- Support line and bar mixed chart
- fix SharpZipLib 0.86 dependency issue in .NET Framework
- solve SecurityRules issue since .NET 4.0 while using AllowPartiallyTrustedCallers
- AutoFilter colId must have value even when it equals 0
- Fix NUnit Test cases in VS2017 (development purpose only)
- MathX.Round() - fixing some instances of incorrect rounding and adding
- Fix Word processing fields issue in XWPF
- Fix a bug of 'adding picture to word' failed
- implement XSSF Streaming
- Fix GZIPSheetDataWriter
- Hold file handler when OOXML zip package is closed
- Fix test cases
- Fix a lot of serialization issue of ooxml issue
- Fix phonetic guides tag reading/writing issue
- Fix XWPFRun SetText exception issue
- Fix xml security issue
- Optimize memory for AutoResizeColumn
- Fix sqref property is missing on ProtectedRange
- Fix drawing ooxml issue and cell value bug
- Fix numFmtId property issue on NumFmt node
- Fix ooxml issues for RadarChart and CellStyle
- Fix xfrm namespace issue in ooxml
- Fix ScatterChart issue in ooxml
- Fix ooxml bugs in Vml entities
- fix bug when call ISheet.RemoveRow, it removes a wrong row
- Don't close zip stream when zipoutputstream finish writing
- Implement FIXED, PROPER, DMIN and DGET functions
- XSSF support for evaluating formula references to other Workbooks
- Read text from SDTs at the table cell level, including (sometimes) Cover Page, Table of Contents and Bibliography
- Double Strikethrough support for XWPF runs
- XSSFSheet support for getDrawingPatriarch(), alongside the existing createDrawingPatriarch() method
- Start on common interfaces for Paragraphs and Character Runs for XWPF
- Basic text extractor for older Excel 4,5 and 95 formats
- Add NPOIFS in-place write support, including updating the contents of existing entries
- Support loading .xlsx files with no Styles Table
- 57880 - Handle >32,767 cell styles and formats in XSSF (file format limit is 64,000)
- 57826 - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted
- 56017 - Fix shifting comments with shifted rows
- 56295 - Fix cloning of styles across workbooks and handling of default value of attribute applyFill
- 56380 - Remove limitation of 1024 comments per Workbook
- 56467 - Fix cloning of sheets with pictures
- 57171 - Adjust the active sheet in setSheetOrder()
- 57163 - Adjust the active sheet in removeSheet()
- 57165 - Avoid PartAlreadyExistsException when removing/cloning sheets
- 57196 - Resolve RefEval to it's inner ValueEval in Hex2Dec
- 57482 - Handle XSLX files with no shared strings table in read-only mode
- 46898 - XSSF: Return #VALUE! for circular references.
- 46912 - Add methods to query outline level for HSSF and XSSF
- 49541 - Mapping of symbol characters to unicode equivalent
- 57007 - Add initial implementations of DMIN and DGET functions
- 57373 - Fix get/setFirstVisibleTab() for XSSFWorkbook
- 57231 - Add missing ArrayRecord.clone()
- 56511 - Fix NullPointerException for RichText strings with no formatting for some runs.
- 56888 - XSSFDataValidation ignores "allow blank" read from sheet, assumes true
- 57236 -
- 57254 - XWPF: Correctly build internal list of styles when styles are added
- 57312 - XWPF: Add check for null value of underline w:val
- 57355 -
- 57164 - XSSFDrawing.createCellComment() does not honor dx and dy values passed in
- 57003 - Add implementation of function FIXED
- 57185 - Correct naming from "Serie" to "Series"
- 57010 - Add implementation of function PROPER
- 55280 - XSSF: Greatly improve performance of shifting rows in sheets with many merged regions.
- 48195 - Formulas: Fix incorrect evaluation of IF() with ROW()/COLUMN() as else-result.
- 56914 - XSSFRowShifter.updateConditionalFormatting throws IOOBE when there are more than 1 CTConditionalFormatting
- 51222 - XSSFColor.getARGBHex() returns wrong color for Excel 2007 xlsx file
- 56864 - XWPFLatentStyles.isLatentStyle always returns true if there is at least 1 lsdException
- 57151 - And documentation and validation in CellRangeAddress to prevent invalid row/column combinations
- fix word serialization issues
- fix CloneStyleFrom issue
- Fix vertical alignment default value for XSSFCell
- fix setAutoFilter change range issue
- fix EDate function
- fix FormatException in FormulaParser
- fix Comment random Shape issue (comment serialization issue)
- fix not be able to unlock the cell issue
- 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
- 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
- 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
- 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
- a. XSSFSheet.CopySheet
- b. Excel2Html for XSSF and HSSF
- c. insert picture in word 2007
- d. Implement IfError function in formula engine
- 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
- a. XSSF.DownloadXlsx
- b. XSSF.ConditionFormats
- c. XSSF.LineChart
- d. XWPF.InsertPicturesInWord
- 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
- 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
- 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
- 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
=========================================================================
- 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
- a. Use MemoryStream.WriteTo instead in ExportXlsToDownload in order to avoid out of memory exception
- b. add new examples like CalendarDemo, BusinessPlan, CopySheet
- 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
- 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 matching shared formula records in HSSF(poi-developers)
- 52568 - Added methods to set/get an XWPFRun's text color(poi-developers)
- 52566 - Added methods to set/get vertical alignment and color in XWPFTableCell(poi-developers)
- 52562 - Added methods to get/set a table row's Can't Split and Repeat Header attributes in XWPF(poi-developers)
- 52561 - Added methods to set table inside borders and cell margins in XWPF(poi-developers)
- 52569 - Support DConRefRecord in HSSF(poi-developers)
- 52575 - added an option to ignore missing workbook references in formula evaluator(poi-developers)
- 52540 - Relax the M4.1 constraint on reading OOXML files, as some Office produced ones do have 2 Core Properties, despite the specification explicitly forbidding this(poi-developers)
- 52462 - Added implementation for SUMIFS()(poi-developers)
- 52449 - Support writing XWPF documents with glossaries (Glossaries are not yet supported, but can now be written out again without changes)(poi-developers)
- 52438 - Update CellDateFormatter? to handle times without seconds(poi-developers)
- 52389 - Support ?/? as well as #/# fractions, and tighten DataFormatter? rules for fraction matching(poi-developers)
- 52378 - Support for WORKDAY and NETWORKDAYS functions(poi-developers)
- 52349 - Merge the logic between the TEXT function and DataFormatter?(poi-developers)
- 52349 - Correctly support excel style date format strings in the TEXT function(poi-developers)
- 52369 - XSSFExcelExtractor should format numeric cells based on the format strings applied to them(poi-developers)
- 52369 - Event based XSSF parsing should handle formatting of formula values in XSSFSheetXMLHandler(poi-developers)
- 52348 - Avoid exception when creating cell style in a workbook that has an empty xf table(poi-developers)
- 52314 - enhanced SheetUtil?.getColumnWidth(poi-developers)
- 51875 - More XSSF new-line in formula support(poi-developers)
- POIFS EntryUtils?.copyNodes(POFS,POIFS) now uses FilteringDirectoryNode?, so can exclude from copying nodes not just directly under the root(poi-developers)
- POIFS Helper FilteringDirectoryNode?, which wraps a DirectoryEntry? and allows certain parts to be ignored(poi-developers)
- 52190 - null check on XWPF setFontFamily(poi-developers)
- 52050 - Support for the Excel RATE function(poi-developers)
- 51949 - Avoid NPE on double close of ZipFileZipEntrySource?(poi-developers)
- 51950 - XWPF fix for footnotes not always being present in a document(poi-developers)
- 51963 - Correct AreaReference? handling of references containing a sheet name which includes a comma(poi-developers)
- 51834 - Opening and Writing .doc file results in corrupt document(poi-developers)
- Allow the passing of a File object to WorkbookFactory?.create, which permits lower memory processing than the InputStream? version(poi-developers)
- 51850 - support creating comments in XSSF on an earlier slide when later ones already have them(poi-developers)
- New PackagePart? method getRelatedPart(PackageRelationship?) to simplify navigation of relations between OPC Parts(poi-developers)
- 51832 - handle XLS files where the WRITEPROTECT record preceeds the FILEPASS one, rather than following as normal(poi-developers)
- 51809 - correct GTE handling in COUNTIF(poi-developers)
- 51670 - avoid LeftoverDataException? when reading .xls files with invalid LabelRecords?(poi-developers)
- 51196 - prevent NPE in XWPFPicture.getPictureData() (poi-developers)
- 51196 - more progress with Chart APi in XSSF(poi-developers)
- 51785 - Allow XSSF setForceFormulaRecalculation to work with the minimal ooxml-schemas jar(poi-developers)
=========================================================================
- a. Implement OpenXml4Net (same as System.Packaging from Microsoft). It supports both .NET 2.0 and .NET 4.0
- b. Excel 2007 read/write library (NPOI.XSSF)
- c. Word 2007 read/write library(NPOI.XWPF)
- d. NPOI.SS namespace becomes the interface shared between XSSF and HSSF
- e. Load xlsx template and save as new xlsx file (partially supported)
- f. Diagonal line in cell both in xls and xlsx
- g. Support isRightToLeft and setRightToLeft on the common spreadsheet Sheet interface, as per existing HSSF support(poi-developers)
- h. New examples for NPOI.OpenXml4Net(2 examples), NPOI.XSSF (15 examples) and NPOI.XWPF (5 examples)
=========================================================================
In this release, we fixed most of the bugs found in POI 3.8 beta 4.
- 51535 - correct signed vs unsigned short reading in NDocumentInputStream(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)
- 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)
- 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)
- 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
- 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
=========================================================================
In this release, we fixed most of the bugs found in POI 3.6 and POI 3.7.
- 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
- 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
- xxxxx - 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 cloneSheet() - clone images
- 48026 - duplicate footer and header
- 46664 - Print Area does not save in HSSF worksheets
- 49761 - Double.NaN can be written but not read with POI
- 47309 - Number of Cell Comments in a sheet limited to 65536 with HSSF
- 46776 - POI does not work when run the method "cloneSheet()"
- 47250 - Fixed FontRecord to expect unicode flags even when name length is zero(POI-DEVELOPERS)
- 47198 - Fixed formula evaluator comparison of -0.0 and 0.0(POI-DEVELOPERS)
- 46287 - Control of header and footer extraction in ExcelExtractor / XSSFExcelExtractor(POI-DEVELOPERS)
- 47154 - Handle the cell format @ as the same as General(POI-DEVELOPERS)
- 40520 - Fixed HSSFFont.applyFont() to properly apply font to overlapping regions(POI-DEVELOPERS)
- 45720 - cloneSheet breaks autofilters
- 46643 - Formula parser should encode explicit range operator with tMemFunc
- 51481 - Office 2007 warning if using autofilter
- 50681 - autoSizeColumn sets column width beyond 255 character limit for XSSF sheets and HSSF Sheets
- 50912 - Applying an HSSFCellStyle on an HSSFCell has no effect
- 51143 - NameCommentRecord correction for writing non ASCII strings(poi-developers)
a. Add NameCommentRecord, HeaderFooterRecord b. AutoFilter Phrase II - it's able to create autofilter with any cell range c. Add the method to determine if the cell is merged or not d. Support compilation with MonoDeveloper e. Change all interface name starting with 'I'
=========================================================================
- 5010 - Unable to read xls file with pivot table
- 5139 - SheetExtRecord DataSize is 40
- 6177 - LeftoverDataException: Intermitend Bug
- 6341 - System.NullReferenceException on Workbook.Dispose (+Bugfix)
- Change NPOI.HSSF.Model.Sheet to NPOI.HSSF.Model.InternalSheet
- Change NPOI.HSSF.Model.Workbook to NPOI.HSSF.Model.InternalWorkbook
- 6984 - Cannot manually edit/add dates in the xls created by NPOI
- 46776 - Added clone() method to MulBlankRecord to fix crash in Sheet.cloneSheet()(POI-DEVELOPERS)
- 46547 - Allow addition of conditional formatting after data validation(POI-DEVELOPERS)
- 45290 - Support odd files where the POIFS header block comes after the data blocks, and is on the data blocks list(POI-DEVELOPERS)
- 46904 - Fix POIFS issue with duplicate block 0 references on very old BIFF5/BIFF7 files(POI-DEVELOPERS)
- 45376
- 47970 - added a method to set arabic mode in HSSFSheet(POI-DEVELOPERS)
- 47048 - Fixed evaluation of defined names with the 'complex' flag set(POI-DEVELOPERS)
- 44916 - Allow access to the HSSFPatriarch from HSSFSheet once created(POI-DEVELOPERS)
- 45672 - improve handling by MissingRecordAwareHSSFListener of records that cover multiple cells (MulBlankRecord and MulRKRecord)(POI-DEVELOPERS)
- 45698 - Fix LinkTable to tolerate multiple EXTERNSHEET records(POI-DEVELOPERS)
- 45784 - More fixes to SeriesTextRecord(POI-DEVELOPERS)
- 46065 - added implementation for VALUE function(POI-DEVELOPERS)
- 45966 - added implementation for FIND function(POI-DEVELOPERS)
- 45784 - More fixes to SeriesTextRecord(POI-DEVELOPERS)
- 46065 - added implementation for VALUE function(POI-DEVELOPERS)
- 45966 - added implementation for FIND function(POI-DEVELOPERS)
- 47721 - Added implementation for INDIRECT()
- Added implementation for ISNA()(
- 48332 - fixed ColumnInfoRecord to tolerate missing reserved field
- 45778 - fixed ObjRecord to read ftLbsData properly(POI-DEVELOPERS)
- 46206 - Fixed Sheet to tolerate missing DIMENSION records(POI-DEVELOPERS)
- 47384 - Fixed ExternalNameRecord to handle unicode names(POI-DEVELOPERS)
- 47479 - Fix BoolErrRecord to tolerate incorrect format written by OOO
- 46199 - More tweaks to EmbeddedObjectRefSubRecord(POI-DEVELOPERS)
- 47751 - Do not allow HSSF's cell text longer than 32,767 characters
- 46213 - Fixed FormulaRecordAggregate to gracefully ignore extra StringRecords(POI-DEVELOPERS)
- 46301 - added pivot table records: SXDI, SXVDEX, SXPI, SXIDSTM, SXVIEW, SXVD, SXVS, et al(POI-DEVELOPERS)
- 48180 - be more forgiving of short chart records, which skip some unused fields(POI-DEVELOPERS)
- 46280 - Fixed RowRecordsAggregate etc to properly skip PivotTable records(POI-DEVELOPERS)
- 46174 - Fixed HSSFName to handle general formulas (not just area references)(POI-DEVELOPERS)
- 47768 - Implementation of Excel "Npv" functions
- 47771 - Added method setFunction(boolean) for defined names
- 47770 - built-in positive formats don't need starting '
- 47737 - adjust sheet indices of named ranges when deleting sheets
- 47448 - Allow HSSFEventFactory to handle non-zero padding at the end of the workbook stream
- 47143 - Fixed OOM in HSSFWorkbook#getAllPictures when reading .xls files containing metafiles
- 47415 - Fixed PageSettingsBlock to allow multiple PLS records
- 46269 - Improved error message when attempting to read BIFF2 file(POI-DEVELOPERS)
- 46189 - added chart records: CHARTFRTINFO, STARTBLOCK, ENDBLOCK, STARTOBJECT, ENDOBJECT, and CATLAB(POI-DEVELOPERS)
- 45290 - Support odd files where the POIFS header block comes after the data blocks, and is on the data blocks list(POI-DEVELOPERS)
- 46137 - Handle odd files with a ContinueRecord after EOFRecord(POI-DEVELOPERS)
=========================================================================
- a. ability to identify more Chart record
- b. ColumnAutoSize bug is fixed (bug 3754 )
- c. DefaultRowHeight bug is fixed (bug 3880)
- e. Sheet Tab Formatting (bug 3772)
- f. ShrinkToFit property is exposed to user (bug 4103)
- g. Active selection area (bug 4527)
- h. HSSFSheet.RemoveRow will remove CellRecord as well as RowRecord (bug 3493)
- i. Auto filter feature (alpha)
- j. read xls template with macro (bug 3804)
=========================================================================
- a. Conditional Formating doesn't work as expected
- b. HSSFDataFormat.GetFormat return different index for the same format string
- c. Incorrect namespace spelling of NPOI.SS.Formula
- d. HSSFCell.ToString() method supports DataFormat now
- e. add strong name for all the assembiles
- f. HSSFColor.index static variable isn't accessible in VB.NET due to the HSSFColor Index property
=========================================================================
implement features in POI 3.2 final