public void UpdateFormulaSheetReferences()
{
var formulaManager = new FormulaManager();
var result = formulaManager.UpdateFormulaSheetReferences("5+'OldSheet'!$G3+'Some Other Sheet'!C3+SUM(1,2,3)", "OldSheet", "NewSheet");
Assert.AreEqual("5+'NewSheet'!$G3+'Some Other Sheet'!C3+SUM(1,2,3)", result);
}
public void UpdateFormulaSheetReferencesEmptyOldSheetThrowsException()
{
var formulaManager = new FormulaManager();
formulaManager.UpdateFormulaSheetReferences("formula", string.Empty, "sheet2");
}
public void UpdateFormulaSheetReferencesNullOldSheetThrowsException()
{
var formulaManager = new FormulaManager();
formulaManager.UpdateFormulaSheetReferences("formula", null, "sheet2");
}
