private void btnAccept_Click(object sender, EventArgs e)
{
int cantRows = 0;
if (txtCantIndices.Text.Trim() != string.Empty)
{
cantRows = Convert.ToInt32(txtCantIndices.Text);
Excel.Worksheet NewActiveWorksheet = Globals.ThisAddIn.Application.ActiveSheet;
if ((cantRows > 0) && (cantRows <= NewActiveWorksheet.Rows.Count))
{
Excel.Range currentCell = (Excel.Range)Globals.ThisAddIn.Application.ActiveCell.Cells;
NewActiveWorksheet.Unprotect(ExcelAddIn.Access.Configuration.PwsExcel);
Generales.InsertIndice(NewActiveWorksheet, cantRows, currentCell, ConFormula, NroPrincipal);
NewActiveWorksheet.Protect(ExcelAddIn.Access.Configuration.PwsExcel, true, true, false, true, true, true, true, false, false, false, false, false, false, true, false);
this.Close();
}
else
{
MessageBox.Show("Especifique por favor un dato válido.", "Agregar índice", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Especifique por favor la cantidad de índices a insertar.", "Agregar índice", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
