NPOi 2.5.5 Release Note

[tonyqus]

Release date: Oct 25, 2021

#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