EPPlus 릴리스
Released: Nov 9, 2023
v7.0.1 버젼 업데이트
수정사항
- Copying a worksheet with the ExcelWorksheet.CodeModuleName set and not having a VBA project in the workbook caused the name to be duplicated.
- Delete and create an Auto filter caused the workbook to become corrupt.
- Worksheet Copy did not copy images in the header/footer when the destination worksheet was in another workbook.
- Worksheet Copy did not copy images inside group shapes correctly when the destination worksheet was in another workbook.
- Match function did not work with single cells in...
Released: Oct 26, 2023
v7.0.0 버젼 업데이트
기능
- Calculation engine has been updated to support array formulas:
- Added support for calculating legacy / dynamic array formulas.
- Added support for intersect operator.
- Added support for implicit intersection.
- Added support for array parameters in functions.
- Improved support for using the colon operator with functions.
- Improved handling of circular references.
- Added 90 new functions.
- Optimized calculation engine with configurable expression caching.
- Conditional Formatting improvements:
Released: Mar 24, 2023
6.2.x 버젼 업데이트
v6.2.11
Updated Oct 25, 2023
Fixes
- ROUNDUP function sometimes rounded incorrectly.
- Some internal MemoryStream's were not disposed correctly.
- Setting the Pivot table SourceRange to the same range as an existing Pivot Cache sometimes caused the workbook to be corrupt.
- LoadFromCollection MemberInfo[] now works correctly with attributes, but are ignored on nested classes.
- The SUBSTITUTE function did incorrectly handled Excel errors as strings.
- ExcelRangeBase.LoadFromDataTable method did now checks...
Released: Nov 3, 2022
6.1.x 버젼 업데이트
v6.1.3
Updated Feb 24, 2023
Fixes
- When clearing a formula and then insert a row into the worksheet an exception was thrown.
- Having a pivot field with string grouping caused an Exception on loading a workbook.
- ExcelExternalWorkbook.UpdateCache() throw an NullReferenceException if a worksheet name did not exist.
- Applying a style for a worksheet that has a style set on the column level, did not retain the style for the last columns in some cases.
- Could not delete the last row (1048576) in a...
Released: Apr 12, 2022
6.0.x 버젼 업데이트
v6.0.8
Updated Sep 21, 2022
Fixes
- Fixed issue with the DataValidations.Clear() method, where DataValidations were only removed from the collection classes in EPPlus but not removed from the underlying xml.
- Fixed issue where inserting/deleting columns in the source of a pivot table sometimes caused the PivotTable to become corrupt.
- Fixed issue with Png files without the pHYs chunk that failed to Add to the Drawings collection.
- Adjusted the EPPlus source code to avoid validation errors from the...
Released: Oct 21, 2021
5.8.x 버젼 업데이트
v5.8.13
Updated Aug 30, 2022
Fixes
- Copying comments sometimes did not change the name in the vml drawing causing OOXML validation to complain on duplicate drawings.
- The count attribute on 'xsf' node in Styles.xml was not correctly set.
- Setting drawing coordinates did not update the xml on save if ExcelPackage.DoAdjustDrawings was set to false.
- IF function now handle errors correctly.
- Referencing a worksheet to a cell address after a colon (for example 'sheet1'!a1:'sheet1'!A3) did not work...
Released: Mar 8, 2020
5.x 버젼 업데이트
기능
- Support all Excel 2019 chart types with the new, modern styling.
- Insert/Delete ranges in worksheets and rows/cols in tables.
- Extended support for Pivot tables - Filters, calculated columns, support for shared caches, auto sort and "Show Value As" on data fields.
- Pivot table- and table- slicers.
- Custom table-, pivot table- and slicer styles.
- Pivot table styling via pivot areas.
- Improvements of the formula calculation engine and 147 new supported functions.
- Threaded comments with support for...
