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

Merge pull request #709 from Pankraty/StylesRebased ...

* Repositories, style values and style keys implemented

* Styles handling re-implemented for styles reusing

* Test fixed

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

* Performance optimization by reducing number of XLStyle creations

* Performance optimization. Benchmark added

* Fix conditional format initialization

* Non-initialized cell excluded from children of XLColumn and XLRow. Reference files updated (cells with default styles excluded)

* Eliminate redundant XLStyle instances creation (performance impact)

* Exclude empty font, border and fill sections in differential styles

* Missing documentation added. Auto format

* Auto format

* Empty fills and borders considered equal no matter what colors they are.

* Merge conflicts solved. Reference files updated (redundant diff. styles removed)

* Undo some whitespace changes

* Implement ToString() for style keys. Make constructors of abstract classes protected. Remove a style benchmark

* Fix ArgumentNullException usage.

* Make new Value and Key classes and structs internal (#2)

* Make new Value and Key classes and structs internal

* Code style enhancements

* Equality operators for XLStyleValue implemented.

* XLRepositoryBase.ContainsKey method improved. Documentation added.

XLRepositoryBase.ContainsKey method improved. Documentation added.

Equality operators for XLStyleValue implemented.

Code style enhancements

Make new Value and Key classes and structs internal (#2) ...

* Make new Value and Key classes and structs internal

Merge branch 'develop' into StylesRebased ...

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

Fix ArgumentNullException usage.

Implement ToString() for style keys. Make constructors of abstract classes protected. Remove a style benchmark

Don't delete DrawingsPart if there are charts

Move other resource files into Other folder

Small bugfixes and improvements (#782) ...

* Implement IDisposable for XLDataValidations and XLTableField to dispose inner members.

* Expand columns, not rows in ExpandColumns method

* Redundant checks removed, missing checks added

* Avoid null reference and type cast exceptions in Equals methods.

* Redundant check removed; unconditional break from a loop removed.

* Some of the null-checks restored. Aligning fixed.

Throw ArgumentException when attempting to create overlapping tables.