Implement OpenXML's CellFormat.QuotePrefix

Store picture markers against a range, rather than an address to benefit from range repository notifications

Implement the full range of Item subclasses for pivot tables ( https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.shareditems.aspx )

Refactor (simplify) filter interfaces: Remove IXLAutoFilter. Rename IXLBaseAutoFilter to IXLAutoFilter. Remove IXLAutoFilter.Set method.

Clear all cell contents (formats too) in pivot table range upon loading.

Clear pivot table rendered range upon loading to avoid conflict on rendered cells when opening the file.

Allow pivot tables to have no theme

Correctly unprotect worksheet without password

Ignore pivot table data field base items that are out of range.

Make range address invalid on worksheet deleting. ...

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

Bug fix - unsupported CellValues.String Data type ...

Changes at workbooks loading and unit test with file example to test changes.

Apply style Normal to a worksheet by default.

Optimize cells loading (remove conversion row number and column number to a string address that has to be parsed afterward)

Improve workbook load performance by eliminating redundant cell style instantiation

Remove unreachable code; disable warning for filling obsolete property

Support table sources for pivot tables

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

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

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

С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

Use inline out parameters provided by C# 7.2

Load pivot table with empty field correctly

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

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.

Merge branch 'develop' of https://github.com/ClosedXML/ClosedXML into Pankraty-StylesRebased ...

# Conflicts:
#	ClosedXML/Excel/Tables/XLTableField.cs
#	ClosedXML/Excel/XLWorkbook_Save.cs

Remove XLHelper.IsNullOrWhiteSpace

Merge branch 'develop' into Pankraty-StylesRebased ...

# Conflicts:
#	ClosedXML/ClosedXML.csproj
#	ClosedXML/Excel/Style/Colors/XLColor_Public.cs
#	ClosedXML/Excel/Style/IXLFontBase.cs
#	ClosedXML/Excel/XLWorkbook.cs
#	ClosedXML/Excel/XLWorkbook_Save.cs
#	ClosedXML_Tests/ClosedXML_Tests.csproj

Merge branch 'last-before-netstandard2' into Pankraty-StylesRebased ...

# Conflicts:
#	ClosedXML/Excel/XLWorkbook_Save.cs

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