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.

Update test framework

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

Remove 2 files with vulnerabilities. They're not supposed to be loaded

Add and test LO files

Refactor TestHelper and ResourceFileExtractor

CodeMaid clean ResourceFileExtractor.cs

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

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

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.

Change projects to use C# 7.2 by default.

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.