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