public void UpdateFormulaDeletedSheetReference()
{
var formulaManager = new FormulaManager();
string actualFormula = formulaManager.UpdateFormulaDeletedSheetReferences("CONCATENATE(Sheet1!B2, Sheet2!C3)", "sheet1");
Assert.AreEqual("CONCATENATE(#REF!B2,'Sheet2'!C3)", actualFormula);
}
public void UpdateFormulaDeletedSheetReferenceEmptySheetNameThrowsException()
{
var formulaManager = new FormulaManager();
string actualFormula = formulaManager.UpdateFormulaDeletedSheetReferences("CONCATENATE(Sheet1!B2, Sheet2!C3)", string.Empty);
}
