Posted 8 September 2017, 1:32 pm EST
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 ?