-
Notifications
You must be signed in to change notification settings - Fork 297
Breaking Changes in EPPlus 8
Jan Källman edited this page Feb 17, 2025
·
8 revisions
- Set
ExcelPackageSettings.ApplyFiltersOnSavedefault value to false. - RichText now returns font name, size and font family from cell style if not set.
- Fixed spelling error in
ExcelDrawingGradientFillLinearSettings.public double Angelis nowpublic double Angle - Removed reference to
EPPlus.System.Drawingfor primary image and text handlers. The generic handler is now used for all target frameworks. TheSystemDrawingTextMeasurercan still be used referencing the EPPlus.System.Drawing nuget package and set thePrimaryTextMeasureror thePrimaryImageHandler. - Switched default theme to the newest Excel theme (202300)
You can still use these handlers by referencing the EPPlus.System.Drawing handlers nuget package and use the
SystemDrawingTextMeasurerorSystemDrawingImageHandlerclasses as primary handler. Also see https://github.com/EPPlusSoftware/EPPlus/wiki/Autofit-columns -
ExcelPackage.LicenseContextis replaced by theExcelPackage.Licenseproperty. For commercial licenses a license key must be set using theLicense.SetCommercialmethod. For non-commercial use you must set the license using theLicense.SetNonCommercialPersonalorLicense.SetNonCommercialOrganizationmethods. Non-commercial use will tag the workbook with "EPPlus-Noncommercial" and reserve the Comment workbook property for license information.
- Obsolete property
ExcelVbaReferenceControl.LibIdExternal, please useLibIdExtendedinstead. - Obsolete property
ExcelDataValidation.IsStalehas been removed.
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles