Add to IXLTableField: HeaderCell, TotalsCell and DataCells

Throw exception upon saving when table has no data range rows.

Implement IXLTable methods for appending and replace table data

Delete table rows correctly

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

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).

Throw ArgumentException when attempting to create overlapping tables.

Ensure correct totals row formula format for fields with spaces, single quotes and hashes ...

Make table names case insensitive

Multi-targeting: net40, net461, netstandard2.0 (#315) ...

* Convert to Visual Studio 2017 format.

* Force VS2017 appveyor image

* Add MyGet source before CI build

* Update artifacts

* Implement .NET standard as far as possible.
System.Drawing.Bitmap is still missing - hence the XLPicture API is incomplete

* Change to VS 2017 Preview image to support .NET Standard 2

* Add APPVEYOR environment variable support

* Improve color support and more

* Add a basic test for OpenXml - which currently breaks in .NET Standard 2.0

* Use OpenXML 2.7.2 for all targets

* Replace net452 with net40 build

* Try netstandard where possible

* Update NuGet on appveyor before building

* Implement MetadataExtractor to get image dimensions and format

* When setting culture, do it for every time a test is run.

* Fix dependency issue

* fix support for TIFF files

* Default the image position to top left if position hasn't been set.

* Test all targets

* Update test framework

* Add .editorconfig files back in projects

* Disable OpenXML test on AppVeyor until bug is fixed

* Better approximation of font sizes on netstandard2

* Workaround for OpenXML bug as per https://github.com/OfficeDev/Open-XML-SDK/issues/235

* Fix for DeflateStream not being seekable. Copy to MemoryStream

* Exclude Excel temporary files when building

* Use CoreCompat for measuring fonts on netstandard - remove lots of conditional code

* Reindent file

* Upgrade NUnit

* Add support for .NET 3.5

* Fix for NET35

* Remove explicit test targets. Should work on appveyor now.

* Add Microsoft.CSharp where necessary.
Remove net40 from tests, for now.

* Skip OpenXML document properties test

* Use System.Drawing.Common instead of MetadataExtractor and CoreCompat

* Sign projects

* Specify test assemblies in appveyor.yml

* Comment out platform in order to get CI to correctly detect test assembly path. as per https://github.com/appveyor/ci/issues/1746\#issuecomment-339187046

* Remove .NET3.5 build from artifacts

* Add net40 to tests

* Add reference to Microsoft.CSharp for net40

* Switch net461 to net46
Remove NU1605 warnings
Clean up dependencies

* Generate documentation file

* Ignore warning CS1591: Missing XML comment for publicly visible type or member

* Reenable some System.Drawing features for netstandard2

* Upgrade FastMember.Signed to v1.3.0

* Upgrade NUnit to 3.10

* Upgrade test framework

* Remove framework distinction for netcore

* Collapse empty XML elements for comparison - netcore and netframework versions of OpenXML save the internals differently.

* Copy text.xlsx to output directory

* Enable test for netstandard too.

* Refactor TestHelper.StripColumnWidths

* Align conditional compiler constants for netcore/netstandard to _NETSTANDARD2_0_

* Change documentation file declaration to enable build on Linux

Remove accidental hard-coding of filename in test. Should've saved to memory stream

Keep Table relId unchanged when re-saving

Add method for converting Excel table to IEnumerable<dynamic> and System.Data.DataTable

Prevent adding of empty data table (no columns)

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into drop-dataTable-asEnumerable ...

# Conflicts:
#	ClosedXML/Excel/Cells/IXLCell.cs
#	ClosedXML/Excel/Cells/XLCell.cs
#	ClosedXML_Examples/Misc/InsertingData.cs
#	ClosedXML_Examples/Misc/InsertingTables.cs
#	ClosedXML_Tests/Excel/Styles/NumberFormatTests.cs
#	ClosedXML_Tests/Excel/Tables/TablesTests.cs

Allow totals row when resizing tables

Don't allow overlapping tables

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into issue447-delete-columns-from-table ...

# Conflicts:
#	ClosedXML/Excel/Tables/XLTable.cs
#	ClosedXML/Excel/Tables/XLTableField.cs
#	ClosedXML_Tests/Excel/Tables/TablesTests.cs

Implement Delete() column directly on XLTableField

Delete field when deleting column from table

Add ability to insert data of datatable directly without converting to Enumerable - preparation for .NET Standard

Reformat indentation.

Allow table field rename by setting cell value. Fixes #285

Unknown changes - something to do with line endings?

Implement new XLColumnAttribute

Merge pull request #62 from igitur/add-openxml-validator ...

Optionally validate the workbook using OpenXmlValidator when saving it.

Add custom attribute to specify column order of object exported. ...

Implement DisplayName() attribute for .NET3.5 to replicate Display() attribute for .NET4+

Merge remote-tracking branch 'upstream/develop' into add-openxml-validator ...

# Conflicts:
#	ClosedXML_Tests/Excel/Tables/TablesTests.cs

Enable workbook validation in tests

Set correct table field name in cell value after field was renamed.

Add tests for reading column name when header row is hidden.