Fix issues with copying worksheets across workbooks (#839) ...

* Tests for copying worksheets added

* Add tests for pictures and data validation rules

* Fix test for styles copying

* Extract copying logic into dedicated classes (XLPicture, XLTable, XLNamedRange). Implement copying of conditional formats.

* Implement failing scenario for existing test

* Fixed copying conditional formats

* Fixed copying of merged ranges

* Tests simplified as saving issues must be addressed separately

* Fixed saving the row heights on copied worksheets

* Add tests for copying tables and selected ranges. Fix copying selected ranges.

* Fix copying page setup

* Removed debugging code

* CopyTo and WithoutWorksheet method removed from public API. A new constructor for XLConditionalFormat added. Formatting issues fixed.

* Copying table with or without data implemented. Tests added.

* Revert removing public methods

* Copying pictures within a worksheet implemented. Tests added.

* Tests for named ranges copying added.

* Implement XLPicture.Duplicate method.

* Update doctext

* Fix IXLPicture.CopyTo signature

Update some tests with new methods

Simplify XLCell.cs()

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

Cache parsed values for value cells too

Add test for changing data type (Thanks @prankaty )

Test saving cell value with leading quotation mark and formula correctly

Make pivot table name case insensitive and validate name after change

Add test for persisting cached value under different culture.

Failing test added

Sorted using satements

Added unit test to verify SpreadsheetDocumentType based on SaveAs file extensions.

IXLRangeIndex defined ...

Range indexing using QuadTree implemented
Replace searches of intersected ranges with the optimized version

Add and implement XLNamedRangeScope

Park files that don't load correctly yet. We have to tackle them one by one

Add and test LO files

Shift the try/catch deeper into the formula parsing. ...

Add parameter check in XLHelper.GetColumnLetterFromNumber

Catch the exceptions when the formula is not valid (i.e. shifted too far).

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).

Add support for named ranges referring to expressions or to multiple ranges

С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

Implemented support of storing cell calculated values (#679) ...

* Implemented support of storing cell calculated values

* Merge conflict solved. Test fixed

* API changed according to the review. Comparers and CellRangeReference extracted to separate files.

* AffectingRanges renamed to PrecedentRanges. Conditions fixed.

More inline out parameters

Use inline out parameters provided by C# 7.2

Move reference file to new Other\ folder

Fix pivot tables with totally blank field.

Merge branch 'develop' into StylesRebased ...

# Conflicts:
#	ClosedXML/Excel/Ranges/XLRanges.cs
#          ClosedXML/ClosedXML_Tests/Resource/Other/Charts/PreserveCharts/outputfile.xlsx

Don't delete DrawingsPart if there are charts

Move other resource files into Other folder

Throw ArgumentException when attempting to create overlapping tables.