Fixed issue loading conditional formats with empty strings.

Misc performance tweaks.

Fixed loading issue with files with many columns

Can now open OpenXML files without references. These files should be banned if you ask me.

Indexed color 64 now maps to Color.Transparent

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.