Merge branch 'FixTestsForSwedishCulture' of https://git01.codeplex.com/forks/albinsunnanbo/closedxml into AlbinSunnanbo/closedxml

Don't include empty cells

Fix time zone issue in tests

Updated example files, set applyNumberFormat=1 and applyAlignment=1 ...

Made example data match updated code in
previous commit:
> Hash: 015fdc8
> Message: Set ApplyNumberFormat and ApplyAlignment to true

To make sure only the specified fileds were updated I made a small program (source code below) to manipulate existing files
---------------------------------------------------
using System;
using System.IO;
using System.IO.Compression;
using System.Linq;

namespace ZipMod
{
    class Program
    {
        static void Main(string[] args)
        {
            Directory.SetCurrentDirectory(@"C:\Git\closedxml\ClosedXML\ClosedXML\ClosedXML_Tests\Resource");
            foreach (var excelFile in Directory.EnumerateFiles(".", "*.xlsx", SearchOption.AllDirectories)
                .Where(f => !f.Contains("svnbridge"))) // Skip svnbridge files since some are corrupt
            {
                Console.WriteLine(excelFile);
                using (FileStream zipToOpen = new FileStream(excelFile, FileMode.Open))
                {
                    using (ZipArchive archive = new ZipArchive(zipToOpen, ZipArchiveMode.Update))
                    {
                        ZipArchiveEntry stylesEntry = archive.GetEntry("xl/styles.xml");
                        string content;
                        using (StreamReader reader = new StreamReader(stylesEntry.Open()))
                        {
                            content = reader.ReadToEnd();
                        }
                        content = content.Replace("applyNumberFormat=\"0\"", "applyNumberFormat=\"1\"").Replace("applyAlignment=\"0\"", "applyAlignment=\"1\"");
                        using (StreamWriter writer = new StreamWriter(stylesEntry.Open()))
                        {
                            writer.BaseStream.Seek(0, SeekOrigin.Begin);
                            writer.BaseStream.SetLength(0); // Clear
                            writer.Write(content);
                        }
                    }
                }
            }

            Console.WriteLine("Done");
            Console.ReadKey();
        }
    }
}
---------------------------------------------------
Sorry for the excessive commit message

Compare two streams using strings to overcome some issues where stream lengths differed while the content was equal

Add NuGet packages folder to .gitignore for convenience

Properly dispose the fonts in the fontCache

Set culture to en-US to pass the tests DataTypes, Dollar and Fixed on a computer with the sv-SE locale ...

note: sv-SE has "," as decimal separator, " " as thousands separator and put CurrencySymbol after the digits, not before.

Add Remove and RemoveAll methods for conditional formats.

Fix issue when changing a table column names

Set ApplyNumberFormat and ApplyAlignment to true

fixed comments formatting error

Added IsBlank

Group conditional formatting for same ranges

Update IF function to support 2 parameters

Fix issue with RangeUsed including styles

Load drawing colors with the format "name [index]"

Fix Left, Right, and Mid functions for empty strings

Merge branch 'NickNack2020/ClosedXml'

Update Adjust to contents (gotta love doubles)

Bump version

Made sure Conditional Format formulas are converted as invariant culture.

Update GetColumnLetterFromNumber function

Merge branch 'AdjustToContentsFix' of https://git01.codeplex.com/forks/nicknack2020/closedxml into NickNack2020/ClosedXml

Fix for https://closedxml.codeplex.com/workitem/9022 invalid sequence on MAX formula

Fix for AdjustToContents so that it is threadsafe

Added check back in for when row and col position are passed in as strings

Making XLHelper ThreadSafe

ToStringFix

Added locking to static dictionaries in XLColor_static class