private void TestReplace(string subject, string replace, string replacement, string expected) { var Fsub = T.CreateFSharpTree(ExcelFormulaParser.ParseToTree(subject).Root); var Frep = T.CreateFSharpTree(ExcelFormulaParser.ParseToTree(replace).Root); var Frepmnt = T.CreateFSharpTree(ExcelFormulaParser.ParseToTree(replacement).Root); var Fexp = T.CreateFSharpTree(ExcelFormulaParser.ParseToTree(expected).Root); var result = Fsub.ReplaceSubTree(Frep, Frepmnt); Assert.AreEqual(Fexp, result); }
public void ConvertRange() { FSharpTransformationRule T = new FSharpTransformationRule(); FSharpTransform.Formula F = T.CreateFSharpTree(ExcelFormulaParser.Parse("A1:B7")); Assert.IsNotNull(F); }
public void ConvertSheetReference() { string Cell = "Sheet!A1"; FSharpTransformationRule T = new FSharpTransformationRule(); FSharpTransform.Formula F = T.CreateFSharpTree(ExcelFormulaParser.Parse(Cell)); Assert.IsNotNull(F); }
public void ConvertFunction() { string Cell = "SUM(A1:B7)"; FSharpTransformationRule T = new FSharpTransformationRule(); FSharpTransform.Formula F = T.CreateFSharpTree(ExcelFormulaParser.Parse(Cell)); Assert.IsNotNull(F); }