// ExStart:CellDoubleClickEvent
// Event Handler for CellDoubleClick event
protected void GridWeb1_CellDoubleClick(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
// Displaying the name of the cell (that is double clicked) in GridWeb's Message Box
string msg = "You just clicked <";
msg += "Row: " + (e.Cell.Row + 1) + " Column: " + (e.Cell.Column + 1) + " Cell Name: " + e.Cell.Name + ">";
GridWeb1.Message = msg;
}
protected void GridWeb1_CellDoubleClick(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
string msg = "You just clicked <";
msg += "Row: " + (e.Cell.Row + 1) + " Column: " + (e.Cell.Column + 1) + " Cell Name: " + e.Cell.Name + ">";
GridWeb1.Message = msg;
}
// Uses the cell command type bind column to create a link for each row to switch to the form view.
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
if (e.Argument.Equals("VIEWDETAIL"))
{
//Show grid form and line no
GridWebForm2.ShowForm();
GridWebForm2.LineNumber = e.Cell.Row;
}
}
// ExStart:HandleCellCommandHyperlinkEvent
// Event Handler for CellCommand event
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
// Checking the CellCommand of the hyperlink
if (e.Argument.Equals("Click"))
{
// Accessing the reference of the worksheet that is currently active
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];
// Adding value to "C8" cell
sheet.Cells["C8"].PutValue("Cell Command Hyperlink Clicked");
// Resize the column to display message nicely
sheet.Cells.SetColumnWidth(2, 250);
}
}
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
//Handles sorting of columns and rows
if (e.Argument.ToString() == "A1")
{
// ExStart:SortTopToBottom
// Sorts Column 1 from top to bottom in descending order
// Cells.Sort(int startRow, int startColumn, int rows, int columns, int index, bool isAsending, bool isCaseSensitive, bool islefttoright);
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 0, false, true, false);
// ExEnd:SortTopToBottom
}
else if (e.Argument.ToString() == "B1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 1, true, true, false);
}
else if (e.Argument.ToString() == "C1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 2, false, true, false);
}
else if (e.Argument.ToString() == "D1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 3, true, true, false);
}
else if (e.Argument.ToString() == "1A1")
{
// ExStart:SortLeftToRight
// Sorts Row 1 from left to right in ascending order
// Cells.Sort(int startRow, int startColumn, int rows, int columns, int index, bool isAsending, bool isCaseSensitive, bool islefttoright);
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 0, true, true, true);
// ExEnd:SortLeftToRight
}
else if (e.Argument.ToString() == "1A2")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 1, true, true, true);
}
else if (e.Argument.ToString() == "1A3")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 2, true, true, true);
}
else if (e.Argument.ToString() == "1A4")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 3, true, true, true);
}
}
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
//Handles summary of sales by year
if (e.Argument.ToString() == "A1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 0, false, true, false);
}
else if (e.Argument.ToString() == "B1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 1, true, true, false);
}
else if (e.Argument.ToString() == "C1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 2, false, true, false);
}
else if (e.Argument.ToString() == "D1")
{
GridWeb1.WorkSheets[0].Cells.Sort(1, 0, 20, 4, 3, true, true, false);
}
else if (e.Argument.ToString() == "1A1")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 0, true, true, true);
}
else if (e.Argument.ToString() == "1A2")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 1, true, true, true);
}
else if (e.Argument.ToString() == "1A3")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 2, true, true, true);
}
else if (e.Argument.ToString() == "1A4")
{
GridWeb1.WorkSheets[1].Cells.Sort(0, 1, 4, 7, 3, true, true, true);
}
}
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
GridWeb1.ActiveSheetIndex = 1;
GridCells cells = GridWeb1.WorkSheets[1].Cells;
int sumOfOrder;
double sumOfSales;
//Handles summary of sales by year
if (e.Argument.ToString() == "Year")
{
cells["B11"].PutValue("Totals for Year " + cells["B13"].Value);
if (cells["B13"].Value.ToString() == "1996")
{
sumOfOrder = int.Parse(cells["D3"].Value.ToString()) + int.Parse(cells["D4"].Value.ToString());
cells["D11"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E3"].Value.ToString()) + double.Parse(cells["E4"].Value.ToString());
cells["E11"].PutValue(sumOfSales);
}
else if (cells["B13"].Value.ToString() == "1997")
{
sumOfOrder = int.Parse(cells["D5"].Value.ToString()) + int.Parse(cells["D6"].Value.ToString())
+ int.Parse(cells["D7"].Value.ToString()) + int.Parse(cells["D8"].Value.ToString());
cells["D11"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E5"].Value.ToString()) + double.Parse(cells["E6"].Value.ToString())
+ double.Parse(cells["E7"].Value.ToString()) + double.Parse(cells["E8"].Value.ToString());
cells["E11"].PutValue(sumOfSales);
}
else if (cells["B13"].Value.ToString() == "1998")
{
sumOfOrder = int.Parse(cells["D9"].Value.ToString()) + int.Parse(cells["D10"].Value.ToString());
cells["D11"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E9"].Value.ToString()) + double.Parse(cells["E10"].Value.ToString());
cells["E11"].PutValue(sumOfSales);
}
}
//Handles summary of sales by quarter
else if (e.Argument.ToString() == "Quarter")
{
cells["B12"].PutValue("Totals for Quarter " + cells["B14"].Value);
if (cells["B14"].Value.ToString() == "1")
{
sumOfOrder = int.Parse(cells["D5"].Value.ToString()) + int.Parse(cells["D9"].Value.ToString());
cells["D12"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E5"].Value.ToString()) + double.Parse(cells["E9"].Value.ToString());
cells["E12"].PutValue(sumOfSales);
}
else if (cells["B14"].Value.ToString() == "2")
{
sumOfOrder = int.Parse(cells["D6"].Value.ToString()) + int.Parse(cells["D10"].Value.ToString());
cells["D12"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E6"].Value.ToString()) + double.Parse(cells["E10"].Value.ToString());
cells["E12"].PutValue(sumOfSales);
}
else if (cells["B14"].Value.ToString() == "3")
{
sumOfOrder = int.Parse(cells["D3"].Value.ToString()) + int.Parse(cells["D7"].Value.ToString());
cells["D12"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E3"].Value.ToString()) + double.Parse(cells["E7"].Value.ToString());
cells["E12"].PutValue(sumOfSales);
}
else if (cells["B14"].Value.ToString() == "4")
{
sumOfOrder = int.Parse(cells["D4"].Value.ToString()) + int.Parse(cells["D8"].Value.ToString());
cells["D12"].PutValue(sumOfOrder);
sumOfSales = double.Parse(cells["E4"].Value.ToString()) + double.Parse(cells["E8"].Value.ToString());
cells["E12"].PutValue(sumOfSales);
}
}
}
