public void Can_Apply_In_SubFormulas() { var Original = ExcelFormulaParser.Parse("SUM(A1+A2)"); FSharpTransformationRule T = new FSharpTransformationRule(); T.from = (ExcelFormulaParser.Parse("SUM(A1+A2)")); T.to = (ExcelFormulaParser.Parse("A1+A2")); Assert.IsTrue(T.CanBeAppliedonBool(Original)); var map = (T.CanBeAppliedonMap(Original)); }
public void Can_Apply_Dynamic_Cell_Reference() { var Original = ExcelFormulaParser.Parse("A1"); FSharpTransformationRule T = new FSharpTransformationRule(); T.from = T.ParseToTree("{i,j}"); var Result = T.CanBeAppliedonBool(Original); Assert.IsTrue(Result); var Map = T.CanBeAppliedonMap(Original); Assert.IsTrue(Map.ContainsKey('i')); Assert.IsTrue(Map.ContainsKey('j')); Assert.AreEqual(2, Map.Count); }
public void Can_Apply_Dynamic_Range_On_Cell_Reference() { var Original = ExcelFormulaParser.Parse("SUM(A1)"); FSharpTransformationRule T = new FSharpTransformationRule(); T.from = T.ParseToTree("SUM({r})"); T.to = null; Assert.IsTrue(T.CanBeAppliedonBool(Original)); var Map = T.CanBeAppliedonMap(Original); Assert.IsTrue(Map.ContainsKey('r')); var ValueList = Map.TryFind('r').Value; var IntList = (FSharpTransform.mapElement.Ints)ValueList; Assert.IsTrue(IntList.Item.Contains(0)); Assert.AreEqual(2, IntList.Item.Count()); }
public void Can_Apply_Double_Dynamic_Reference() { var Original = ExcelFormulaParser.Parse("SUM(A2:B5)+C5"); FSharpTransformationRule T = new FSharpTransformationRule(); T.from = T.ParseToTree("SUM({r})+{i,j}"); T.to = null; Assert.IsTrue(T.CanBeAppliedonBool(Original)); var Map = T.CanBeAppliedonMap(Original); Assert.IsTrue(Map.ContainsKey('r')); var ValueList = Map.TryFind('r').Value; var IntList = (FSharpTransform.mapElement.Ints)ValueList; Assert.IsTrue(IntList.Item.Contains(0)); Assert.IsTrue(IntList.Item.Contains(1)); Assert.IsTrue(IntList.Item.Contains(4)); Assert.IsTrue(Map.ContainsKey('i')); var ValueListi = Map.TryFind('i').Value; var IntListi = (FSharpTransform.mapElement.Ints)ValueListi; Assert.IsTrue(IntListi.Item.Contains(2)); Assert.IsTrue(Map.ContainsKey('j')); var ValueListj = Map.TryFind('j').Value; var IntListj = (FSharpTransform.mapElement.Ints)ValueListj; Assert.IsTrue(IntListj.Item.Contains(4)); }