Get cell by full address (#825) ...

* Failing test added

* Obtaining cell by a full address fixed.

* Tests for non-existing addresses added

* Add more exotic test cases

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

Build Nuget package on AppVeyor

Remove unreachable code; disable warning for filling obsolete property

Treat warnings as errors.

Support table sources for pivot tables

Remove CreatePivotTable overload that doesn't provide a name

Fix XLRangeBase.CreatePivotTable destination sheet - must equal targetCell's

Simplify adding table to pivot table

Rename IXLPivotTables.AddNew to Add and make the old methods obsolete

Remove IXLPivotTables.Add() - wasn't used

Add method AddNew to add pivot table directly from table

Remove ArgumentException from XLCell.Value ...

Add possible ArgumentException when changing XLCell.DataType

Simplify XLCell.cs()

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

Use autoproperty for XLCell.Worksheet

Cache parsed values for value cells too

Make pivot table name case insensitive and validate name after change

Extract and consolidate ValidateName

Remove _rangeList and implement auto-property for XLNamedRange

Extract new method ValidateName

Add more .Contains methods and clean up internal dictionaries with StringComparer.OrdinalIgnoreCase ...

Add IXLPivotTable.Worksheet property
Add XLPivotTable.Name validation (copied from XLTable's Name validation)

CodeMaid reorganise and clean XLPivotTables

CodeMaid organise and clean IXLWorksheets

Change call .ToString() to .ToInvariantString() ...

Change call .ToString() to .ToInvariantString() when save workbook

Simplify and rename RebaseShapeIds to RebaseNonVisualDrawingPropertiesIds

Fix determining the first column of used range

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