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 correctly in the formula calculation.
• Removing / Clearing or inserting into a table with a Calculated Column Formula sometimes caused a corrupt workbook or an Exception.
• ExcelRangeBase.ToDataTable could not export a range with no column names and a single row.
• Removing VBA signatures did not remove the newer types of signatures, Agile and V3.
• LoadFromCollection with attributes now uses HeaderPrefix for in column names for nested complex type properties.

Fixes

• Fixed an error in Positioning and sizing of form controls.
• Pivot table styles in template workbooks sometimes corrupts the new workbook.
• Spaces were not preserved in rich text in drawing objects.
• Defined names referencing external reference sometimes loaded incorrectly.

Fixes

• VBA code modules with LF only as EOL, causes code module to load incorrectly.
• INDIRECT function did not always set the correct data type when returning a single cell.
• Clearing ranges with threaded comments caused an exception.
• Copying drawings with hyperlinks failed.
• Improves insert/delete performance when working with drawings.
• Insert row caused images to change size in some cases when having two anchored drawings.
• Improved handling of percentage values in strings in formula calculation.

Fixes

• Fixed issue with start_num parameter for functions FIND and SEARCH.
• Pivot table slicers in a template sometimes caused a corrupt workbook on save.
• Pivot table fields that had subtotals and null values in shared cache items caused the package to fail on load in some cases.
• Having the value set to 0(zero) and the number format to date or time returned the format instead of the formatted value.
• DeleteColumn caused the worksheet to expands to the maximum column properties extended to the last column (XFD).
• The UPPER and LOWER functions did not handle empty cell values correctly.
• Fixed an issue in ExpressionEvaluator when evaluating empty string criteria.
• Fixed issue where members with complex classes and attributes caused LoadFromCollection to crash.

Fixes

• Removed unnecessary Nuget references to packages already included in the targeting frameworks.
• Fixed calculation issue when ExcelPackage.Compatibility.IsWorksheets1Based is set to true.

Features

• Added missing property 'JustifyLastLine' to ExcelStyle and ExcelXfsXml. Collapsed do not set Hidden on columns when set to true.
• Improved handling of defined names in range addresses in formula calc, for example SUM("MyRange1:MyRange2").
• Added support for numeric criteria with operators in MINIFS/MAXIFS functions.

Fixes

• LoadAsync(FileInfo) and LoadAsync(string) did not close the file stream.
• Hyperlinks referencing the same relation fails to load the package.
• Monochromatic chart color schemes gave the wrong tint/shade for multiple series.
• Escaped double quotes did not work properly for shared formulas in formula calc.
• Table.AddRow did not adjust Conditional Formatting and Data Validation.
• ExcelWorksheet.ClearFormulas method throw a NullReferenceException if ExcelWorksheet.Dimension was null.

Features

• Improve SUBTOTAL handling of cells hidden by filters.

Fixes

• Rounding functions now returns 0 when referencing empty cells.
• Copying elements in vml files caused attributes to lose there name space and create a duplicate.
• Removed most fonts from the FontSize class and lazy-load them when needed to avoid memory spikes.
• Pie chart with horizontal series direction did not use different colors when the VaryColors property was set.
• ExcelWorksheet.Dimension didn't correctly determine sheet dimension if data resides on last excel row.
• Hyperlinks referencing multiple cells was only loaded for the first cells in a range.

Features

• LoadFromCollection with attribute - Added EPPlusTableColumnSortOrder which enables column sort order on class level.

Fixes

• ExcelDrawings.AddBarChart method for pivot charts had the wrong signature.
• Formula calculation adjusted to Excels behaviour regarding when 0 is returned instead of null. Thanks to Colby Hearn for the PR.
• The ExcelRange.Clear method did not remove threaded comments.
• Setting ExcelRange.Value to null only sets the value of the top-left cell.
• Fixed an issue with pivot cache fields having an empty header in the source when updating the cache.
• Pivot field cache containing float and null values caused a corrupt workbook.
• EPPlus could not open workbooks without a normal style.
• SUMIF cannot handle single value, bug fix via Colby Hearn's PR 570. Invalid handling of numeric strings in COUNTIF, COUNTIFS and AVERAGEIF.
• MINIFS and MAXIFS now return zero when there are no matches.
• Added support for setting LicenseContext using a process level environment variable.

Features

• 6 new functions:
  • NORMINV.
  • NORM.INV.
  • NORMSINV.
  • NORM.S.INV.
  • NORMDIST.
  • NORM.DIST.

Fixes

• Default behaviour of SUM, AVERAGE, AVERAGEA, MEDIAN, LARGE, SMALL and PRODUCT functions did not handle cells with errors correctly.
• Fixed load/save of .xlsm files not having an vbaproject.bin in the package.
• EPPlus threw an exception when handling extlist logic for space separated data validations.
• IntParser (formula calc.) could not handle boolean values.
• Copy of comments within the same worksheet caused an ArgumentException when loading the workbook again.
• Range.Copy of conditional formattings with multiple addresses did not work.
• Changed Uri reference handling to avoid relative references to the root.

Fixes

• Inserting rows into a worksheet sometimes didn't update addresses on workbook defined names.
• Overlapping data validation addresses was validated on save which cause workbooks containing such not to be saved.
• Failed to copy cells when data validations or conditional formatting was set.
• COUNTIFS, AVERAGEIFS and SUMIFS fails with single cell ranges.
• Packages with VBA project with a component reference with encoded characters causes the saved package to become corrupt.
• It was not possible to specify legend entry properties for items from secondary y-axis.

Fixes

• Range.Text returned the wrong value for format #.##0"*";(#.##0)"*" on negative values
• LoadFromCollection re-ordered the columns when no order was specified and and the item had more than 16 columns.
• Adding an Unchecked CheckBox Control Created Invalid XLSX File.

Features

• Added support for complex types in LoadFromCollection with attributes.
• Improved handling of decimals in Concat operations during calculation.

Fixes

• Fixed a bug where ExcelFunction.ArgToDecimal rethrow other error types as #VALUE.
• High-Low lines / Up-Down bars and Droplines were not loaded from an existing package.
• Removed validation for negative values in conditional formatting priority, as negative values should be allowed.

Features

• ExcelWorksheetView.SplitPanes method added.
• ExcelRangeBase Fill method added
  • FillNumber.
  • FillDateTime.
  • FillList.
• New collection properties for Rows and Columns
  • ExcelWorksheet.Rows.
  • ExcelWorksheet.Columns.
  • ExcelRangeBase.EntireRow.
  • ExcelRangeBase.EntireColum.
• Support for formatting and deleting individual Chart Legend Entries.
• Range.Copy improvments.
• Handle complex types in LoadFromCollection with attributes.
• The ExcelPackage constructor and the Load/Save methods will now take a string path argument as well as a FileInfo.

Fixes

• Renaming table to a name which contains the old name doesn't correctly update column references.
• Range.Text did not handle empty formats like ;;; correctly.
• Range.Text - Strings within a format with percent, 0"%", incorrectly divides by 100.
• VBA module names that started with a underscore (_) caused the ExcelWorksheet.Copy method to fail.
• Using range.RichText.Remove did not reflect the text to Range.Text.
• Adding a column to table with one column did not add the column.
• ExcelRangeBase.SaveToText did not add TextQualifiers around a formatted numeric value containing the column separator.
• Deleting cells sometimes didn't delete comments.
• Improved handling of ranges as return values from functions in the formula calculation.