Breaking Changes in EPPlus 8

Breaking changes from EPPlus 8.0

• Set ExcelPackageSettings.ApplyFiltersOnSave default 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 Angel is now public double Angle.
• Removed reference to EPPlus.System.Drawing for primary image and text handlers. The generic handler is now used for all target frameworks. The 'SystemDrawingTextMeasurer. can still be used referencing the EPPlus.System.Drawing Nuget package and set the 'PrimaryTextMeasurer' or the 'PrimaryImageHandler'.
• 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 SystemDrawingTextMeasurer or SystemDrawingImageHandler classes as primary handler. Also see https://github.com/EPPlusSoftware/EPPlus/wiki/Autofit-columns.
• Adding Threaded Comments now throws an exception if the 'personId' does not exist in the ThreadedCommentPersons Collection.
• Worksheet.Dimension now returns the address including rows and columns data.

Removed Methods & Properties

• Obsolete property ExcelVbaReferenceControl.LibIdExternal, please use LibIdExtended instead.
• Obsolete property ExcelDataValidation.IsStale has been removed.
• Obsolete property ExcelLineChartSerie.LineColor has been removed. Use Border.Fill.Color instead.
• Obsolete property ExcelLineChartSerie.MarkerSize has been removed. Use Marker.Size instead.
• Obsolete property ExcelLineChartSerie.LineWidth has been removed. Use Border.Width instead.
• Obsolete property ExcelLineChartSerie.MarkerLineColor has been removed. Use Marker.Border.Fill.Color instead.
• Obsolete property ExcelRadarChartSerie.MarkerSize has been removed. Use Marker.Size instead.
• Obsolete property ExcelScatterChartSerie.LineColor has been removed. Use Border.Fill.Color instead.
• Obsolete property ExcelScatterChartSerie.MarkerSize has been removed. Use Marker.Size instead.
• Obsolete property ExcelScatterChartSerie.MarkerColor has been removed. Use Marker.Fill instead.
• Obsolete property ExcelScatterChartSerie.LineWidth has been removed. Use Border.Width instead.
• Obsolete property ExcelScatterChartSerie.MarkerLineColor has been removed. Use Marker.Border.Fill.Color instead.
• Obsolete property ExcelStockChartSerie.LineColor has been removed. Use Border.Fill.Color instead.
• Obsolete property ExcelStockChartSerie.MarkerSize has been removed. Use Marker.Size instead.
• Obsolete property ExcelStockChartSerie.MarkerColor has been removed. Use Marker.Fill instead.
• Obsolete property ExcelStockChartSerie.LineWidth has been removed. Use Border.Width instead.
• Obsolete property ExcelStockChartSerie.MarkerLineColor has been removed. Use Marker.Border.Fill.Color instead.
• Obsolete Method ExcelDrawings.AddPicture(string, Stream, ePictureType?) has been removed. Use ExcelDrawings.AddPicture(string, Stream) instead.
• Obsolete Method ExcelDrawings.AddPicture(string, Stream, ePictureType?, Uri) has been removed. Use ExcelDrawings.AddPicture(string, Stream, Uri) instead.
• Obsolete property ExcelHeaderFooter.InsertPicture has been removed.
• Obsolete Constructor ExcelHyperLink(string, bool) has been removed. Depricated constructor, use ExcelHyperLink(string) instead
• Obsolete property ExcelStockChartSerie.MarkerColor has been removed. Use Marker.Fill instead.
• Obsolete property ExcelRow.RowID has been removed.
• Obsolete interface IRangeID has been removed.
• Obsolete property ExcelWorksheet.AutoFilterAddress has been removed. Use AutoFilter.Address instead.
• Obsolete Method ExcelWorksheet.DeleteRow(int, int, bool) has been removed. Use ExcelWorksheet.DeleteRow(int, int) instead.
• Obsolete Method ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int, eErrorType) has been removed. Use property ArgumentMinLength instead.
• Obsolete Method ExcelFunction.ValidateArguments(IEnumerable<FunctionArgument>, int) has been removed. Use property ArgumentMinLength instead.
• Obsolete property ExcelPivotTable.TableStyle has been removed. Use property PivotTableStyle instead.

Changed data type

• ExcelChartTrendline.Order from decimal to double.
• ExcelChartTrendline.Period from decimal to double.
• ExcelChartTrendline.Forward from decimal to double.
• ExcelChartTrendline.Backward from decimal to double.
• ExcelChartTrendline.Intercept from decimal to double.
• ExcelDoughnutChart.FirstSliceAngle from decimal to double.
• ExcelDoughnutChart.HoleSize from decimal to double.
• ExcelTime constructor now takes double as parameter instead of decimal.
• ExcelTime.ToExcelTime() returns a double instead of decimal.
• ExcelWorkbook.MaxFontWidth from decimal to double.
• ExcelView3D.Perspective from decimal to double.
• ExcelView3D.RotX from decimal to double.
• ExcelView3D.RotY from decimal to double.
• ExcelPrinterSettings.LeftMargin from decimal to double.
• ExcelPrinterSettings.RightMargin from decimal to double.
• ExcelPrinterSettings.TopMargin from decimal to double.
• ExcelPrinterSettings.BottomMargin from decimal to double.
• ExcelPrinterSettings.HeaderMargin from decimal to double.
• ExcelPrinterSettings.FooterMargin from decimal to double.
• ExcelSparklineColor.Tint from decimal to double.
• ExcelColorXml.Tint from decimal to double.
• ExcelColor.Tint from decimal to double.