Improved performance when loading files with many merged cells.

.Style.Fill.BackgroundColor = XLColor.NoColor now works as expected. It sets the pattern type to none.

Load hyperlinks without references.

Added a way to select cells and ranges. See documentation.

Added worksheets.add(dataTable, tableName) overload

Updated tests

Refactor

Copying conditional formats with relative formulas work as expected.

Updated version #

Fixed issue when comparing fills' pattern background colors.

Fixed issue loading conditional formats with formulas

Fixed issue with conditional formatting formulas.

Conditional formats now accept formulas. ...

Relative formulas are copied properly when copying conditional formats.

Conditional Formats are now copied when copying ranges.

Worksheets with a lot of merged cells now load MUCH quicker.

Removed IXLColor interface to allow color comparison using == and !=

Added tests for validating addresses

Now uses the native String.IsNullOrWhitespace when in .NET 4

XLHelper static class is now public (again)

Conditional formatting now leaves the untouched formats alone. Issue 8053

Fixed issue when copying worksheets with headers and footers

Fix to the fix

Fixed issue when adding empty DataTable items

Fixed loading files with repeating number format ids

Setting the inside borders of a spreadsheet no longer calls all cells within.

Prevented the IDE from triggering the rich text of a cell when debugging.

Fixed issue when adding columns to an existing table

Fixed tables with numeric column names and numeric total labels

Fixed issue with conditional formatting and expressions

Ready for release