protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
string actrow = Convert.ToString(e.SheetView.ActiveRow).Trim();
if (actrow == "0")
{
for (int j = 1; j < Convert.ToInt16(FpSpread1.Sheets[0].RowCount); j++)
{
string actcol = Convert.ToString(e.SheetView.ActiveColumn).Trim();
string seltext = Convert.ToString(e.EditValues[Convert.ToInt16(actcol)]).Trim();
if (seltext != "System.Object")
{
FpSpread1.Sheets[0].Cells[j, Convert.ToInt16(actcol)].Text = Convert.ToString(seltext).Trim();
}
}
}
//string ctrlname = Page.Request.Params["__EVENTTARGET"];
//if (ctrlname != null && ctrlname != String.Empty)
//{
// string[] spiltspreadname = ctrlname.Split('$');
// if (spiltspreadname.GetUpperBound(0) > 1)
// {
// string getrowxol = spiltspreadname[3].ToString().Trim();
// string[] spr = getrowxol.Split(',');
// if (spr.GetUpperBound(0) == 1)
// {
// int arow = Convert.ToInt32(spr[0]);
// int acol = Convert.ToInt32(spr[1]);
// if (arow == 0 && acol > 4)
// {
// string setval = e.EditValues[acol].ToString();
// int setvalcel = 0;
// if (setval.Trim().ToLower() == "true" || setval.Trim() == "1")
// {
// setvalcel = 1;
// }
// for (int r = 1; r < FpSpread1.Sheets[0].RowCount; r++)
// {
// FpSpread1.Sheets[0].Cells[r, acol].Value = setvalcel;
// }
// }
// }
// }
//}
}
catch (Exception ex)
{
}
}
protected void HAllSpread_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
string actrow = e.SheetView.ActiveRow.ToString();
if (flag_true == false && actrow == "0")
{
for (int j = 1; j < Convert.ToInt16(HAllSpread.Sheets[0].RowCount); j++)
{
string actcol = e.SheetView.ActiveColumn.ToString();
string seltext = e.EditValues[Convert.ToInt16(actcol)].ToString();
if (seltext != "System.Object")
{
HAllSpread.Sheets[0].Cells[j, Convert.ToInt16(actcol)].Text = seltext.ToString();
}
}
flag_true = true;
}
}
protected void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
// string bak;
// bak = e.CommandName;
// string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' });
// Int32 Satır =Convert.ToInt16( commandArgs[0].ToString());
// Int32 Sutun = Convert.ToInt32(commandArgs[1]);
// Int32 Degisecek_DokumNo, Degisecek_SiraNo, Yeni_Katsayi, Kutuk_sayisi;
// Int16 i;
// decimal YeniTonaj = 0;
//if (FpSpread1.Sheets[0].Cells[Satır, 11].Text != "")
// {
// Degisecek_DokumNo = Convert.ToInt32(FpSpread1.Sheets[0].Cells[Satır, 0].Text);
// Degisecek_SiraNo = Convert.ToInt16(FpSpread1.Sheets[0].Cells[Satır, 1].Text);
// YeniTonaj = Convert.ToDecimal(FpSpread1.Sheets[0].Cells[Satır, 13].Text);
// }
// MessageBox.Show("saklama işlemi yapıldı", MessageBox.MesajTipleri.Info, false, 5);
// // MessageBox.Show("saklama işlemi yapıldı", MessageBox.MesajTipleri.Info, false, 5);
}
protected void HAllSpread_CellClick(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
cellclick = true;
}
protected void sprdviewrcrd_CellClick(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
Cellclick = true;
}