|  | using System; | 
|  | using System.Text; | 
|  | using System.Collections.Generic; | 
|  | using System.Linq; | 
|  | using Microsoft.VisualStudio.TestTools.UnitTesting; | 
|  | using OfficeOpenXml.FormulaParsing; | 
|  | using Rhino.Mocks; | 
|  |  | 
|  | namespace EPPlusTest.FormulaParsing | 
|  | { | 
|  | [TestClass] | 
|  | public class NameValueProviderTests | 
|  | { | 
|  | //private ExcelDataProvider _excelDataProvider; | 
|  |  | 
|  | //[TestInitialize] | 
|  | //public void Setup() | 
|  | //{ | 
|  | //    _excelDataProvider = MockRepository.GenerateMock<ExcelDataProvider>(); | 
|  | //} | 
|  |  | 
|  | //[TestMethod] | 
|  | //public void IsNamedValueShouldReturnTrueIfKeyIsANamedValue() | 
|  | //{ | 
|  | //    var dict = new Dictionary<string, object>(); | 
|  | //    dict.Add("A", "B"); | 
|  | //    _excelDataProvider.Stub(x => x.GetWorkbookNameValues()) | 
|  | //        .Return(dict); | 
|  | //    var nameValueProvider = new EpplusNameValueProvider(_excelDataProvider); | 
|  |  | 
|  | //    var result = nameValueProvider.IsNamedValue("A"); | 
|  | //    Assert.IsTrue(result); | 
|  | //} | 
|  |  | 
|  | //[TestMethod] | 
|  | //public void IsNamedValueShouldReturnFalseIfKeyIsNotANamedValue() | 
|  | //{ | 
|  | //    var dict = new Dictionary<string, object>(); | 
|  | //    dict.Add("A", "B"); | 
|  | //    _excelDataProvider.Stub(x => x.GetWorkbookNameValues()) | 
|  | //        .Return(dict); | 
|  | //    var nameValueProvider = new EpplusNameValueProvider(_excelDataProvider); | 
|  |  | 
|  | //    var result = nameValueProvider.IsNamedValue("C"); | 
|  | //    Assert.IsFalse(result); | 
|  | //} | 
|  |  | 
|  | //[TestMethod] | 
|  | //public void GetNamedValueShouldReturnCorrectValueIfKeyExists() | 
|  | //{ | 
|  | //    var dict = new Dictionary<string, object>(); | 
|  | //    dict.Add("A", "B"); | 
|  | //    _excelDataProvider.Stub(x => x.GetWorkbookNameValues()) | 
|  | //        .Return(dict); | 
|  | //    var nameValueProvider = new EpplusNameValueProvider(_excelDataProvider); | 
|  |  | 
|  | //    var result = nameValueProvider.GetNamedValue("A"); | 
|  | //    Assert.AreEqual("B", result); | 
|  | //} | 
|  |  | 
|  | //[TestMethod] | 
|  | //public void ReloadShouldReloadDataFromExcelDataProvider() | 
|  | //{ | 
|  | //    var dict = new Dictionary<string, object>(); | 
|  | //    dict.Add("A", "B"); | 
|  | //    _excelDataProvider.Stub(x => x.GetWorkbookNameValues()) | 
|  | //        .Return(dict); | 
|  | //    var nameValueProvider = new EpplusNameValueProvider(_excelDataProvider); | 
|  |  | 
|  | //    var result = nameValueProvider.GetNamedValue("A"); | 
|  | //    Assert.AreEqual("B", result); | 
|  |  | 
|  | //    dict.Clear(); | 
|  | //    nameValueProvider.Reload(); | 
|  | //    Assert.IsFalse(nameValueProvider.IsNamedValue("A")); | 
|  | //} | 
|  | } | 
|  | } |