lost Focus

[Andreas]

why does the spreadsheet lose focus when you make an input? 

How can I guarantee that I only trigger a LostFocus event when I leave the control?

[Peter]

Hello,

The spreadsheet lost the focus because the hosted Cell's RichTextBox Editor got the focus in order to allow users input.

I can suggest handling LostFocus on the Cell's Editor as well and check in this event where the focus is. I have created a RadSpreadSheet inheritor which demonstrates this idea:

    public class MyRadSpreedsheet : RadSpreadsheet
    {
        protected override void OnLostFocus(EventArgs e)
        {
            Control ctrl = GetFocusedControl();

            if (ctrl!=null && ctrl.Parent == this)
            {
                foreach (Control control in this.Controls)
                {
                    control.LostFocus -= Control_LostFocus;
                    control.LostFocus += Control_LostFocus;                 
                }
            }
            else
            {
                base.OnLostFocus(e);
            }
        }

        private void Control_LostFocus(object sender, EventArgs e)
        {
            Control ctrl = GetFocusedControl();
            if (!ContainsSpread(ctrl))
            {
                this.OnLostFocus(e);
            }
        }

        [DllImport("user32.dll", CharSet = CharSet.Auto, CallingConvention = CallingConvention.Winapi)]
        internal static extern IntPtr GetFocus();

        private Control GetFocusedControl()
        {
            Control focusedControl = null;           
            IntPtr focusedHandle = GetFocus();
            if (focusedHandle != IntPtr.Zero)
                focusedControl = Control.FromHandle(focusedHandle);
            return focusedControl;           
        }

        private bool ContainsSpread(Control control)
        {
            if(control == null)
            {
                return false;
            }
            if(control == this)
            {
                return true;
            }
            foreach(Control ctr in control.Controls)
            {
                if(ContainsSpread(ctr))
                {
                    return true;
                }
            }

            return false;
        }
    }

We will discuss this case in the team and maybe will consider to include a better way to handle it.

Regards,
Peter
Progress Telerik