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