NPOI 2.1.1

Rating:        Based on 5 ratings
Reviewed:  5 reviews
Downloads: 44350
Released: Jun 6, 2014
Updated: Feb 22, 2015 by tonyqus
Dev status: Stable Help Icon

Recommended Download

Application NPOI 2.1.1 binary
application, 3483K, uploaded Jul 1, 2014 - 23133 downloads

Other Available Downloads

Example NPOI 2.1 examples
example, 4069K, uploaded Jun 6, 2014 - 21217 downloads

Release Notes

Assembly Version: 2.1.0

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
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

Reviews for this release

     
Life savier; had big issues regarding the CloneSheet() method - now it's fixed ! It was the bug with the images, the existing images got cloned but the Drawing Patriarch was null so when adding new images you had to make a new d.p. and that erased the old images (e.g. static company logo in an Excel template). Piece of advice: I see that the ENUM for cell types got it's elements renamed with CamelCase instead of the UPPERCASE_LETTERS. Be carefull when you do the update. (Some might have built class libraries in their application which do not throw build errors) Thanks a lot! Vlad
by andronachevgr on Jun 19, 2014 at 2:56 PM
     
很好的东西,开发者辛苦了
by zouhaohan on Oct 16, 2014 at 10:05 AM
     
in web using
by ruleof150 on Sep 10, 2014 at 5:07 PM
     
wonderful
by kaigeyaotou on Aug 23, 2014 at 10:31 AM
     
123dwqdwqwdqwdwq
by jx_npoi on Jul 29, 2014 at 4:00 AM