Fix regex for parsing cell formula. Fixes #40. Fixes #107. Closes #41.

Merge pull request #75 from pichardoSoftware/ExcelFunctions ...

Excel functions

Merge pull request #87 from igitur/add-support-for-multiple-pivot-tables ...

Support for multiple pivot tables

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

Optionally validate the workbook using OpenXmlValidator when saving it.

Merge pull request #80 from igitur/fix-vlookup-and-hlookup ...

Fix VLOOKUP and HLOOKUP when reference table is not at A1. Fixes #72.

Expose new Cells() function to iterate over cells, including unused cells inside range, but excluding unused cells outside range.

Create correct pivot caches with correct cache id for each pivot table. ...

TODO: Avoid duplicate pivot caches if separate pivot tables share same data range.

Fix VLOOKUP and HLOOKUP when reference table is not at A1. Fixes #72.

Merge pull request #69 from igitur/date-and-time-excel-functions ...

Implement all date and time functions

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

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

Updated Text Tests

Information Functions And Tests

Logical Functions Register and Some Information Functions

Implement all date and time functions

Apply https://closedxml.codeplex.com/SourceControl/network/forks/NickNack2020/ClosedXml/contribution/8268 : ...

Possibly fixes #63

Added XML encoder util. Will encode invalid XML characters based on
XML Spec http://www.w3.org/TR/REC-xml/#charsets

-Encode shared string on save
-Decoded shared strings on load

Quick fix only applied to shared strings,
could be other problematic areas in code

# Conflicts:
#	ClosedXML_Tests/ClosedXML_Tests.csproj
#	ClosedXML_Tests/Excel/Cells/XLCellTests.cs

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.

Don't hardcode Example project's output folder. Rather use subfolders of executing assembly's current directory. ...

Also use Path.Combine() instead of path +
This PR is also in preparation for a followup PR which will fix path issues on Linux.

Add test for worksheet header fix

Merge pull request #34 from igitur/autofilter-clear-shouldnt-throw-exception-if-disabled ...

Clearing AutoFilter shouldn't throw an exception

Clearing AutoFilter shouldn't throw an exception, even if no AutoFilter is enabled. It should just silently continue.

Implement VLOOKUP and HLOOKUP

Merge branch 'master' of https://github.com/ClosedXML/ClosedXML

Merge branch 'fix-datetime-bug-with-short-date-format' of https://github.com/igitur/ClosedXML into igitur-fix-datetime-bug-with-short-date-format

Fix XLColor equals method (#25) ...

* Use ToArgb() to compare equality of colors, in order to return TRUE when comparing RGB(FF,FF,FF) to White.
http://stackoverflow.com/questions/8146453/system-drawing-color-equality-operator-doesnt-treat-0xffffffff-as-color-white

* Add test for named color vs RGB

* Update bespoke unit tests files to remove duplicate font styles.

* Set substringo of rich text to Garamond font, instead of Broadway. Broadway probably isn't installed on the AppVeyor server. Garamond is a much more common pre-installed font.

* Disable different font to see if it affects the AppVeyor build.

* Use Courier font for rich text. Hopefully this one is installed on AppVeyor.

Parse dates with current culture (#9) ...

* Set default culture for DateAndTimeTests

* Don't use InvarianceCulture. Use the culture as set in current thread. Else date parsing might yield unexpected results

* Use OneTimeSetUp instead of SetUp.

Merge pull request #18 from igitur/text-function-fixes ...

Text function fixes

Use NUnit3 attribute: OneTimeSetUp instead of TestFixtureSetUp.