﻿using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace EPPlusTest.FormulaParsing.IntegrationTests.ErrorHandling
{
	/// <summary>
	/// Summary description for SumTests
	/// </summary>
	[TestClass, Ignore]
	public class SumTests : FormulaErrorHandlingTestBase
	{
		[TestInitialize]
		public void ClassInitialize()
		{
			BaseInitialize();
		}

		[TestCleanup]
		public void ClassCleanup()
		{
			BaseCleanup();
		}

		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;
			}
		}
		[TestMethod]
		public void SingleCell()
		{
			Assert.AreEqual(3d, Worksheet.Cells["B9"].Value);
		}

		[TestMethod]
		public void MultiCell()
		{
			Assert.AreEqual(40d, Worksheet.Cells["C9"].Value);
		}

		[TestMethod]
		public void Name()
		{
			Assert.AreEqual(10d, Worksheet.Cells["E9"].Value);
		}

		[TestMethod]
		public void ReferenceError()
		{
			Assert.AreEqual("#REF!", Worksheet.Cells["H9"].Value.ToString());
		}

		[TestMethod]
		public void NameOnOtherSheet()
		{
			Assert.AreEqual(130d, Worksheet.Cells["I9"].Value);
		}

		[TestMethod]
		public void ArrayInclText()
		{
			Assert.AreEqual(7d, Worksheet.Cells["J9"].Value);
		}

		//[TestMethod]
		//public void NameError()
		//{
		//    Assert.AreEqual("#NAME?", Worksheet.Cells["L9"].Value);
		//}

		//[TestMethod]
		//public void DivByZeroError()
		//{
		//    Assert.AreEqual("#DIV/0!", Worksheet.Cells["M9"].Value);
		//}
	}
}
