1.2.5 (April,2012)
In this release, we fixed most of the bugs found in POI 3.8 beta 4.
POI Bug Fixes
51535 - correct signed vs unsigned short reading in NDocumentInputStream(poi-developers)
Support isRightToLeft and setRightToLeft on the common spreadsheet Sheet interface, as per existing HSSF support(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)
NPOIFS Mini Streams now support extending the underlying big block stream to fit more data(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)
Tweak the logic for sizing the HSSFCells array on a HSSFRow to reduce memory over allocation in many use cases(poi-developers)
Fixed NPOIFS handling of new and empty Document Nodes(poi-developers)
Fixed NPOIFS access to Document Nodes not in the top level directory(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)
Support for appending images to existing drawings in HSSF(poi-developers)
NPOI Bug fixes
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
New Features
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
1.2.4 (Nov,2011)
In this release, we fixed most of the bugs found in POI 3.6 and POI 3.7.
NPOI Bug Fixes
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
POI Bug Fixes
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
- 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
没有合适的资源?快使用搜索试试~ 我知道了~
Utility 基础类代码示例大全.rar
共160个文件
cs:126个
dll:20个
txt:8个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 36 浏览量
2023-11-14
14:53:20
上传
评论
收藏 4.9MB RAR 举报
温馨提示
Utility 基础类大全 包含读取AD域用户名或组、Chart图形、cmd、CSVHelper、DataTable转实体、DBHelper、Excel操作类等实用方法。 C#语言写的示例
资源推荐
资源详情
资源评论
收起资源包目录
Utility 基础类代码示例大全.rar (160个子文件)
ADHelp.cs 47KB
DbHelperSQL.cs 40KB
DbHelperSQLP.cs 40KB
DbHelperMySQL.cs 34KB
Utility.cs 33KB
SmtpServerHelper.cs 31KB
DirFile.cs 29KB
HttpHelper.cs 27KB
FTPClient.cs 26KB
OracleHelper.cs 25KB
Assistant.cs 24KB
MongoDBHelper.cs 24KB
BarCodeToHTML.cs 24KB
FileOperate.cs 23KB
ImageClass.cs 23KB
RedisSomeHelper.cs 22KB
XMLProcess.cs 22KB
HtmlHelper.cs 21KB
ExcelHelper.cs 21KB
SqlHelper.cs 21KB
Tools.cs 21KB
PinYin.cs 21KB
StringHelper.cs 19KB
ImageUpload.cs 18KB
Pop3Client.cs 18KB
NetHelper.cs 18KB
DbHelperOra.cs 17KB
DbHelperOleDb.cs 16KB
DbHelperSQLite.cs 16KB
DataToExcel.cs 16KB
ValidatorHelper.cs 15KB
PageHelper.cs 15KB
ConvertJson.cs 15KB
MimeReader.cs 14KB
JavaScriptHelper.cs 13KB
MimeEntity.cs 13KB
FTPHelper.cs 13KB
ManagedThreadPool.cs 12KB
SQLHelper.cs 12KB
OWCChart11.cs 11KB
ConvertJson.cs 11KB
CAPTCHA.cs 11KB
Pop3Command.cs 11KB
YZMHelper.cs 11KB
NPOIHelper.cs 10KB
FTPOperater.cs 10KB
EcanConvertToCh.cs 10KB
GridViewHelper.cs 9KB
XmlHelper.cs 9KB
FormulaExpress.cs 9KB
MailHelper.cs 8KB
IpHelper.cs 8KB
MailMessageEx.cs 8KB
PrintHelper.cs 8KB
PDFHelper.cs 8KB
GridViewExport.cs 6KB
MailSender.cs 6KB
DbNodeContext.cs 6KB
UrlOper.cs 6KB
Captcha.cs 6KB
RMB.cs 5KB
DataTableExtensions.cs 5KB
ConnectCommand.cs 5KB
ConfigHelper.cs 4KB
MailPoper.cs 4KB
ExportExcel.cs 4KB
QueryString.cs 4KB
CSVHelper.cs 4KB
ListCommand.cs 4KB
SessionHelper2.cs 3KB
WebSitePathHelper.cs 3KB
PSD2swfHelper.cs 3KB
BasePage.cs 3KB
DecimalUtility.cs 3KB
DefaultWeight.cs 3KB
JsHelper.cs 3KB
DESEncrypt.cs 3KB
Pop3Response.cs 3KB
ListExtensions.cs 3KB
ImageDown.cs 3KB
CsvHelper.cs 3KB
INIFile.cs 2KB
QuotedPrintableEncoding.cs 2KB
CommandInfo.cs 2KB
TopCommand.cs 2KB
ConfigLoad.cs 2KB
CacheHelper.cs 2KB
CookieHelper.cs 2KB
INIFile.cs 2KB
Pop3Exception.cs 2KB
StatCommand.cs 2KB
Pop3Commands.cs 2KB
RetrCommand.cs 2KB
SessionHelper.cs 2KB
Loader.cs 2KB
ListResponse.cs 2KB
SerializeHelper.cs 2KB
RetrResponse.cs 2KB
Pop3ListItem.cs 1KB
Stat.cs 1KB
共 160 条
- 1
- 2
资源评论
等天晴i
- 粉丝: 3478
- 资源: 10万+
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功