Two questions about CanFocus

Posted by: croquignol on 8 September 2017, 1:32 pm EST

  • Posted 8 September 2017, 1:32 pm EST

    Hello !


    1) In the Spread Designer, why is CanFocus missing in the Cell properties ? It is available only in the Named Styles collection.


    2) You can easily lock or unlock all cells marked as Locked by changing the SheetView.Protect property (True / False). Would it be possible to create the same functionality for CanFocus ? (And : why not ?)


    This could be done for instance by a new "ApplyNoFocus" property on Sheet level :



    • If ApplyNoFocus = True (by default), cells marked as CanFocus = False can't receive focus.

    • If ApplyNoFocus = False, all cells can receive focus, even those marked as CanFocus =False.

    What do you think of this idea ?


     Thanks !

  • Replied 8 September 2017, 1:32 pm EST

    I can add it as enhancement.  My take is that the CanFocus is an inherited property from the Control Class.  The properties for the Cell that are listed are unique to the cell in the Cell Class.  You can easily set these properties in code if you so desire.
Need extra support?

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

Learn More

Forum Channels