Fix determining the first column of used range

Failing test added

Sorted using satements

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

Fixed GetSpreadsheetDocumentType method to get Template and MacroEnabledTemplate types.

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

Use pattern matching for ToInvariantString

Make extension methods internal. ...

Replace with morelinq in Examples project

С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

Correctly set internal cache Id after generating it. For repeated saves, this is NB

Load pivot table with empty field correctly

Fix pivot tables with totally blank field.

Change projects to use C# 7.2 by default.

Cell addresses made immutable

Ignore XLAddressLight.cs - Not used anywhere