private void findCells(ExpTree tree)
{
foreach (var item in tree.variables.ToList())
{
tree.variables[item.Key] = float.Parse(cellLocation(item.Key).Value);
tree.setVar(item.Key, float.Parse(cellLocation(item.Key).Value));
}
}
public string Calculator(string newval, Cell hold)
{
if (newval == string.Empty)
{
// Clear values and unassign cells if current cell reset
foreach (string key in hold.sharevals.Keys)
{
hold.sharevals[key].PropertyChanged -= hold.Val_PropertyChanged;
}
hold.sharevals.Clear();
return("");
}
else if (newval[0] != '=')
{
// Clear values and unassign cells if current cell reset
foreach (string key in hold.sharevals.Keys)
{
hold.sharevals[key].PropertyChanged -= hold.Val_PropertyChanged;
}
hold.sharevals.Clear();
return(newval);
}
// use getcell to find cell value if set equal to one
else
{
// Added expression tree implementation for '=' condition
ExpTree ret = new ExpTree(newval);
string grab = "";
string Letters = "[a-zA-Z]+[\\d]*";
string Ops = "[+\\-/*()\\^]";
Regex Val = new Regex(Letters);
MatchCollection Matches = Val.Matches(newval);
foreach (Match match in Matches)
{
grab = getCell(match.Value, hold);
double set = 0.0;
if (double.TryParse(grab, out set))
{
ret.setVar(match.Value, set);
}
else
{
if (new Regex(Ops).IsMatch(newval) && grab != string.Empty)
{
return("#REF");
}
else
{
return(grab);
}
}
}
return(ret.Evaluate().ToString());
}
}
static int Main(string[] Args)
{
Dictionary <string, double> _dict = new Dictionary <string, double>();
// Set start at values, basically 0+0+0 until A1, B1, and/or C1 declared
ExpTree Exp = new ExpTree("A1+B1+C1");
int choice = 0;
double result;
string choice1 = string.Empty;
// Loops indefinitely, ends if selection 4 is chosen
while (true)
{
// Menu portion
Console.WriteLine("1) Enter Expression");
Console.WriteLine("2) Set Variable Value");
Console.WriteLine("3) Evaluate Expression");
Console.WriteLine("4) Quit");
Console.Write("Enter Choice: ");
choice1 = Console.ReadLine();
Int32.TryParse(choice1, out choice);
// Actions for various choices
if (choice == 1)
{
Console.Write("Enter New Expression: ");
Exp._Evalstring = Console.ReadLine();
}
else if (choice == 2)
{
// Request Variable name and new value from user
Console.Write("Enter Variable Name: ");
string replace = Console.ReadLine();
Console.Write("Enter New Value: ");
string with = Console.ReadLine();
// Add values to dictionary
double.TryParse(with, out result);
Exp.setVar(replace, result);
// Replace instances of variable with newly established value
}
else if (choice == 3)
{
Console.WriteLine(Exp._Evalstring + " = " + Exp.Evaluate());
}
else if (choice == 4)
{
return(0);
}
// If input isnt 1-4 tell them invalid and ask again
else
{
Console.WriteLine("Invalid Input");
}
}
}