Update XLCell.MergedRange to use GetIntersectedRanges

Update reference files (fills with patternType="none" removed)

Simplify XLCell.cs()

Load file's cached value into XLCell.CachedValue - need to some refactoring of the internal parsing in XLCell

Ranges handling redesign (proof-of-concept) (#766) ...

* Immutable range addresses implementation start

* Immutable range addresses implementation continue

* Range addresses made immutable

* Helper methods for range addresses introduced

* XLRangeRepository introduced

* Range factory introduced

* XLRow and XLColumn constructor calls replaced with factory methods.

* Range shifting with no callback actions implemented

* Ranges shifting improved

* Shifting of worksheet data called explicitly. Shifting of CF ranges fixed

* MergedRanges copying removed as it's performed with rows copying. Minor changes in reference file

* Test fixed (arguments reordered)

* Sharing implemented for tables

* Addresses comparison fixed. Formula shifting fixed

* Setters for FixedRow and FixedColumn removed

* Clean-up

* Flaky test fixed.

* Merge conflicts solved

* Make most of the classes non-disposable

* Clean up

* Merged ranges shifting fixed

* Remove redundant variables, clean up usings.

* Restore usings needed for Release configuration. Remove unused constructor (has been replaced with a method in XLWorksheet).

Change XLTable.Theme default value to TableStyleMedium2 to align with Excel

Сonsolidation of conditional formats and data validation rules (#761) ...

* Failing test added

* Multiple ranges for conditional format

* Clearing ranges of CF fixed.

* XLConditionalFormat.Range implemented via Ranges.

* Tests for CF copying added

* XLRangeConsolidationEngine implemented

* Conditional formats consolidation re-implemented.

* Data validaton rules consolidation implemented

* Tests fixed

* CF formula adjustment implemented

* Fix clearing formats not covered by cleared range

* Reference files updated (uncertain about changes). Adjusting CF formulas fixed

* Fix multi-range conditional formats loading. Fix CF consolidation to prevent reordering of rules.

* Fix formula shifting for multi-ranged conditional formats.

* Merge conflicts solved

* Range property made non-obsolete and returning First rather than Single

Exclude empty font, border and fill sections in differential styles

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into StylesRebased ...

# Conflicts:
#	ClosedXML/Excel/XLWorkbook.cs
#	ClosedXML_Tests/Resource/Examples/Misc/AddingDataSet.xlsx
#	ClosedXML_Tests/Resource/Examples/Misc/AddingDataTableAsWorksheet.xlsx
#	ClosedXML_Tests/Resource/Examples/Misc/CopyingWorksheets.xlsx
#	ClosedXML_Tests/Resource/Examples/Misc/ShowCase.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/AddingRowToTables.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/CurrentRowColumn.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/DeletingRanges.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/SortExample.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/TransposeRanges.xlsx
#	ClosedXML_Tests/Resource/Examples/Ranges/TransposeRangesPlus.xlsx
#	ClosedXML_Tests/Resource/Examples/Tables/InsertingTables.xlsx
#	ClosedXML_Tests/Resource/Examples/Tables/UsingTables.xlsx

Keep Table relId unchanged when re-saving

Eliminate redundant styles creation during saving (#717) ...

* Fix reference file with duplicate styles. Remove Alignment from comparison as it does not exist in cellStyleXfs section.

* Fixed reference files having redundant styles

Fix issues with data validation rules (#718) ...

* Failing tests added

* Modified logic of cell DataValidation rules

* DataValidation.xlsx updated. It had 42 rules at sheet 2, now it has 16.

* Tests muted until formula shifting fixed

* Reading DataValidation rules for ranges made pure

* Restore DataValidation implicit creation to avoid breaking changes. Fix clearing data validation.

* Original test restored (use DataValidation instead of SetDataValidation)

Reference files updated (minor changes in XML: items reordered, default style elements skipped)

Parse percentage too when setting datatype to numeric. Fixes #687

Escape quotes in worksheet names

Fix active cell issue when freezing panes

Don't explicitly use Convert.ToDecimal - it leads to bounds errors.

Save calculated column formula in table field (#528) ...

* Save calculated column formula in table field

* Add data format id to table columns if data format is consistent.

* Major improvement to the handling of styles. Drops IXLFill.PatternBackgroundColor!

* Remove property changed vars on XLFill

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into issue447-allow-table-resizing ...

# Conflicts:
#	ClosedXML/Excel/Cells/XLCell.cs
#	ClosedXML/Excel/XLWorkbook_Save.cs
#	ClosedXML_Tests/ClosedXML_Tests.csproj

Merge pull request #458 from igitur/issue457-file-bloat ...

Don't save new empty Row elements in SheetData when they are 'empty'

Allow static members to be dumped.

Allow totals row when resizing tables

Don't save new Row elements in SheetData when they are 'empty' (no child cells or no styles)

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into optimize-calcchain-generation ...

# Conflicts:
#	ClosedXML/Excel/XLWorkbook.cs

Optimise calculation chain generation and introduce new SaveOptions

Update test cases for array formulas

Allow tranposed InsertData

Update file.

Merge branch 'develop' into develop

Merge branch 'develop' of https://github.com/closedxml/closedxml into issue252-evaluate-formulas-when-saving ...

# Conflicts:
#	ClosedXML/Excel/Cells/XLCell.cs
#	ClosedXML_Examples/Misc/Formulas.cs
#	ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
#	ClosedXML_Tests/TestHelper.cs