Spanned cells selection

Posted by: pedro-rodrigues on 8 September 2017, 1:58 pm EST

  • Posted 8 September 2017, 1:58 pm EST

    Hi guys


    I'm trying to get FpSpread to work like Excel, in some aspects. One of these aspects is "Merge & Center" (which I'm doing via spanned cells). The problem is with the selection of these spanned cells.

     <img src="">

    What's happening is shown in the image above. When selecting from B5 through D5, only the cells on B5, C5 (spanned) and D5 get selected.


    What I wanted to do is select the range B5:D5, and internally select the whole block from B5:D8, like in the next image:

     <img src="">

    Is there any way to do this?



  • Replied 8 September 2017, 1:58 pm EST

    You would need to use the SelectionChanging event and check for spans within the given CellRange. Then you would Cancel the event and set your own selection.
  • Replied 8 September 2017, 1:58 pm EST

    Hehe, that was the first approach I tried, but forgot to Cancel the event!


    Thanks for the tip <img src="/emoticons/emotion-5.gif" alt="Wink" />

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels