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);
}