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