diff --git a/ClosedXML/ClosedXML/ClosedXML.sln b/ClosedXML/ClosedXML/ClosedXML.sln
index e8a7f7d..307a9c7 100644
--- a/ClosedXML/ClosedXML/ClosedXML.sln
+++ b/ClosedXML/ClosedXML/ClosedXML.sln
@@ -4,6 +4,11 @@
 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML_Sandbox", "ClosedXML_Sandbox\ClosedXML_Sandbox.csproj", "{38B882F0-E6F2-45C5-9BE9-CDC27FBEB4AB}"
 EndProject
 Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{5C94E22C-85AA-48FD-B082-CF929FFC6C31}"
+	ProjectSection(SolutionItems) = preProject
+		ClosedXML.vsmdi = ClosedXML.vsmdi
+		Local.testsettings = Local.testsettings
+		TraceAndTestImpact.testsettings = TraceAndTestImpact.testsettings
+	EndProjectSection
 EndProject
 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML_Examples", "ClosedXML_Examples\ClosedXML_Examples.csproj", "{03A518D0-1CB7-488E-861C-C4E782B27A46}"
 EndProject
@@ -13,9 +18,11 @@
 EndProject
 Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML", "ClosedXML\ClosedXML.csproj", "{BD5E6BFE-E837-4A35-BCA9-39667D873A20}"
 EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ClosedXML_Tests", "ClosedXML_Tests\ClosedXML_Tests.csproj", "{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}"
+EndProject
 Global
 	GlobalSection(TeamFoundationVersionControl) = preSolution
-		SccNumberOfProjects = 6
+		SccNumberOfProjects = 7
 		SccEnterpriseProvider = {4CA58AB2-18FA-4F8D-95D4-32DDF27D184C}
 		SccTeamFoundationServer = https://tfs.codeplex.com/tfs/tfs09
 		SccLocalPath0 = .
@@ -34,6 +41,9 @@
 		SccProjectUniqueName5 = ClosedXML\\ClosedXML.csproj
 		SccProjectName5 = ClosedXML
 		SccLocalPath5 = ClosedXML
+		SccProjectUniqueName6 = ClosedXML_Tests\\ClosedXML_Tests.csproj
+		SccProjectName6 = ClosedXML_Tests
+		SccLocalPath6 = ClosedXML_Tests
 	EndGlobalSection
 	GlobalSection(TestCaseManagementSettings) = postSolution
 		CategoryFile = ClosedXML.vsmdi
@@ -129,6 +139,18 @@
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|x64.Build.0 = Release|x64
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|x86.ActiveCfg = Release|Any CPU
 		{BD5E6BFE-E837-4A35-BCA9-39667D873A20}.Release|x86.Build.0 = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|x64.ActiveCfg = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Debug|x86.ActiveCfg = Debug|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|Any CPU.Build.0 = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|Mixed Platforms.Build.0 = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|x64.ActiveCfg = Release|Any CPU
+		{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}.Release|x86.ActiveCfg = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE
diff --git a/ClosedXML/ClosedXML/ClosedXML.vsmdi b/ClosedXML/ClosedXML/ClosedXML.vsmdi
new file mode 100644
index 0000000..b93fcdf
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML.vsmdi
@@ -0,0 +1,6 @@
+﻿<?xml version="1.0" encoding="UTF-8"?>
+<TestLists xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <TestList name="Lists of Tests" id="8c43106b-9dc1-4907-a29f-aa66a61bf5b6">
+    <RunConfiguration id="b06e9cbc-e7b0-43ae-b994-09522c31b4e3" name="Local" storage="local.testsettings" type="Microsoft.VisualStudio.TestTools.Common.TestRunConfiguration, Microsoft.VisualStudio.QualityTools.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
+  </TestList>
+</TestLists>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs
index ae96970..14d713d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Collections;
 
-
 namespace ClosedXML.Excel
 {
     public enum XLCellValues { Text, Number, Boolean, DateTime, TimeSpan }
@@ -177,5 +173,8 @@
         IXLCell CopyTo(IXLCell target);
 
         String ValueCached { get; }
+
+        IXLRichString RichText { get; }
+        Boolean HasRichText { get; }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs
index b6b843c..ee0c3d5 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs
index 50140cf..0e5480a 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs
@@ -1,10 +1,10 @@
 ﻿using System;
+using System.Collections;
 using System.Collections.Generic;
+using System.Data;
 using System.Linq;
 using System.Text;
 using System.Text.RegularExpressions;
-using System.Collections;
-using System.Data;
 
 namespace ClosedXML.Excel
 {
@@ -22,6 +22,7 @@
                 style = new XLStyle(this, worksheet.Style);
             else
                 style = new XLStyle(this, defaultStyle);
+
             this.worksheet = worksheet;
         }
 
@@ -43,6 +44,7 @@
         public IXLCell SetValue<T>(T value)
         {
             FormulaA1 = String.Empty;
+            richText = null;
             if (value is String)
             {
                 cellValue = value.ToString();
@@ -264,7 +266,10 @@
                     }
                     else
                     {
-                        return cellValue;
+                        if (richText == null)
+                            return cellValue;
+                        else
+                            return richText.ToString();
                     }
                 }
             }
@@ -273,10 +278,27 @@
                 FormulaA1 = String.Empty;
                 if (!SetEnumerable(value))
                     if (!SetRange(value))
-                        SetValue(value);
+                        if (!SetRichText(value))
+                            SetValue(value);
             }
         }
 
+        private bool SetRichText(object value)
+        {
+            var asRichString = value as XLRichString;
+            if (asRichString == null)
+            {
+                return false;
+            }
+            else
+            {
+                richText = asRichString;
+                dataType = XLCellValues.Text;
+                return true;
+            }
+
+        }
+
         private Boolean SetRange(Object rangeObject)
         {
             var asRange = rangeObject as XLRangeBase;
@@ -586,7 +608,7 @@
         {
             FormulaA1 = String.Empty;
             String val = value.ToString();
-
+            richText = null;
             if (val.Length > 0)
             {
                 Double dTest;
@@ -705,6 +727,12 @@
             {
                 if (dataType != value)
                 {
+                    if (richText != null)
+                    {
+                        cellValue = richText.ToString();
+                        richText = null;
+                    }
+                    
                     if (cellValue.Length > 0)
                     {
                         if (value == XLCellValues.Boolean)
@@ -1151,12 +1179,14 @@
             this.cellValue = source.cellValue;
             this.dataType = source.dataType;
             this.FormulaR1C1 = source.FormulaR1C1;
+            richText = source.richText;
         }
 
         public IXLCell CopyFrom(IXLCell otherCell)
         {
             var source = otherCell as XLCell;
             cellValue = source.cellValue;
+            richText = source.richText;
             dataType = source.dataType;
             FormulaR1C1 = source.FormulaR1C1;
             style = new XLStyle(this, source.style);
@@ -1583,5 +1613,24 @@
         }
 
         public String ValueCached { get; internal set; }
+
+        XLRichString richText;
+        public IXLRichString RichText 
+        {
+            get
+            {
+                if (richText == null)
+                { 
+                    if (StringExtensions.IsNullOrWhiteSpace(cellValue))
+                        richText = new XLRichString(style.Font);
+                    else
+                        richText = new XLRichString(GetFormattedString(), style.Font);
+                    dataType = XLCellValues.Text;
+                }
+                return richText;
+            }
+        }
+
+        public Boolean HasRichText { get { return richText != null; } }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellCollection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellCollection.cs
index 5e4fe6a..10c9cb3 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellCollection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCellCollection.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs
index 60f1653..82c0468 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell_DotNetSpecific.cs
@@ -1,9 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.ComponentModel.DataAnnotations;
-using System.Reflection;
+using System.Linq;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs
index d7da5b0..af2fe0e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLChart.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLChart.cs
index 726e418..63af704 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLChart.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLChart.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLCharts.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLCharts.cs
index b42782d..2e21d09 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLCharts.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLCharts.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Collections.Generic;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLDrawing.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLDrawing.cs
index e09dda4..9220794 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLDrawing.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/IXLDrawing.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLChart.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLChart.cs
index d8324fc..6edee88 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLChart.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLChart.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLCharts.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLCharts.cs
index dfc94db..46ff4e0 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLCharts.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLCharts.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Collections.Generic;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLDrawing.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLDrawing.cs
index 379dcdb..96ae86c 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLDrawing.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Charts/XLDrawing.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs
index 25c60da..b34401e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs
index b30e5ae..d8ca025 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs
index d19b4be..487f02b 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnCollection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnCollection.cs
index 1651ca6..a4e72ab 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnCollection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnCollection.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnParameters.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnParameters.cs
index cee2cc2..9e6106e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnParameters.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumnParameters.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs
index c0f44e9..393f69f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperties.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperties.cs
index 95eb1b0..afdbff2 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperties.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperties.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperty.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperty.cs
index 261659e..f34e306 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperty.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/IXLCustomProperty.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperties.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperties.cs
index cae934b..98e98ac 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperties.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperties.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperty.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperty.cs
index d671aa4..66901d3 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperty.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/CustomProperties/XLCustomProperty.cs
@@ -1,7 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidation.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidation.cs
index 211c9d1..6e72cf9 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidation.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidation.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidations.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidations.cs
index 627910c..eb8aa6b 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidations.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLDataValidations.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLValidationCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLValidationCriteria.cs
index e954b9f..b5be419 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLValidationCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/IXLValidationCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidation.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidation.cs
index aab2010..1bf37bc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidation.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidation.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidations.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidations.cs
index 9c3531c..bb9be8e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidations.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDataValidations.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDateCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDateCriteria.cs
index 180fe05..35d88de 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDateCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDateCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Globalization;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDecimalCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDecimalCriteria.cs
index a15275b..02f1c5e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDecimalCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLDecimalCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTextLengthCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTextLengthCriteria.cs
index 9d553cd..6e35427 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTextLengthCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTextLengthCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
index 697ff6b..10b88f2 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLTimeCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLValidationCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLValidationCriteria.cs
index 1680b8f..6564298 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLValidationCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLValidationCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLWholeNumberCriteria.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLWholeNumberCriteria.cs
index 1db96fd..01c8dba 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLWholeNumberCriteria.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/DataValidation/XLWholeNumberCriteria.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/IXLHyperlinks.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/IXLHyperlinks.cs
index 4ce3a1b..2fd3b44 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/IXLHyperlinks.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/IXLHyperlinks.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Collections.Generic;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_Internal.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_Internal.cs
index d4000a5..25d6961 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_Internal.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_Internal.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_public.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_public.cs
index edd6d09..93e83ae 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_public.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlink_public.cs
@@ -1,7 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlinks.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlinks.cs
index 2cf6b9d..8d980da 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlinks.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Hyperlinks/XLHyperlinks.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Collections.Generic;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLOutline.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLOutline.cs
index 244929c..aae00ee 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLOutline.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLOutline.cs
@@ -1,8 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
+﻿
 namespace ClosedXML.Excel
 {
     public enum XLOutlineSummaryVLocation { Top, Bottom };
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetProtection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetProtection.cs
index 1620aa6..149ae06 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetProtection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetProtection.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetView.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetView.cs
index 5c55821..800593e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetView.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLSheetView.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLTheme.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLTheme.cs
index 6e760a1..abdb2b2 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLTheme.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLTheme.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
-
+﻿
 namespace ClosedXML.Excel
 {
     public interface IXLTheme
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
index a8c6061..2153929 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheetInternals.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheetInternals.cs
index 20d5c57..82a3e60 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheetInternals.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheetInternals.cs
@@ -1,8 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
+﻿
 namespace ClosedXML.Excel
 {
     internal interface IXLWorksheetInternals
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs
index a272302..3efba96 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs
index 18f12ef..8a7c605 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRange.cs
index 6bde0ef..a3a8279 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRange.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
index 92cd994..87f3b4c 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/XLNamedRanges.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs
index 475cc41..ffedbca 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs
index fc03d5b..589335f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs
index 4c58812..53865ec 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs
index 3ad8f3f..7105e1d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs
index e72d193..48b5816 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFItem.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFItem.cs
index 48fc77d..f046dff 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFItem.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFItem.cs
@@ -1,6 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
 using System.Text;
 
 namespace ClosedXML.Excel
@@ -37,7 +36,7 @@
 
         public IXLRichText AddText(String text, XLHFOccurrence occurrence)
         {
-            IXLRichText richText = new XLRichText(text);
+            IXLRichText richText = new XLRichText(text, XLWorkbook.DefaultStyle.Font);
 
             var hfText = new XLHFText(richText);
             if (occurrence == XLHFOccurrence.AllPages)
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFText.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFText.cs
index d53ab90..d4a078e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFText.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHFText.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHeaderFooter.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHeaderFooter.cs
index 15587bc..62ee0c9 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHeaderFooter.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLHeaderFooter.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLMargins.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLMargins.cs
index 8ba86ad..c2d90b9 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLMargins.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLMargins.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs
index 74192da..3c9b883 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPageSetup.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPrintAreas.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPrintAreas.cs
index a69efbf..797d2fc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPrintAreas.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/XLPrintAreas.cs
@@ -1,7 +1,5 @@
-﻿using System;
-using System.Collections.Generic;
+﻿using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
index f4ec080..89f8052 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs
index d2bf8b3..a194be7 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
index a892251..b7773ad 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Text.RegularExpressions;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs
index 40be9ed..cf7172e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs
index 74cd7a9..4a9e5ef 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs
index f91346c..db3fdc1 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs
index 1d7807b..2b7cb89 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs
index 095641b..d9476de 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElement.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElement.cs
index 226deba..e687bdc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElement.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElement.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElements.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElements.cs
index 13fc670..8d7c630 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElements.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/IXLSortElements.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElement.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElement.cs
index f06b2f6..6c17e2d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElement.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElement.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElements.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElements.cs
index 52288f4..a279032 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElements.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/Sort/XLSortElements.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
index 2316212..ec4afd8 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRange.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs
index 28fe738..5dd6914 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs
@@ -1,7 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs
index 2fd57d5..db6ae4a 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeParameters.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeParameters.cs
index 2d745f0..c9d2a8c 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeParameters.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeParameters.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs
index 6a69d45..2d3db1f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs
@@ -1,7 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs
index d9a4156..117534d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs
index cb847e3..d6b77ca 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichString.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichString.cs
index 7425c22..71c7b93 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichString.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichString.cs
@@ -1,14 +1,13 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
-namespace ClosedXML.Excel.RichText
+namespace ClosedXML.Excel
 {
-    public interface IXLRichString
+    public interface IXLRichString : IEnumerable<IXLRichText>
     {
         IXLRichText AddText(String text);
         IXLRichString Clear();
         IXLRichText Characters(Int32 index, Int32 length);
+        Int32 Count { get; }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichText.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichText.cs
index 70d11fa..ebec6d2 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichText.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/IXLRichText.cs
@@ -1,13 +1,11 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
     public interface IXLRichText: IXLFontBase, IEquatable<IXLRichText>
     {
         String Text { get; }
+        IXLRichText Apply(IXLFontBase font);
 
         IXLRichText SetBold(); IXLRichText SetBold(Boolean value);
         IXLRichText SetItalic(); IXLRichText SetItalic(Boolean value);
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichString.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichString.cs
index 6d390aa..cf46eae 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichString.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichString.cs
@@ -1,16 +1,29 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
 using System.Text;
 
-namespace ClosedXML.Excel.RichText
+namespace ClosedXML.Excel
 {
     internal class XLRichString: IXLRichString
     {
         List<IXLRichText> richTexts = new List<IXLRichText>();
+
+        IXLFontBase m_defaultFont;
+        public XLRichString(IXLFontBase defaultFont)
+        {
+            m_defaultFont = defaultFont;
+        }
+
+        public XLRichString(String text, IXLFontBase defaultFont)
+            :this(defaultFont)
+        {
+            AddText(text);
+        }
+
+        public Int32 Count { get { return richTexts.Count; } }
         public IXLRichText AddText(String text)
         {
-            var richText = new XLRichText(text);
+            var richText = new XLRichText(text, m_defaultFont);
             richTexts.Add(richText);
             return richText;
         }
@@ -41,6 +54,19 @@
                         var newRT = new XLRichText(rt.Text.Substring(0, startIndex + 1), rt);
                         newRichTexts.Add(newRT);
                     }
+
+                    if (rt.Text.Length - startIndex + 1 >= length)
+                    {
+                        var newRT = new XLRichText(rt.Text.Substring(startIndex, length), rt);
+                        newRichTexts.Add(newRT);
+
+                        if (rt.Text.Length > startIndex + length + 1)
+                        {
+                            newRichTexts.Add(new XLRichText(rt.Text.Substring(startIndex + length), rt));
+                        }
+                    }
+
+                    
                 }
                 else
                 {
@@ -51,5 +77,15 @@
             richTexts = newRichTexts;
             throw new NotImplementedException();
         }
+
+        public IEnumerator<IXLRichText> GetEnumerator()
+        {
+            return richTexts.GetEnumerator();
+        }
+
+        System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
+        {
+            return GetEnumerator();
+        }
     }
 }
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichText.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichText.cs
index 7474ebc..9c999a5 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichText.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/RichText/XLRichText.cs
@@ -1,35 +1,31 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
     internal class XLRichText: IXLRichText
     {
-        public XLRichText(String text)
-            : this(text, XLWorkbook.DefaultStyle.Font)
-        {
-           
-        }
 
-        public XLRichText(String text, IXLFontBase defaultFont)
+        public XLRichText(String text, IXLFontBase font)
         {
             Text = text;
-
-            Bold = defaultFont.Bold;
-            Italic = defaultFont.Italic;
-            Underline = defaultFont.Underline;
-            Strikethrough = defaultFont.Strikethrough;
-            VerticalAlignment = defaultFont.VerticalAlignment;
-            Shadow = defaultFont.Shadow;
-            FontSize = defaultFont.FontSize;
-            FontColor = new XLColor(defaultFont.FontColor);
-            FontName = defaultFont.FontName;
-            FontFamilyNumbering = defaultFont.FontFamilyNumbering;
+            Apply(font);
         }
 
         public String Text { get; private set; }
+        public IXLRichText Apply(IXLFontBase font)
+        { 
+            Bold = font.Bold;
+            Italic = font.Italic;
+            Underline = font.Underline;
+            Strikethrough = font.Strikethrough;
+            VerticalAlignment = font.VerticalAlignment;
+            Shadow = font.Shadow;
+            FontSize = font.FontSize;
+            FontColor = new XLColor(font.FontColor);
+            FontName = font.FontName;
+            FontFamilyNumbering = font.FontFamilyNumbering;
+            return this;
+        }
 
         public Boolean Bold { get; set; }
         public Boolean Italic { get; set; }
@@ -56,7 +52,8 @@
         public Boolean Equals(IXLRichText other)
         {
             return
-                   this.Bold.Equals(other.Bold)
+                    Text == other.Text
+                && this.Bold.Equals(other.Bold)
                 && this.Italic.Equals(other.Italic)
                 && this.Underline.Equals(other.Underline)
                 && this.Strikethrough.Equals(other.Strikethrough)
@@ -76,7 +73,8 @@
 
         public override int GetHashCode()
         {
-            return Bold.GetHashCode()
+            return Text.GetHashCode()
+                ^ Bold.GetHashCode()
                 ^ Italic.GetHashCode()
                 ^ (Int32)Underline
                 ^ Strikethrough.GetHashCode()
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs
index 46a181e..b3a68e8 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs
index 5430247..1f10648 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowCollection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowCollection.cs
index 109160d..ffc31d0 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowCollection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowCollection.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowParameters.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowParameters.cs
index dd5da99..d62ae0e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowParameters.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRowParameters.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs
index 52edcc1..0396135 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs
index a88bcf5..ca1f3de 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs
index 3b6c8ca..3e77109 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs
index 9acdf40..8a62eea 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs
index 57e846d..9134960 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs
index 98a0b13..9298ada 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs
index 1159ba0..5656674 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs
index 8ec1e60..9380887 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs
index 6d5f05c..47c8ad0 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFontBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFontBase.cs
index d15ce3e..b063afc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFontBase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFontBase.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
index aacf87e..73f36e2 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLNumberFormat.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLProtection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLProtection.cs
index 1b4732c..fd4578d 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLProtection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLProtection.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStyle.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStyle.cs
index a8b75f1..8472baf 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStyle.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStyle.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStylized.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStylized.cs
index 6e15733..91d973b 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStylized.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLStylized.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs
index 03b1835..888ba9f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLAlignment.cs
@@ -1,6 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
 using System.Text;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs
index bc21b53..b90a516 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs
@@ -1,8 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
 using System.Text;
-using System.Drawing;
 namespace ClosedXML.Excel
 {
     internal class XLBorder : IXLBorder
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs
index ac04541..1bbde61 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs
@@ -1,8 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
 using System.Text;
-using System.Drawing;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs
index dfb7174..7de6c40 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs
@@ -1,8 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
+using System.Text;
 using System.Windows.Forms;
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
index d474dc0..1cb2b21 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLNumberFormat.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLProtection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLProtection.cs
index 917c8aa..bd4ac6f 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLProtection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLProtection.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs
index 3cb5334..9b3aba4 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStyle.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStylizedContainer.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStylizedContainer.cs
index ae23c48..7802ba8 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStylizedContainer.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLStylizedContainer.cs
@@ -1,7 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Collections.Generic;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs
index 3275fe5..938512e 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTable.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableField.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableField.cs
index b7462e7..1adc144 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableField.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableField.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRow.cs
index 1390aa1..a69e520 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRow.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRow.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRows.cs
index ea423e0..07952dc 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTableRows.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTables.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTables.cs
index 5f88def..6c12d67 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTables.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/IXLTables.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
index 2d4cdfa..1c4cc46 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableField.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRow.cs
index 7dfd0a6..d809dae 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRow.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRow.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRows.cs
index 5a81e8e..6cdc423 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTableRows.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTables.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTables.cs
index 5a00793..fdd0bb8 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTables.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Tables/XLTables.cs
@@ -1,7 +1,5 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLOutline.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLOutline.cs
index 7bc72ac..f86e0b5 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLOutline.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLOutline.cs
@@ -1,8 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
+﻿
 namespace ClosedXML.Excel
 {
     internal class XLOutline:IXLOutline
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetProtection.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetProtection.cs
index 64b701d..a9cfc61 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetProtection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetProtection.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetView.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetView.cs
index a7524b3..7ad2e12 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetView.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLSheetView.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLTheme.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLTheme.cs
index 8748760..d6961b1 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLTheme.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLTheme.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Drawing;
-
+﻿
 namespace ClosedXML.Excel
 {
     internal class XLTheme: IXLTheme
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWSContentManager.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWSContentManager.cs
index 5b75803..ae9cc29 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWSContentManager.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWSContentManager.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using DocumentFormat.OpenXml;
 using DocumentFormat.OpenXml.Spreadsheet;
 
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
index 801b229..6169a21 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs
@@ -1,10 +1,7 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
 using System.IO;
-using System.Drawing;
+using System.Linq;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbookProperties.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbookProperties.cs
index 16c6b4d..b35f4b6 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbookProperties.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbookProperties.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs
index 72f5c59..8bef6fd 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs
@@ -1,19 +1,13 @@
-﻿using DocumentFormat.OpenXml.Packaging;
-using Ap = DocumentFormat.OpenXml.ExtendedProperties;
-using Vt = DocumentFormat.OpenXml.VariantTypes;
-using DocumentFormat.OpenXml;
-using DocumentFormat.OpenXml.Spreadsheet;
-using A = DocumentFormat.OpenXml.Drawing;
-using Xdr = DocumentFormat.OpenXml.Drawing.Spreadsheet;
-using C = DocumentFormat.OpenXml.Drawing.Charts;
-using Op = DocumentFormat.OpenXml.CustomProperties;
-
-using System;
+﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.IO;
 using System.Globalization;
+using System.IO;
+using System.Linq;
+using DocumentFormat.OpenXml;
+using DocumentFormat.OpenXml.Packaging;
+using DocumentFormat.OpenXml.Spreadsheet;
+using Ap = DocumentFormat.OpenXml.ExtendedProperties;
+using Op = DocumentFormat.OpenXml.CustomProperties;
 
 
 
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
index 9beeeee..4cabd79 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs
@@ -1,20 +1,15 @@
-﻿using DocumentFormat.OpenXml.Packaging;
-using Ap = DocumentFormat.OpenXml.ExtendedProperties;
-using Vt = DocumentFormat.OpenXml.VariantTypes;
+﻿using System;
+using System.Collections.Generic;
+using System.Globalization;
+using System.IO;
+using System.Linq;
 using DocumentFormat.OpenXml;
+using DocumentFormat.OpenXml.Packaging;
 using DocumentFormat.OpenXml.Spreadsheet;
 using A = DocumentFormat.OpenXml.Drawing;
-using Xdr = DocumentFormat.OpenXml.Drawing.Spreadsheet;
-using C = DocumentFormat.OpenXml.Drawing.Charts;
+using Ap = DocumentFormat.OpenXml.ExtendedProperties;
 using Op = DocumentFormat.OpenXml.CustomProperties;
-
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.IO;
-using System.Globalization;
-using DRW = System.Drawing;
+using Vt = DocumentFormat.OpenXml.VariantTypes;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
index c002922..f8684ca 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs
@@ -1,7 +1,6 @@
 ﻿using System;
 using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 
 namespace ClosedXML.Excel
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheetInternals.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheetInternals.cs
index c0d3442..f4dcbad 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheetInternals.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheetInternals.cs
@@ -1,8 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-
+﻿
 namespace ClosedXML.Excel
 {
     internal class XLWorksheetInternals: IXLWorksheetInternals
diff --git a/ClosedXML/ClosedXML/ClosedXML/Extensions.cs b/ClosedXML/ClosedXML/ClosedXML/Extensions.cs
index bad6ffa..2c327b6 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Extensions.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Extensions.cs
@@ -1,9 +1,9 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using System.Drawing;
 using System.Globalization;
+using System.Linq;
+using System.Text;
 
 [assembly: CLSCompliantAttribute(true)]
 namespace ClosedXML
diff --git a/ClosedXML/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs
index 150cbfb..cd1ffc0 100644
--- a/ClosedXML/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs
+++ b/ClosedXML/ClosedXML/ClosedXML/Properties/AssemblyInfo.cs
@@ -1,5 +1,4 @@
 ﻿using System.Reflection;
-using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
 // General Information about an assembly is controlled through the following 
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs
index 591a9f9..bfe9799 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/BasicTable.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs
index 4015536..43418ff 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCells.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs
index a80bce8..d3d6192 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnCollections.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Columns
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs
index 587de5b..49a50b3 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/ColumnSettings.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Columns
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs
index 5b747e2..bc14681 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/DeletingColumns.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs
index 19de03b..02d5e4c 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Columns/InsertColumns.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Columns
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs
index 6488243..5adac1e 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Creating/CreateFiles.cs
@@ -1,13 +1,9 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML_Examples.Styles;
-using ClosedXML_Examples.Columns;
-using ClosedXML_Examples.Rows;
+﻿using ClosedXML_Examples.Columns;
 using ClosedXML_Examples.Misc;
-using ClosedXML_Examples.Ranges;
 using ClosedXML_Examples.PageSetup;
+using ClosedXML_Examples.Ranges;
+using ClosedXML_Examples.Rows;
+using ClosedXML_Examples.Styles;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs
index cdaab92..40ecbbe 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Delete/RemoveRows.cs
@@ -1,11 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
-using ClosedXML_Examples.Rows;
 
 namespace ClosedXML_Examples.Delete
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/HelloWorld.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/HelloWorld.cs
index 8f8c993..5249a60 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/HelloWorld.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/HelloWorld.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
 namespace ClosedXML_Examples
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs
index e22e7f6..24693a7 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/ChangingBasicTable.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
+﻿using ClosedXML.Excel;
 
 
 namespace ClosedXML_Examples
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs
index 2b3ef6e..5c3f84b 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Loading/LoadFiles.cs
@@ -1,9 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
 using System.IO;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs
index 270f19a..46e57e7 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataSet.cs
@@ -1,11 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-
-using System.Drawing;
 using System.Data;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs
index 33a2372..1e9f946 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AddingDataTableAsWorksheet.cs
@@ -1,11 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-
-using System.Drawing;
 using System.Data;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs
index 7339ce2..2b6dff3 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AdjustToContents.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs
index 4532b08..25c77d4 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/AutoFilter.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs
index f9850b6..1bb0ad9 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/BlankCells.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs
index 5a7ab67..a90d208 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CellValues.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs
index 0865b79..ee1456f 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Collections.cs
@@ -1,11 +1,8 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-
-using System.Drawing;
 using System.Data;
+using System.Linq;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs
index 2fd3603..93c5ad7 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/CopyingWorksheets.cs
@@ -1,10 +1,5 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
+﻿using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs
index 43fb888..f626c8c 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataTypes.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs
index 4ecb1e0..d098981 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/DataValidation.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs
index a6948c1..84a0845 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Formulas.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs
index 58c36fb..5e84577 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/FreezePanes.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs
index b605355..aadfa35 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideSheets.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs
index a43a0b2..0f25028 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/HideUnhide.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs
index 8782c5f..18379e2 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Hyperlinks.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs
index def80d7..812a42f 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingData.cs
@@ -1,11 +1,8 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-
-using System.Drawing;
 using System.Data;
+using System.Linq;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs
index 963664e..f738263 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/InsertingTables.cs
@@ -1,11 +1,9 @@
 ﻿using System;
 using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
-using System.Data;
 using System.ComponentModel.DataAnnotations;
+using System.Data;
+using System.Linq;
+using ClosedXML.Excel;
 
 
 namespace ClosedXML_Examples.Misc
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs
index ff7d14d..a8c00aa 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/LambdaExpressions.cs
@@ -1,10 +1,6 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
+﻿using System.Linq;
 using ClosedXML;
+using ClosedXML.Excel;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs
index 2ea5444..87cb974 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeCells.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs
index bea1df4..45f5402 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MergeMoves.cs
@@ -1,10 +1,5 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
+﻿using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs
index bd8ea6a..6bf2151 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/MultipleSheets.cs
@@ -1,10 +1,6 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+﻿using System.Linq;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs
index 48a6230..d5b5432 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/Outline.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs
index 1ea0aca..1b226cd 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/SheetProtection.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs
index eca9b44..1a8bc80 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShiftingFormulas.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs
index ebf2e5c..3b9ba95 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/ShowCase.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs
index 586f1a6..09a2451 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/TabColors.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs
index c0c1805..35b9e18 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Misc/WorkbookProperties.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs
index 1849e9b..83167c1 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/ModifyFiles.cs
@@ -1,14 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML_Examples.Delete;
-using ClosedXML_Examples.Styles;
-using ClosedXML_Examples.Columns;
-using ClosedXML_Examples.Rows;
-using ClosedXML_Examples.Misc;
-using ClosedXML_Examples.Ranges;
-using ClosedXML_Examples.PageSetup;
+﻿using ClosedXML_Examples.Delete;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs
index d8b3798..b8111c5 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/HeaderFooters.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs
index b17df3a..926ee82 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Margins.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs
index d81e131..3ae9870 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Page.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs
index 6ebdaec..84cc971 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/SheetTab.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs
index 9a5a985..ec4f7b9 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/Sheets.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs
index 0fd6613..39ac3ec 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/PageSetup/TwoPages.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.PageSetup
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs
index 603ad56..982cd31 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Program.cs
@@ -1,14 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML_Examples.Styles;
-using ClosedXML_Examples.Columns;
-using ClosedXML_Examples.Rows;
-using ClosedXML_Examples.Misc;
-using ClosedXML_Examples.Ranges;
-using ClosedXML_Examples.PageSetup;
-
+﻿
 namespace ClosedXML_Examples
 {
     public class Program
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Properties/AssemblyInfo.cs
index d492c06..a812387 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Properties/AssemblyInfo.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Properties/AssemblyInfo.cs
@@ -1,5 +1,4 @@
 ﻿using System.Reflection;
-using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
 // General Information about an assembly is controlled through the following 
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs
index 4901484..2aefef4 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ClearingRanges.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Ranges
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs
index 5147fc5..4ceadb5 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/CopyingRanges.cs
@@ -1,10 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
-using ClosedXML;
+﻿using ClosedXML.Excel;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs
index 6592258..28b8761 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DefiningRanges.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Ranges
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs
index 2a06dc3..10e743a 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/DeletingRanges.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Ranges
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs
index 4a5e6a2..d10959d 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingColumns.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs
index 04de147..467f083 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/InsertingDeletingRows.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs
index 9cfdbec..516c2ee 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs
index 02e6e7d..2c401bb 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/NamedRanges.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs
index 29be11a..4e7ab7d 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/ShiftingRanges.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
+﻿using ClosedXML.Excel;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs
index 043601a..69393cf 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/SortExample.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs
index da4180b..8c1c5f8 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/Sorting.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Misc
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs
index d84eeb4..a16a332 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRanges.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
+﻿using ClosedXML.Excel;
 
 
 namespace ClosedXML_Examples
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs
index 3a2bf6e..b9978c7 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/TransposeRangesPlus.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using System.Drawing;
+﻿using ClosedXML.Excel;
 
 
 namespace ClosedXML_Examples
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs
index bbdecf1..104761f 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/UsingTables.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Ranges
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs
index c9be41b..2da6924 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/InsertRows.cs
@@ -1,10 +1,7 @@
 ﻿using System;
-using System.Collections.Generic;
 using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Rows
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs
index f029b64..c5e9529 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCells.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs
index 61588e5..3fb13a1 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowCollections.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Rows
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs
index fe093f8..bcdc3a8 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Rows/RowSettings.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
-using System.Drawing;
 
 namespace ClosedXML_Examples.Rows
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs
index 24dba30..65b345d 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/StyleExamples.cs
@@ -1,9 +1,4 @@
-﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
-using ClosedXML_Examples.Styles;
+﻿using ClosedXML_Examples.Styles;
 
 namespace ClosedXML_Examples
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs
index 5cc6858..a2c4a6c 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/DefaultStyles.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs
index 96cc49f..3da077e 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleAlignment.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
 
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs
index e2909e4..5ba43c1 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleBorder.cs
@@ -1,10 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 
 using ClosedXML.Excel;
-using System.Drawing;
 
 namespace ClosedXML_Examples.Styles
 {
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs
index 837a37f..684cbf3 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFill.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs
index 49c0e88..33160d2 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleFont.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs
index b0fcf26..7360879 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleNumberFormat.cs
@@ -1,7 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs
index f2a144c..9eddc22 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleRowsColumns.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs
index 0f12cbc..5092633 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/StyleWorksheet.cs
@@ -1,9 +1,5 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
 using ClosedXML.Excel;
-using System.Drawing;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs
index 34705ec..aa5b604 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Styles/UsingColors.cs
@@ -1,9 +1,6 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using ClosedXML.Excel;
 using System.Drawing;
+using ClosedXML.Excel;
 
 
 namespace ClosedXML_Examples.Styles
diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs b/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs
index 436ad8c..76ec6eb 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Net3.5/Excel/Cells/XLCell_DotNetSpecific.cs
@@ -1,8 +1,4 @@
 ﻿using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Reflection;
 
 
 namespace ClosedXML.Excel
diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML/ClosedXML_Net3.5/Properties/AssemblyInfo.cs
index db68370..ea1211b 100644
--- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/Properties/AssemblyInfo.cs
+++ b/ClosedXML/ClosedXML/ClosedXML_Net3.5/Properties/AssemblyInfo.cs
@@ -1,5 +1,4 @@
 ﻿using System.Reflection;
-using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
 // General Information about an assembly is controlled through the following 
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj
new file mode 100644
index 0000000..f0a28cb
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj
@@ -0,0 +1,79 @@
+﻿<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <PropertyGroup>
+    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+    <ProductVersion>
+    </ProductVersion>
+    <SchemaVersion>2.0</SchemaVersion>
+    <ProjectGuid>{09B066ED-E4A7-4545-A1A4-FF03DD524BDF}</ProjectGuid>
+    <OutputType>Library</OutputType>
+    <AppDesignerFolder>Properties</AppDesignerFolder>
+    <RootNamespace>ClosedXML_Tests</RootNamespace>
+    <AssemblyName>ClosedXML_Tests</AssemblyName>
+    <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
+    <FileAlignment>512</FileAlignment>
+    <ProjectTypeGuids>{3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
+    <SccProjectName>SAK</SccProjectName>
+    <SccLocalPath>SAK</SccLocalPath>
+    <SccAuxPath>SAK</SccAuxPath>
+    <SccProvider>SAK</SccProvider>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+    <DebugSymbols>true</DebugSymbols>
+    <DebugType>full</DebugType>
+    <Optimize>false</Optimize>
+    <OutputPath>bin\Debug\</OutputPath>
+    <DefineConstants>DEBUG;TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+    <DebugType>pdbonly</DebugType>
+    <Optimize>true</Optimize>
+    <OutputPath>bin\Release\</OutputPath>
+    <DefineConstants>TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <ItemGroup>
+    <Reference Include="DocumentFormat.OpenXml, Version=2.0.5022.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL" />
+    <Reference Include="Microsoft.CSharp" />
+    <Reference Include="Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" />
+    <Reference Include="System" />
+    <Reference Include="System.ComponentModel.DataAnnotations" />
+    <Reference Include="System.Core">
+      <RequiredTargetFramework>3.5</RequiredTargetFramework>
+    </Reference>
+    <Reference Include="System.Data" />
+    <Reference Include="System.Data.DataSetExtensions" />
+    <Reference Include="System.Drawing" />
+    <Reference Include="System.Windows.Forms" />
+    <Reference Include="System.Xml" />
+    <Reference Include="System.Xml.Linq" />
+    <Reference Include="WindowsBase" />
+  </ItemGroup>
+  <ItemGroup>
+    <CodeAnalysisDependentAssemblyPaths Condition=" '$(VS100COMNTOOLS)' != '' " Include="$(VS100COMNTOOLS)..\IDE\PrivateAssemblies">
+      <Visible>False</Visible>
+    </CodeAnalysisDependentAssemblyPaths>
+  </ItemGroup>
+  <ItemGroup>
+    <Compile Include="Properties\AssemblyInfo.cs" />
+    <Compile Include="XLRichStringTest.cs" />
+  </ItemGroup>
+  <ItemGroup>
+    <ProjectReference Include="..\ClosedXML\ClosedXML.csproj">
+      <Project>{BD5E6BFE-E837-4A35-BCA9-39667D873A20}</Project>
+      <Name>ClosedXML</Name>
+    </ProjectReference>
+  </ItemGroup>
+  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
+  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
+       Other similar extension points exist, see Microsoft.Common.targets.
+  <Target Name="BeforeBuild">
+  </Target>
+  <Target Name="AfterBuild">
+  </Target>
+  -->
+</Project>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj.vspscc b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj.vspscc
new file mode 100644
index 0000000..feffdec
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/ClosedXML_Tests.csproj.vspscc
@@ -0,0 +1,10 @@
+﻿""
+{
+"FILE_VERSION" = "9237"
+"ENLISTMENT_CHOICE" = "NEVER"
+"PROJECT_FILE_RELATIVE_PATH" = ""
+"NUMBER_OF_EXCLUDED_FILES" = "0"
+"ORIGINAL_PROJECT_FILE_PATH" = ""
+"NUMBER_OF_NESTED_PROJECTS" = "0"
+"SOURCE_CONTROL_SETTINGS_PROVIDER" = "PROVIDER"
+}
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/Properties/AssemblyInfo.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..312c5ba
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/Properties/AssemblyInfo.cs
@@ -0,0 +1,34 @@
+﻿using System.Reflection;
+using System.Runtime.InteropServices;
+
+// General Information about an assembly is controlled through the following 
+// set of attributes. Change these attribute values to modify the information
+// associated with an assembly.
+[assembly: AssemblyTitle("ClosedXML_Tests")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("Microsoft")]
+[assembly: AssemblyProduct("ClosedXML_Tests")]
+[assembly: AssemblyCopyright("Copyright © Microsoft 2011")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// Setting ComVisible to false makes the types in this assembly not visible 
+// to COM components.  If you need to access a type in this assembly from 
+// COM, set the ComVisible attribute to true on that type.
+[assembly: ComVisible(false)]
+
+// The following GUID is for the ID of the typelib if this project is exposed to COM
+[assembly: Guid("a16b867e-6b00-4ccc-a368-c9f9b14e0e6a")]
+
+// Version information for an assembly consists of the following four values:
+//
+//      Major Version
+//      Minor Version 
+//      Build Number
+//      Revision
+//
+// You can specify all the values or you can default the Build and Revision Numbers 
+// by using the '*' as shown below:
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/ClosedXML/ClosedXML/ClosedXML_Tests/XLRichStringTest.cs b/ClosedXML/ClosedXML/ClosedXML_Tests/XLRichStringTest.cs
new file mode 100644
index 0000000..26e644b
--- /dev/null
+++ b/ClosedXML/ClosedXML/ClosedXML_Tests/XLRichStringTest.cs
@@ -0,0 +1,278 @@
+﻿using ClosedXML.Excel;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using System.Linq;
+using System;
+
+namespace ClosedXML_Tests
+{
+    
+    
+    /// <summary>
+    ///This is a test class for XLRichStringTest and is intended
+    ///to contain all XLRichStringTest Unit Tests
+    ///</summary>
+    [TestClass()]
+    public class XLRichStringTest
+    {
+
+
+        private TestContext testContextInstance;
+
+        /// <summary>
+        ///Gets or sets the test context which provides
+        ///information about and functionality for the current test run.
+        ///</summary>
+        public TestContext TestContext
+        {
+            get
+            {
+                return testContextInstance;
+            }
+            set
+            {
+                testContextInstance = value;
+            }
+        }
+
+        #region Additional test attributes
+        // 
+        //You can use the following additional attributes as you write your tests:
+        //
+        //Use ClassInitialize to run code before running the first test in the class
+        //[ClassInitialize()]
+        //public static void MyClassInitialize(TestContext testContext)
+        //{
+        //}
+        //
+        //Use ClassCleanup to run code after all tests in a class have run
+        //[ClassCleanup()]
+        //public static void MyClassCleanup()
+        //{
+        //}
+        //
+        //Use TestInitialize to run code before running each test
+        //[TestInitialize()]
+        //public void MyTestInitialize()
+        //{
+        //}
+        //
+        //Use TestCleanup to run code after each test has run
+        //[TestCleanup()]
+        //public void MyTestCleanup()
+        //{
+        //}
+        //
+        #endregion
+
+
+        /// <summary>
+        ///A test for ToString
+        ///</summary>
+        [TestMethod()]
+        public void ToStringTest()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var richString = ws.Cell(1, 1).RichText;
+            
+            richString.AddText("Hello");
+            richString.AddText(" ");
+            richString.AddText("World");
+            string expected = "Hello World";
+            string actual = richString.ToString();
+            Assert.AreEqual(expected, actual);
+
+            richString.AddText("!");
+            expected = "Hello World!";
+            actual = richString.ToString();
+            Assert.AreEqual(expected, actual);
+
+            richString.Clear();
+            expected = String.Empty;
+            actual = richString.ToString();
+            Assert.AreEqual(expected, actual);
+        }
+
+        /// <summary>
+        ///A test for AddText
+        ///</summary>
+        [TestMethod()]
+        public void AddTextTest1()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var cell = ws.Cell(1, 1);
+            var richString = cell.RichText;
+
+            string text = "Hello";
+            richString.AddText(text).SetBold().SetFontColor(XLColor.Red);
+            
+            Assert.AreEqual(cell.GetString(), text);
+            Assert.AreEqual(cell.RichText.First().Bold, true);
+            Assert.AreEqual(cell.RichText.First().FontColor, XLColor.Red);
+
+            Assert.AreEqual(1, richString.Count);
+
+            richString.AddText("World");
+            Assert.AreEqual(richString.First().Text, text, "Item in collection is not the same as the one returned");
+        }
+
+        [TestMethod()]
+        public void AddTextTest2()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var cell = ws.Cell(1, 1);
+            Int32 number = 123;
+
+            cell.SetValue(number).Style
+                .Font.SetBold()
+                .Font.SetFontColor(XLColor.Red);
+            
+            string text = number.ToString();
+
+            Assert.AreEqual(cell.RichText.ToString(), text);
+            Assert.AreEqual(cell.RichText.First().Bold, true);
+            Assert.AreEqual(cell.RichText.First().FontColor, XLColor.Red);
+
+            Assert.AreEqual(1, cell.RichText.Count);
+
+            cell.RichText.AddText("World");
+            Assert.AreEqual(cell.RichText.First().Text, text, "Item in collection is not the same as the one returned");
+        }
+
+        [TestMethod()]
+        public void AddTextTest3()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var cell = ws.Cell(1, 1);
+            Int32 number = 123;
+            cell.Value = number;
+            cell.Style
+                .Font.SetBold()
+                .Font.SetFontColor(XLColor.Red);
+
+            string text = number.ToString();
+
+            Assert.AreEqual(cell.RichText.ToString(), text);
+            Assert.AreEqual(cell.RichText.First().Bold, true);
+            Assert.AreEqual(cell.RichText.First().FontColor, XLColor.Red);
+
+            Assert.AreEqual(1, cell.RichText.Count);
+
+            cell.RichText.AddText("World");
+            Assert.AreEqual(cell.RichText.First().Text, text, "Item in collection is not the same as the one returned");
+        }
+
+        [TestMethod()]
+        public void HasRichTextTest1()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var cell = ws.Cell(1, 1);
+            cell.RichText.AddText("123");
+
+            Assert.AreEqual(true, cell.HasRichText);
+
+            cell.DataType = XLCellValues.Text;
+
+            Assert.AreEqual(true, cell.HasRichText);
+
+            cell.DataType = XLCellValues.Number;
+
+            Assert.AreEqual(false, cell.HasRichText);
+
+            cell.RichText.AddText("123");
+
+            Assert.AreEqual(true, cell.HasRichText);
+
+            cell.Value = 123;
+
+            Assert.AreEqual(false, cell.HasRichText);
+
+            cell.RichText.AddText("123");
+
+            Assert.AreEqual(true, cell.HasRichText);
+
+            cell.SetValue("123");
+
+            Assert.AreEqual(false, cell.HasRichText);
+
+        }
+
+        [TestMethod()]
+        public void AccessRichTextTest1()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var cell = ws.Cell(1, 1);
+            cell.RichText.AddText("12");
+            cell.DataType = XLCellValues.Number;
+            
+            Assert.AreEqual(12.0, cell.GetDouble());
+            
+            var richText = cell.RichText;
+
+            Assert.AreEqual("12", richText.ToString());
+
+            richText.AddText("34");
+
+            Assert.AreEqual("1234", cell.GetString());
+
+            Assert.AreEqual(XLCellValues.Text, cell.DataType);
+
+            cell.DataType = XLCellValues.Number;
+
+            Assert.AreEqual(1234.0, cell.GetDouble());
+
+        }
+
+        /// <summary>
+        ///A test for Characters
+        ///</summary>
+        [TestMethod()]
+        public void CharactersTest()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var richString = ws.Cell(1, 1).RichText;
+
+            int index = 0; // TODO: Initialize to an appropriate value
+            int length = 0; // TODO: Initialize to an appropriate value
+            IXLRichText expected = null; // TODO: Initialize to an appropriate value
+            IXLRichText actual;
+            actual = richString.Characters(index, length);
+            Assert.AreEqual(expected, actual);
+            Assert.Inconclusive("Verify the correctness of this test method.");
+        }
+
+        /// <summary>
+        ///A test for Clear
+        ///</summary>
+        [TestMethod()]
+        public void ClearTest()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var richString = ws.Cell(1, 1).RichText;
+
+            richString.AddText("Hello");
+            richString.AddText(" ");
+            richString.AddText("World!");
+            
+            richString.Clear();
+            String expected = String.Empty;
+            String actual = richString.ToString();
+            Assert.AreEqual(expected, actual);
+
+            Assert.AreEqual(0, richString.Count);
+        }
+
+        [TestMethod()]
+        public void CountTest()
+        {
+            var ws = new XLWorkbook().Worksheets.Add("Sheet1");
+            var richString = ws.Cell(1, 1).RichText;
+
+            richString.AddText("Hello");
+            richString.AddText(" ");
+            richString.AddText("World!");
+
+            Assert.AreEqual(3, richString.Count);
+        }
+
+    }
+}
diff --git a/ClosedXML/ClosedXML/Local.testsettings b/ClosedXML/ClosedXML/Local.testsettings
new file mode 100644
index 0000000..2101321
--- /dev/null
+++ b/ClosedXML/ClosedXML/Local.testsettings
@@ -0,0 +1,10 @@
+﻿<?xml version="1.0" encoding="UTF-8"?>
+<TestSettings name="Local" id="b06e9cbc-e7b0-43ae-b994-09522c31b4e3" xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <Description>These are default test settings for a local test run.</Description>
+  <Deployment enabled="false" />
+  <Execution>
+    <TestTypeSpecific />
+    <AgentRule name="Execution Agents">
+    </AgentRule>
+  </Execution>
+</TestSettings>
\ No newline at end of file
diff --git a/ClosedXML/ClosedXML/TraceAndTestImpact.testsettings b/ClosedXML/ClosedXML/TraceAndTestImpact.testsettings
new file mode 100644
index 0000000..91d9b38
--- /dev/null
+++ b/ClosedXML/ClosedXML/TraceAndTestImpact.testsettings
@@ -0,0 +1,19 @@
+﻿<?xml version="1.0" encoding="UTF-8"?>
+<TestSettings name="Trace and Test Impact" id="c883eeaf-64f7-4d2b-bf93-87a6a080cffa" xmlns="http://microsoft.com/schemas/VisualStudio/TeamTest/2010">
+  <Description>These are test settings for Trace and Test Impact.</Description>
+  <Execution>
+    <TestTypeSpecific />
+    <AgentRule name="Execution Agents">
+      <DataCollectors>
+        <DataCollector uri="datacollector://microsoft/SystemInfo/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TestTools.DataCollection.SystemInfo.SystemInfoDataCollector, Microsoft.VisualStudio.TestTools.DataCollection.SystemInfo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="System Information">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/HttpProxy/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.HttpProxyCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="ASP.NET Client Proxy for IntelliTrace and Test Impact">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/TestImpact/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.TestImpactDataCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="Test Impact">
+        </DataCollector>
+        <DataCollector uri="datacollector://microsoft/TraceDebugger/1.0" assemblyQualifiedName="Microsoft.VisualStudio.TraceCollector.TraceDebuggerDataCollector, Microsoft.VisualStudio.TraceCollector, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" friendlyName="IntelliTrace">
+        </DataCollector>
+      </DataCollectors>
+    </AgentRule>
+  </Execution>
+</TestSettings>
\ No newline at end of file
