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.


    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:


    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 Wink

Need extra support?

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

Learn More

Forum Channels