Features

• Added IRangeDataValidation.ClearDataValidation which allows you to clear data validations from a range.

Fixes

• Having a table data source set to a defined name, and then insert rows into the range, caused the table source to be inverted into a range without inserting the rows.
• An error occurred when setting the Shape.Text in some cases."Name cannot begin with the ' ' character, hexadecimal value 0x20, due to invalid XML.
• Scientific notation numbers were not...

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...

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...

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...