|  | <?xml version="1.0" encoding="utf-8"?> | 
|  | <Project ToolsVersion="12.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> | 
|  | <PropertyGroup> | 
|  | <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> | 
|  | <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> | 
|  | <ProductVersion>9.0.30729</ProductVersion> | 
|  | <SchemaVersion>2.0</SchemaVersion> | 
|  | <ProjectGuid>{E7BCEDE0-EADD-437B-86D5-49D192216948}</ProjectGuid> | 
|  | <OutputType>Library</OutputType> | 
|  | <AppDesignerFolder>Properties</AppDesignerFolder> | 
|  | <RootNamespace>EPPlusTest</RootNamespace> | 
|  | <AssemblyName>EPPlusTest</AssemblyName> | 
|  | <TargetFrameworkVersion>v4.5</TargetFrameworkVersion> | 
|  | <FileAlignment>512</FileAlignment> | 
|  | <ProjectTypeGuids>{3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids> | 
|  | <FileUpgradeFlags> | 
|  | </FileUpgradeFlags> | 
|  | <OldToolsVersion>3.5</OldToolsVersion> | 
|  | <UpgradeBackupLocation /> | 
|  | <PublishUrl>publish\</PublishUrl> | 
|  | <Install>true</Install> | 
|  | <InstallFrom>Disk</InstallFrom> | 
|  | <UpdateEnabled>false</UpdateEnabled> | 
|  | <UpdateMode>Foreground</UpdateMode> | 
|  | <UpdateInterval>7</UpdateInterval> | 
|  | <UpdateIntervalUnits>Days</UpdateIntervalUnits> | 
|  | <UpdatePeriodically>false</UpdatePeriodically> | 
|  | <UpdateRequired>false</UpdateRequired> | 
|  | <MapFileExtensions>true</MapFileExtensions> | 
|  | <ApplicationRevision>0</ApplicationRevision> | 
|  | <ApplicationVersion>1.0.0.%2a</ApplicationVersion> | 
|  | <IsWebBootstrapper>false</IsWebBootstrapper> | 
|  | <UseApplicationTrust>false</UseApplicationTrust> | 
|  | <BootstrapperEnabled>true</BootstrapperEnabled> | 
|  | <SolutionDir Condition="$(SolutionDir) == '' Or $(SolutionDir) == '*Undefined*'">..\</SolutionDir> | 
|  | <RestorePackages>true</RestorePackages> | 
|  | <TargetFrameworkProfile /> | 
|  | </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> | 
|  | <PlatformTarget>AnyCPU</PlatformTarget> | 
|  | <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet> | 
|  | <Prefer32Bit>false</Prefer32Bit> | 
|  | </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> | 
|  | <CodeAnalysisRuleSet>AllRules.ruleset</CodeAnalysisRuleSet> | 
|  | <PlatformTarget>x86</PlatformTarget> | 
|  | <Prefer32Bit>false</Prefer32Bit> | 
|  | </PropertyGroup> | 
|  | <PropertyGroup> | 
|  | <SignAssembly>true</SignAssembly> | 
|  | </PropertyGroup> | 
|  | <PropertyGroup> | 
|  | <AssemblyOriginatorKeyFile>EPPlusTest.snk</AssemblyOriginatorKeyFile> | 
|  | </PropertyGroup> | 
|  | <PropertyGroup Condition="'$(Configuration)|$(Platform)' == 'Release 4.0|AnyCPU'"> | 
|  | <OutputPath>bin\Release 4.0\</OutputPath> | 
|  | <Prefer32Bit>false</Prefer32Bit> | 
|  | </PropertyGroup> | 
|  | <ItemGroup> | 
|  | <Reference Include="Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" /> | 
|  | <Reference Include="Rhino.Mocks, Version=3.6.0.0, Culture=neutral, PublicKeyToken=0b3305902db7183f, processorArchitecture=MSIL"> | 
|  | <SpecificVersion>False</SpecificVersion> | 
|  | <HintPath>..\packages\RhinoMocks.3.6.1\lib\net\Rhino.Mocks.dll</HintPath> | 
|  | </Reference> | 
|  | <Reference Include="System" /> | 
|  | <Reference Include="System.configuration" /> | 
|  | <Reference Include="System.Core"> | 
|  | <RequiredTargetFramework>3.5</RequiredTargetFramework> | 
|  | </Reference> | 
|  | <Reference Include="System.Data" /> | 
|  | <Reference Include="System.Design" /> | 
|  | <Reference Include="System.Drawing" /> | 
|  | <Reference Include="System.Security" /> | 
|  | <Reference Include="System.Xml" /> | 
|  | <Reference Include="WindowsBase"> | 
|  | <RequiredTargetFramework>3.0</RequiredTargetFramework> | 
|  | </Reference> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <Compile Include="Address.cs" /> | 
|  | <Compile Include="Calculation.cs" /> | 
|  | <Compile Include="ConditionalFormatting\ConditionalFormatting.cs" /> | 
|  | <Compile Include="DataValidation\CustomValidationTests.cs" /> | 
|  | <Compile Include="DataValidation\DataValidationTests.cs" /> | 
|  | <Compile Include="DataValidation\DecimaDataValidationTests.cs" /> | 
|  | <Compile Include="DataValidation\ExcelTimeTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\CustomFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\DateTimeFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\DecimalFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\IntegerFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\ListFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\Formulas\TimeFormulaTests.cs" /> | 
|  | <Compile Include="DataValidation\IntegrationTests\IntegrationTests.cs" /> | 
|  | <Compile Include="DataValidation\ListDataValidationTests.cs" /> | 
|  | <Compile Include="DataValidation\RangeBaseTests.cs" /> | 
|  | <Compile Include="DataValidation\ValidationCollectionTests.cs" /> | 
|  | <Compile Include="DataValidation\ValidationTestBase.cs" /> | 
|  | <Compile Include="DTS_FailingTests.cs" /> | 
|  | <Compile Include="Encrypt.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\AddressTranslatorTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\CellReferenceProviderTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\ExcelAddressInfoTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\IndexToAddressTranslatorTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\NumericExpressionEvaluatorTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\RangeAddressFactoryTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\RangeAddressTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\RangesTest.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\ValueMatcherTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExcelUtilities\WildCardValueMatcherTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\ArgumentParserFactoryTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\ArgumentParsersImplementationsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\ArgumentParsersTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\CountIfsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\Database\ExcelDatabaseTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\Database\CriteriaTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\Database\RowMatcherTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\DateTimeFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\ExcelFunctionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\FunctionArgumentTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\InformationFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\LogicalFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\MathFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\NumberFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\RefAndLookup\LookupNavigatorTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\RefAndLookup\RefAndLookupTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\RefAndLookup\IndexTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\RefAndLookup\LookupNavigatorFactoryTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\SubtotalTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\SumIfsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\TextFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\Functions\TimeStringParserTests.cs" /> | 
|  | <Compile Include="FormulaParsing\Excel\OperatorsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\EnumerableExpressionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\ExcelAddressExpressionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\ExpressionCompilerTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\ExpressionConverterTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\ExpressionFactoryTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\ExpressionGraphBuilderTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\IntegerExpressionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\DecimalExpressionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ExpressionGraph\BooleanExpressionTests.cs" /> | 
|  | <Compile Include="FormulaParsing\FormulaParserTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BasicCalcTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\DateAndTimeFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\ExcelRanges\MathExcelRangeTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\ExcelRanges\TextExcelRangeTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\InformationFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\LogicalFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\MathFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\RefAndLookupTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\StringFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\SubtotalTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\TextFunctionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\BuiltInFunctions\DatabaseTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\ErrorHandling\SumTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\ExcelDataProviderTests\ExcelDataProviderIntegrationTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\FormulaParserTestBase.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\PrecedenceTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\CalcExtensionsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\ErrorHandling\FormulaErrorHandlingTestBase.cs" /> | 
|  | <Compile Include="FormulaParsing\IntegrationTests\OperatorsTests.cs" /> | 
|  | <Compile Include="FormulaParsing\LexicalAnalysis\NegationTests.cs" /> | 
|  | <Compile Include="FormulaParsing\LexicalAnalysis\SourceCodeTokenizerTests.cs" /> | 
|  | <Compile Include="FormulaParsing\LexicalAnalysis\SyntacticAnalyzerTests.cs" /> | 
|  | <Compile Include="FormulaParsing\LexicalAnalysis\TokenFactoryTests.cs" /> | 
|  | <Compile Include="FormulaParsing\NameValueProviderTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ParsingContextTests.cs" /> | 
|  | <Compile Include="FormulaParsing\ParsingScopesTest.cs" /> | 
|  | <Compile Include="FormulaParsing\ParsingScopeTests.cs" /> | 
|  | <Compile Include="FormulaParsing\TestHelpers\FunctionsHelper.cs" /> | 
|  | <Compile Include="Properties\AssemblyInfo.cs" /> | 
|  | <Compile Include="DrawingTest.cs" /> | 
|  | <Compile Include="Properties\Resources.Designer.cs"> | 
|  | <AutoGen>True</AutoGen> | 
|  | <DesignTime>True</DesignTime> | 
|  | <DependentUpon>Resources.resx</DependentUpon> | 
|  | </Compile> | 
|  | <Compile Include="ReadTemplate.cs" /> | 
|  | <Compile Include="TestBase.cs" /> | 
|  | <Compile Include="TestDTO.cs" /> | 
|  | <Compile Include="CellStoreTest.cs" /> | 
|  | <Compile Include="Issues.cs" /> | 
|  | <Compile Include="LoadFromCollectionTests.cs" /> | 
|  | <Compile Include="CommentsTest.cs" /> | 
|  | <Compile Include="Utils\AddressUtilityTests.cs" /> | 
|  | <Compile Include="Utils\GuardingTests.cs" /> | 
|  | <Compile Include="Utils\SqRefUtilityTests.cs" /> | 
|  | <Compile Include="VBA.cs" /> | 
|  | <Compile Include="WorkSheet.cs" /> | 
|  | <Compile Include="WorksheetsTests.cs" /> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <None Include="EPPlusTest.snk" /> | 
|  | <None Include="packages.config" /> | 
|  | <None Include="TestStart.orderedtest"> | 
|  | <CopyToOutputDirectory>Always</CopyToOutputDirectory> | 
|  | <SubType>Designer</SubType> | 
|  | </None> | 
|  | <EmbeddedResource Include="Resources\Vector Drawing.wmf" /> | 
|  | <EmbeddedResource Include="Resources\Vector Drawing2.wmf" /> | 
|  | <None Include="Workbooks\FormulaTest.xlsx"> | 
|  | <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> | 
|  | </None> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <EmbeddedResource Include="Properties\Resources.resx"> | 
|  | <Generator>ResXFileCodeGenerator</Generator> | 
|  | <LastGenOutput>Resources.Designer.cs</LastGenOutput> | 
|  | <SubType>Designer</SubType> | 
|  | </EmbeddedResource> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <BootstrapperPackage Include=".NETFramework,Version=v4.0"> | 
|  | <Visible>False</Visible> | 
|  | <ProductName>Microsoft .NET Framework 4 %28x86 and x64%29</ProductName> | 
|  | <Install>true</Install> | 
|  | </BootstrapperPackage> | 
|  | <BootstrapperPackage Include="Microsoft.Net.Client.3.5"> | 
|  | <Visible>False</Visible> | 
|  | <ProductName>.NET Framework 3.5 SP1 Client Profile</ProductName> | 
|  | <Install>false</Install> | 
|  | </BootstrapperPackage> | 
|  | <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1"> | 
|  | <Visible>False</Visible> | 
|  | <ProductName>.NET Framework 3.5 SP1</ProductName> | 
|  | <Install>false</Install> | 
|  | </BootstrapperPackage> | 
|  | <BootstrapperPackage Include="Microsoft.Windows.Installer.3.1"> | 
|  | <Visible>False</Visible> | 
|  | <ProductName>Windows Installer 3.1</ProductName> | 
|  | <Install>true</Install> | 
|  | </BootstrapperPackage> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <ProjectReference Include="..\EPPlus\EPPlus.csproj"> | 
|  | <Project>{7b288026-5502-4a39-bf41-77e086f3e4a3}</Project> | 
|  | <Name>EPPlus</Name> | 
|  | </ProjectReference> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <EmbeddedResource Include="Resources\BitmapImage.gif" /> | 
|  | </ItemGroup> | 
|  | <ItemGroup> | 
|  | <Content Include="Resources\Test1.jpg" /> | 
|  | </ItemGroup> | 
|  | <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" /> | 
|  | <Import Project="$(SolutionDir)\.nuget\nuget.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> |