// 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); } } }