- 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

- Fixed issues 6237, 6240

- Added data validation. ...

- Deleting or clearing cells deletes the hyperlinks too.

- Hyperlinks. ...

- Fixed issue 6131
- Added methods table.Column and table.Columns - You can now retrieve a table column by its field name.

- Interface cleanup

*1)* Fixed issues 6138 (error loading shared formulas), 6139 (Custom Properties and Shared Strings) ...

*2)* Added method workbook.GetSharedStrings() which returns the list of strings which will be shared in the workbook. 
*3)* Added method workbook.AddSharedString
*4)* Added Boolean property cell/range .ShareString with a default value of true. If set to false the cell's text will not be shared and stored as an inline value.
*5)* Copying a worksheet also copies Table definitions, NamedRanges, PageSetup, Outlines, etc.
*6)* Fixed issue with tables of the same name.
*7)* Implemented custom properties via workbook.CustomProperties and workbook.CustomProperty(name)
*8)* Added method cell.InsertData(collection) which returns a range that contains the data.
*9)* Added method cell.InsertTable(collection) which returns a table that contains the data.

- Fixed formatting issue with non-US locale

- Added .CopyTo methods to the worksheets: ...

- Added property worksheet.Position to set the position of the worksheets. 
- Added overload Worksheets.Add(String sheetName, Int32 position). This way you can add a worksheet in a specific position in one shot.
- Added method range.RangeUsed()
- Added method workbook.Worksheet(String/Int32) to retrieve existing worksheets. I can't believe it never occured to me to add this before.
- Improved overall performance.
- Fixed Issue # 6807
- Reduced the size of the generated files.

- Fixed formatting issue

Squeezed more performance out...

Broken build - Do not download

- Improved overall performance. ...

- Hid the IXLStylized interface (this was long overdue).
- Fixed Issue #6084

- Added Excel Tables, and you can call a cell using the field name. ...

- Modified the behavior of range.InsertRows/Columns. When you insert a column after the range or a row below the range, the range will be expanded to include the newly added rows/columns. If you insert a column before the range or a row above the range, the range will move accordingly but not expand. This is the default behavior but the insert rows/columns now have a parameter for you to specify whether or not to expand the range.
- Added range.ClearStyles() method. It will preserve number/date formats though.
- Added  set only properties to .Cells(...) so now you can do something like: worksheet.Row(1).Cells("1-3,5,7").Value = "Good!";
- Added methods to .Cells(...)
- Removed the properties range.FormulaA1 and range.FormulaR1C1. Please use range.Cells().FormulaA1 and range.Cells().FormulaR1C1 instead.
- Improved save performance, A LOT. (Thanks to GFraser for the help locating the bottlenecks). I still have a few things to do to improve the performance but I wanted to release this version because of the substantial improvements already made.

- AdjustToContents now ignores merged cells. ...

- Added overloads to AdjustToContents so you can specify the rows/columns you want to use for calculating the height/width
- Renamed range.ContainsRange(range) to range.Contains(range)
- Added ability to freeze panes via the worksheet.SheetView object
- Added method range.Intersects(range)

- Restructured Rows/Columns/Range/RangeRow/RangeColumn objects to be more natural. ...

- Commented the interfaces so now you'll get useful information from the intellisense.

- ClosedXML now supports Theme colors. ...

- Switched from using Color to XLColor.
- Added method worksheet.Clear()
- Fixed issues 5946, 5962

Fixed Issues: 5951, 5953, 5956, 5957, 5958

- Added ability to specify the order of the sheets via the worksheet.SheetIndex property. ...

- Fixed issues 5947, 5948, plus a problem with inserted sheets (special thanks to Marc Wimmer for these)

Improved performance (A LOT)

Replaced optional parameters with method overloads.