private void AddColumn_Click(object sender, EventArgs e)
{
dataGridView1.Columns.Add(To26Sys.TO(Info.ColumnCount), To26Sys.TO(Info.ColumnCount));
Inicialize.AddColumn(dataGridView1.SelectedCells[0].ColumnIndex);
Inicialize.UpdateDependencesColumnAdded(dataGridView1.SelectedCells[0].ColumnIndex);
FullUpdateGrid();
ShowExpression.Checked = false;
}
private void FullUpdateGrid()
{
for (int i = 0; i < Info.ColumnCount; i++)
{
dataGridView1.Columns[i].HeaderText = To26Sys.TO(i);
for (int j = 0; j < Info.RowCount; j++)
{
UpdateCell(Inicialize.cells[i, j].Name);
}
}
for (int i = 0; i < Info.RowCount; i++)
{
dataGridView1.Rows[i].HeaderCell.Value = (i + 1).ToString();
}
}
public static void AddColumn(int index)
{
Info.ColumnCount++;
var a = new Cell[Info.ColumnCount - 1, Info.RowCount];
//--------------------Copy of cells-----------------------//
for (int i = 0; i < Info.ColumnCount - 1; i++)
{
for (int j = 0; j < Info.RowCount; j++)
{
a[i, j] = new Cell(Inicialize.cells[i, j].Name, i, j);
a[i, j].Value = Inicialize.cells[i, j].Value;
a[i, j].Expression = Inicialize.cells[i, j].Expression;
}
}
//#-----------------------Upgrade-cells---------------------//
Inicialize.cells = new Cell[Info.ColumnCount, Info.RowCount];
for (int i = 0; i < Info.ColumnCount - 1; i++)
{
for (int j = 0; j < Info.RowCount; j++)
{
Inicialize.cells[i, j] = new Cell(a[i, j].Name, i, j);
Inicialize.cells[i, j].Value = a[i, j].Value;
Inicialize.cells[i, j].Expression = a[i, j].Expression;
}
}
//-------------------------Name last col---------------------------------//
for (int i = 0; i < Info.RowCount; i++)
{
Inicialize.cells[Info.ColumnCount - 1, i] = new Cell(To26Sys.TO(Info.ColumnCount) + (i + 1).ToString(), Info.ColumnCount - 1, i);
}
//----------------------------Cdvig----------------------------------------//
for (int i = 0; i < Info.RowCount; i++)
{
for (int j = Info.ColumnCount - 1; j >= index + 1; j--)
{
Inicialize.cells[j, i].Expression = Inicialize.cells[j - 1, i].Expression;
}
}
//---------------------------Clear start col--------------------//
for (int i = 0; i < Info.RowCount; i++)
{
Inicialize.cells[index, i].Value = "";
Inicialize.cells[index, i].Expression = "";
}
}
public void New()
{
var dataGridView1 = new DataGridView();
dataGridView1.ColumnCount = Info.ColumnCount;
dataGridView1.RowCount = Info.RowCount;
for (int i = 0; i < Info.ColumnCount; i++)
{
for (int j = 0; j < Info.RowCount; j++)
{
var a = new Cell(To26Sys.TO(i) + (j + 1).ToString(), i, j);
a.Name = To26Sys.TO(i) + (j + 1).ToString();
cells[i, j] = a;
dataGridView1[i, j].Value = cells[i, j].Value;
}
}
}
public bool Open()
{
StreamReader myStream;
OpenFileDialog saveFileDialog1 = new OpenFileDialog();
saveFileDialog1.Filter = "DataGridView files (*.dvg)|*.dvg|All files (*.*)|*.*";
saveFileDialog1.FilterIndex = 2;
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.DefaultExt = "dvg";
saveFileDialog1.CheckPathExists = true;
saveFileDialog1.CheckFileExists = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
myStream = new StreamReader(saveFileDialog1.OpenFile());
if (myStream != null)
{
string c;
c = myStream.ReadLine();
string[] a = new string[2];
a = c.Split(' ');
Info.ColumnCount = Convert.ToInt32(a[0]);
Info.RowCount = Convert.ToInt32(a[1]);
Inicialize.cells = new Cell[Info.ColumnCount, Info.RowCount];
for (int i = 0; i < Info.ColumnCount; i++)
{
for (int j = 0; j < Info.RowCount; j++)
{
var b = new Cell(To26Sys.TO(i) + (j + 1).ToString(), i, j);
b.Value = myStream.ReadLine();
b.Expression = myStream.ReadLine();
Inicialize.cells[i, j] = b;
}
}
Info.PATH = saveFileDialog1.FileName;
myStream.Close();
myStream.Dispose();
saveFileDialog1.Dispose();
return(true);
}
}
return(false);
}
private static string PreviousCell(string cell, bool IsRow)
{
if (IsRow)
{
string cellRes = "";
cell += " ";
int index = 0;
while (cell[index] >= 65 && cell[index] <= 90)
{
cellRes += cell[index];
index++;
}
cellRes = To26Sys.TO(To26Sys.FROM(cellRes) - 1);
while (cell[index] >= 48 && cell[index] <= 57)
{
cellRes += cell[index];
index++;
}
return(cellRes);
}
else
{
string cellRes = "";
cell += " ";
int index = 0;
while (cell[index] >= 65 && cell[index] <= 90)
{
cellRes += cell[index];
index++;
}
string cellRes1 = "";
while (cell[index] >= 48 && cell[index] <= 57)
{
cellRes1 += cell[index];
index++;
}
cellRes += (Convert.ToInt32(cellRes1) - 1).ToString();
return(cellRes);
}
}
