Make range address invalid on worksheet deleting. ...

Handle invalid ranges in XLNamedRange.
Re-implement XLAddress and XLRangeAddress ToString* methods to correctly process #REF!

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

Make pivot table name case insensitive and validate name after change

Add and implement XLNamedRangeScope

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

Use inline out parameters provided by C# 7.2

When copying a worksheet, named ranges on the source worksheet have to point to the new destination sheet. Fixes #416

Add extension method to wrap sheet name in quotes, only if required, i.e. it contains a space in the name ...

Throw exception of invalid named range is added on workbook scope
Contain named range references to minimum and maximum column and row dimensions when deleting rows / columns. Fixes #328

Unknown changes - something to do with line endings?

Project hierarchy cleanup