C# Formula.ToString方法代码示例

 public void TestEqualsFromToString()
 {
     string expression = "x + 2";
     Formula a = new Formula(expression);
     Formula b = new Formula(a.ToString());
     Assert.AreEqual(true, a.Equals(b));
     Assert.AreEqual(true, b.Equals(a));
 }

 public void TestConstructorFailFunc()
 {
     Formula testFormula = new Formula("3 + x", s => s.ToLower(), s => (s == "X") ? true : false);
     Assert.AreEqual("3+X", testFormula.ToString());
 }

 public void TestToStringWithNormalizer()
 {
     Formula f = new Formula("a2*A4 + A5 / B2", VarToUpper, IsValid);
     Assert.AreEqual("A2*A4+A5/B2", f.ToString());
 }

        /// <summary>
        /// Takes in a cell name and a formula and returns the dependents
        /// Calculates the value of the formula then recalculates the value of any cell that depends directly or inderectly on it.
        /// </summary>
        /// <param name="name"></param>
        /// <param name="formula"></param>
        /// <returns></returns>
        protected override ISet<string> SetCellContents(string name, Formula formula)
        {
            name = Normalize(name);
            HashSet<string> mySet = new HashSet<string>();
            HashSet<string> replaceSet = new HashSet<string>();

            if (Object.ReferenceEquals(formula, null))
            {
                throw new ArgumentNullException();
            }
            if (Object.ReferenceEquals(name, null))
            {
                throw new InvalidNameException();
            }
            if (!Regex.IsMatch(name, "^([a-z]|[A-Z])+\\d+$") | !IsValid(name))
            {
                throw new InvalidNameException();
            }
            try
            {

                foreach (string s in formula.GetVariables())
                {

                    replaceSet.Add(s);
                }

                // dependentCells.ReplaceDependees(name, mySet);
                dependentCells.ReplaceDependees(name, replaceSet);
                GetCellsToRecalculate(name);
            }
            catch (CircularException)
            {
                throw new CircularException();
            }
            Formula myEvl = new Formula(formula.ToString(), IsValid, Normalize);
            myCell = new Cell(formula, myEvl.Evaluate(myLookup));
            if (mySpreadsheet.ContainsKey(name))
            {
                mySpreadsheet[name] = myCell;
            }
            else
            {
                mySpreadsheet.Add(name, myCell);
            }
            mySet.Add(name);
            foreach (string s in GetCellsToRecalculate(name))
            {
                mySet.Add(s);
            }
            foreach (string s in mySet)
            {
                myCell = new Cell(GetCellContents(s), myEvaluate(s));
                mySpreadsheet[s] = myCell;
            }
            Changed = true;
            return mySet;
        }

        /// <summary>
        /// Returns the formula with all the variables replaced with their normalized counterpart.
        /// </summary>
        /// <param name="f"></param>
        /// <returns></returns>
        protected Formula NormalizeFormula(Formula f)
        {
            IEnumerable<string> e = f.GetVariables();
            foreach (string s in e)
            {
                f = new Formula(Regex.Replace(f.ToString(), s, Normalize(s)));
            }

            return f;
        }

        public void TestToString2()
        {
            Formula f = new Formula("x + Y");
            String temp = "x+Y";

            Assert.IsTrue(f.ToString().Equals(temp));
        }

 public void Test51e()
 {
     Formula f1 = new Formula("2");
     Formula f2 = new Formula("3");
     Assert.IsTrue(f1.ToString().IndexOf("2") >= 0);
     Assert.IsTrue(f2.ToString().IndexOf("3") >= 0);
 }

 public void TestConstructorStandardParenthesis2()
 {
     Formula testFormula = new Formula("(4.0 + 2.0)");
     Assert.AreEqual("(4.0+2.0)", testFormula.ToString());
 }

 public void PublicTestToString()
 {
     Formula f1 = new Formula("5+5-A1/b4");
     Assert.AreEqual("5+5-A1/b4", f1.ToString());
 }

 public void PublicTestConstructor1()
 {
     Formula f1 = new Formula("6/2+4 - (4+4)");
     Assert.AreEqual("6/2+4-(4+4)", f1.ToString());
 }

 public void PublicTestConstructor()
 {
     Formula f1 = new Formula("(5+5)");
     Assert.AreEqual("(5+5)", f1.ToString());
 }

 public void SetCellContentsFormulaNull()
 {
     Spreadsheet target = new Spreadsheet();
     Formula formula = new Formula("a1+3", s => true, s => s);
     formula = null;
     target.SetContentsOfCell("a7", formula.ToString());
 }

 public void SetCellContentsFormulaInvalidName()
 {
     Spreadsheet target = new Spreadsheet();
     Formula formula = new Formula("i4+78-98.7", s => true, s => s);
     target.SetContentsOfCell("a0a", formula.ToString());
 }

 public void SetCellContentsCircularException()
 {
     Spreadsheet target = new Spreadsheet();
     Formula formula = new Formula("b1+b1", s => true, s => s);
     target.SetContentsOfCell("b1", "=b1+b1");
     formula=new Formula("b1+b1",s=>true,s=>s);
     target.SetContentsOfCell("a1", formula.ToString());
 }

 public void TestConstructorStandard()
 {
     Formula testFormula = new Formula("4.0 + 2.0");
     Assert.AreEqual("4.0+2.0", testFormula.ToString());
 }