ClosedXML v0.95.0-beta1 Release Notes

Release Date: 2019-04-04 // over 3 years ago
  • ๐Ÿ’ฅ Breaking changes

    • Range strings, e.g. A1:B2 are now always treated as absolute, i.e. relative to A1 instead of relative to the top left cell of a given range.
    • ๐Ÿ”จ IXLSheetProtection has been totally refactored and now uses a flag based enum to control the elements that are allowed or locked.
    • โœ‚ Removed IXLSheetProtection.IsProtected setter
    • XLClearOptions and XLCellUsedOptions 's flags are now aligned

    โœจ Enhancements

    • #1015 Text join func enhancement (Thanks @James-Whitfield)
    • ๐Ÿ”จ #1038 IXLSheetProtection refactoring
    • #1054 Implement workbook FileSharing and a few of the properties
    • #1058 Dont recalculate formula cached values after load
    • ๐Ÿ”จ #1077 Refactor digit and letter parsing to allow Unicode characters
    • ๐Ÿ‘ #1109 Don't automatically adjust columns width to contents when inserting datatable. Some users want to opt out because of PlatformNotSupportedException
    • #1129 Implementation pivot table formats (Thanks @b0bi79)
    • โœจ #1130 Enhance TRUNC function for additional parameter
    • #1136 Implement NUMBERVALUE function
    • ๐ŸŽ #1151 Performance improvement to delete entire columns
    • ๐Ÿ–จ #1158 Check that print titles are valid row ranges or column ranges
    • ๐Ÿšš #1170 Remove IXLSheetProtection.IsProtected public setter

    ๐Ÿ› Bug fixes

    • ๐Ÿ’… #1063 Copy comment style correctly when shifting ranges
    • #1108 Correctly save empty cell with quote prefix (do not treat as empty)
    • #1132 <c> elements with missing r attribute: XLAddress constructor had parameters swapped
    • #1133 Enumerate ranges in a deterministic order
    • ๐Ÿ’… #1134 Correctly propagate worksheet style to cells from a worksheet
    • ๐Ÿ’… #1135 Correctly load column-wide styles
    • #1137 Fix changing inner borders of the range
    • #1150 Correctly clear inline string when required
    • #1153 Correctly throw DivisionByZeroException when denominator is zero.
    • #1155 Ignore _X (capital X) as XML escaping char
    • #1161 Avoid creation of new item in Internals.RowsCollection when adding comment
    • ๐Ÿ’… #1168 Fix initialization of default styles for XLCells, XLRows, XLColumns and XLRanges

    Thanks to @Pankraty for many PRs, as usual.

    Binaries are available at:
    ๐Ÿ— ClosedXML: https://ci.appveyor.com/project/ClosedXML/closedxml/builds/23591647/job/dyitdjnq6ta3nnpb/artifacts
    ๐Ÿ— ClosedXML.Signed: https://ci.appveyor.com/project/ClosedXML/closedxml/builds/23591647/job/hk6hbr6kt807lvxf/artifacts