*1)* Add property Count to IXLWorksheets ...

*2)* Add method TryGetWorksheet to IXLWorksheets

Remove XLAdress compare operators ...

Refactoring XLAdress constructors
Add creating of non exists directory in XLWorksheet.Load and XLWorksheet.SaveAs

Major improvement in load procedure.

*1)* Improved performance. ...

*2)* Fixed range.RangeUsed when no cells were used.
*3)* Added methods row.AddHorizontalPageBreak and column.AddVerticalPageBreak
*4)* Added properties worksheet.TabSelected, worksheet.TabActive

*1)* Mayor performance improvements. ...

*2)* AdjustToContents now take into account the text rotation.
*3)* Fixed issues 6782, 6784, 6788

*1)* Improved Overall Performance ...

*2)* Fixed issues 6769, 6756

Fixed issue 6756

*1)* Added overload address.ToString(XLReferenceStyle) to pick from A1, R1C1, or the workbook default. ...

*2)* Added overload range.Cells(String) for you to specify multiple cells at once.
*3)* ClosedXML will no longer set the default print area to the worksheet.RangeUsed() 
*4)* Fixed issue 6749 (range.RangeUsed method)

Fixed new AdjustToContents method.

*1)* Added TabColor property to the worksheets. See example [Tab Colors] ...

*2)* Added overloads to further fine tune how adjust to contents functions work:

IXLColumn AdjustToContents(Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Double minWidth, Double maxWidth);
IXLColumn AdjustToContents(Int32 startRow, Int32 endRow, Double minWidth, Double maxWidth);

IXLRow AdjustToContents(Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Double minHeight, Double maxHeight);
IXLRow AdjustToContents(Int32 startColumn, Int32 endColumn, Double minHeight, Double maxHeight);

*3)* Fixed issue 6706 (sheet protection)

*1)* Added FindCells, FindColumns, and FindRows methods to the workbook object. ...

*2)* Added cell.ValueCached property that holds Excel's cache of formula evaluations.
*3)* Added the following properties to the worksheets:
ShowFormulas 
ShowGridLines 
ShowOutlineSymbols 
ShowRowColHeaders 
ShowRuler 
ShowWhiteSpace 
ShowZeros 
*4)* Added methods Worksheets.Add(DataTable), Worksheets.Add(DataSet). 
*5)* Fixed issues 6609, 6532, 6510, 6499, 6705, 6508
*Breaking Changes:* Removed static method XLWorkbook.GetXLFont(). When you add a header/footer text which you want to format just modify the rich text/font returned by the .AddText(...) methods.

Broken build. Do not download.

Added cell.ValueCached property that holds Excel's cache of formula evaluations.

Fixed issues 6609, 6532, 6510

- Fixed issue 6510

Broken Build for BlackMael

- Added sorting capabilities to ranges and tables. Please see example [Sorting Data] ...

- Fixed issue 6494.

- Fixed issue 6487

*1)* Added method range.CopyTo(range/cell) ...

*2)* Added AutoFilter feature for ranges.
*3)* You can now open from a file or stream and save to either a file or a stream (regardless of the source).
*4)* Fixed issues 6429, 6380, 6482

- worksheet.CopyTo(...) should now work as expected. ...

- Fixed issues 6406, 6370
- Applied patches 9077, 8683, 9014

*1)* Added suport for sheet/cell protection (Thanks to BlackMael for all the help). ...

*2)* If you set the value of a cell to a string containing an Environment.NewLine, ClosedXML will turn on wrap text on the cell. This behavior is consistent with Excel's.
*3)* Implemented style.Border.OutsideBorder (this was long overdue).
*4)* Fixed issues 6375, 6391

*1)* Modified the save function so it will be less likely to break an existing file with features not recognized by ClosedXML. ...

*2)* Added methods cell.AddToNamed(...)
*3)* Fixed issues 6313, 6340, 6392, 6389, 6341

Fixed issue 6363 (slow saving of formulas)

Fixed issue 6373

- Fixed issue 6364

*1)* Formulas now adjust automagically when you insert/delete rows/columns/cells ...

*2)* Added methods ranges.AddToNamed(...), ranges.Value, ranges.SetValue(...)
*3)* Insert[Rows/Columns/Cells] methods now return the collection of inserted rows/columns/cells.
*4)* Added methods cell.InserCells[Above/Below/Before/After](Int32)
*5)* Added method worksheet.NamedRange(String)
*6)* The value of a cell that points to another cell in another sheet now returns the correct value.
*7)* Fixed issue 6268

- Fixed issues 6331, 6330

*1)* Added method cell.SetValue<T>(T value) which sets the cells data type based on "T" instead of the contents of "value". ...

*2)* (.Net 4 only) When inserting a table from a collection of objects ClosedXML will check for the custom property [Display(Name="Field Name")] and use it for column name if exists. Otherwise it will use the property's name.
*3)* Fixed issue where ClosedXML would load dates as numbers if the file didn't specify the data format.
*4)* Fixed issue where you could not hide the first sheet.
*5)* Added support for array formulas. To use it just put your formulas between curly braces, e.g. cell.FormulaA1 = "{1+1}"
*6)* Fixed issues 6312, 6307, 6295, 6285

*1)* Added methods/properties to the worksheets: worksheet.Hide(), worksheet.Unhide(), worksheet.Visibility ...

*2)* If a cell A references another cell B then cellA.Value will return the value of cellB
*3)* When inserting a DataTable ClosedXML will take the columns captions (if available) and use it as headers. If no caption is available then the column name will be used. Thanks to nitzzzu for the suggestion.
*4)* You can now set data validations to multiple ranges in one shot via .Ranges(...).DataValidation.

- Fixed issues 6257, 6266