Add separate configurations for signed and no-signed versions. Update .nuspec file

Update some tests with new methods

Simplify pivot table example

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

Make extension methods internal. ...

Replace with morelinq in Examples project

Change projects to use C# 7.2 by default.

Undo some whitespace changes

Bump version to 0.93.0

Fix dotnet core appveyor version patching.

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

Provide more enum options for clearing ranges. - BREAKING CHANGE

#613 Pivot table Field Settings saving and loading (#616) ...

* save and load PivotField options

* #613 Pivot table Field Settings saving and loading

* test fixed

* no message

Correctly apply XLSortOrder sortOrder parameter for table sorting. Fixes #705

Add dategroup filtered column. Fixes #701

Set C#6 for release builds

Parse percentage too when setting datatype to numeric. Fixes #687

Framework version at packages.config fixed

Change target framework to 4.0

Fix active cell issue when freezing panes

Refactor IXLConditionalFormat StopIfTrue

Don't explicitly use Convert.ToDecimal - it leads to bounds errors.

Implement DatesOccurring conditional formatting

#598 Fixed some bugs saving pivot table. (#603) ...

* Fixed some bugs saving pivot table.

* Added test

* Resolve conflict

Added tests, XLPivotSortType.Manual renamed to XLPivotSortType.Default

As AppVeyor complains about C#7 features, let's tell VS to use C#6.

Breaking change: Change XLCellValues to XLDataType

Save calculated column formula in table field (#528) ...

* Save calculated column formula in table field

* Add data format id to table columns if data format is consistent.

* Major improvement to the handling of styles. Drops IXLFill.PatternBackgroundColor!

* Remove property changed vars on XLFill

Pivot table default filter (#508) ...

* Make pivot table shared strings internal only

* Clean up TestHelper

* Save selected values in filters

* Implement DateTime type in saving pivot tables

* Implement loading of pivot table filters

* Update pivot table examples

* Implement filters with multiple selected values

* Update reference pivot table file

Implement pivot table row and column header captions

Cleanup