/*************************************************************
* Function: setExp(createACell m_Cell, Cell cell)
* Date Created: Feb 8, 2017
* Date Last Modified: Feb 9, 2017
* Description: set value to exp
* Return: void
*************************************************************/
private void setExp(createACell m_Cell, Cell cell)
{
ExpTree exptree = new ExpTree(m_Cell.Text.Substring(1));
string[] variables = exptree.GetAllVariables();
foreach (string variableName in variables)
{
Cell variableCell = GetCell(variableName);
double value;
if (string.IsNullOrEmpty(variableCell.Value))
{
exptree.SetVar(variableCell.Name, 0);
}
else if (!double.TryParse(variableCell.Value, out value))
{
exptree.SetVar(variableName, 0);
}
else
{
exptree.SetVar(variableName, value);
}
}
m_Cell.SetValue(exptree.Eval().ToString());
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
#region hw4code
//old code from hw4
//string letter = m_Cell.Text.Substring(1);
//string number = letter.Substring(1);
//string lettersAZ = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
//int col = 0, row = int.Parse(number) - 1;
//for (int i = 0; i < 26; i++)
//{
// if (lettersAZ[i] == letter[0])
// {
// col = i;
// break;
// }
//}
//m_Cell.SetValue(GetCell(row, col).Value.ToString());
#endregion
}
/*************************************************************
* Function: OnPropertyChanged(object sender, PropertyChangedEventArgs e)
* Date Created: Feb 8, 2017
* Date Last Modified: Feb 9, 2017
* Description: OnPropertyChanged
* Return: void
*************************************************************/
public void OnPropertyChanged(object sender, PropertyChangedEventArgs e)
{
if (e.PropertyName == "Text")
{
createACell tmpCell = sender as createACell;
RemoveDep(tmpCell.Name);
if (tmpCell.Text != "" && tmpCell.Text[0] == '=')
{
ExpTree exp = new ExpTree(tmpCell.Text.Substring(1));
MakeDep(tmpCell.Name, exp.GetAllVariables());
}
Eval(sender as Cell);
}
else if (e.PropertyName == "BGColor")
{
CellPropertyChanged(sender, new PropertyChangedEventArgs("BGColor"));
}
}
/*************************************************************
* Function: setExp(createACell m_Cell, Cell cell)
* Date Created: Feb 8, 2017
* Date Last Modified: Feb 9, 2017
* Description: set value to exp
* Return: void
*************************************************************/
private void setExp(createACell m_Cell, Cell cell, ref bool flag)
{
ExpTree exptree = new ExpTree(m_Cell.Text.Substring(1));
string[] variables = exptree.GetAllVariables();
foreach (string variableName in variables)
{
// bad reference
if (GetCell(variableName) == null)
{
m_Cell.SetValue("!(Bad Reference)");
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
flag = true;
break;
}
//SetExpressionVariable
Cell variableCell = GetCell(variableName);
double value;
if (string.IsNullOrEmpty(variableCell.Value))
{
exptree.SetVar(variableCell.Name, 0);
}
else if (!double.TryParse(variableCell.Value, out value))
{
exptree.SetVar(variableName, 0);
}
else
{
exptree.SetVar(variableName, value);
}
//SetExpressionVariable end;
//self reference
if (variableName == m_Cell.Name)
{
m_Cell.SetValue("!(Self Reference)");
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
flag = true;
break;
}
}
if (flag)
{
return;
}
//Circular reference
foreach (string varName in variables)
{
if (varName == m_Cell.Name) // directly same
{
m_Cell.SetValue("!(Circular Reference)");
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
flag = true;
break;
}
if (!depDict.ContainsKey(m_Cell.Name)) //check in dict
{
continue;
}
string currCell = m_Cell.Name;
for (int i = 0; i < depDict.Count; i++) //find all cell in dict
{
foreach (string dependentCell in depDict[currCell]) //do same thing as before
{
if (varName == dependentCell)
{
m_Cell.SetValue("!(Circular Reference)");
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
flag = true;
break;
}
if (!depDict.ContainsKey(dependentCell))
{
continue;
}
currCell = dependentCell;
}
}
}
if (flag)
{
return;
}
m_Cell.SetValue(exptree.Eval().ToString());
CellPropertyChanged(cell, new PropertyChangedEventArgs("Value"));
#region hw4code
//old code from hw4
//string letter = m_Cell.Text.Substring(1);
//string number = letter.Substring(1);
//string lettersAZ = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
//int col = 0, row = int.Parse(number) - 1;
//for (int i = 0; i < 26; i++)
//{
// if (lettersAZ[i] == letter[0])
// {
// col = i;
// break;
// }
//}
//m_Cell.SetValue(GetCell(row, col).Value.ToString());
#endregion
}