Why don't subeditors pick up the underlying cell properties

Posted by: j2associates on 8 September 2017, 1:14 pm EST

  • Posted 8 September 2017, 1:14 pm EST

    Hello all,

    We have a spread with VerticalAlignment set to Center. Yet when I click on a cell that has a ComboBoxCellType attached to it, it is displayed (presumably) as General and so paints at the top fo the cell until an entry is selected and then it jumps back down to be in line with the rest of the line. The same thing happens on a cell with no CellType assigned. When it goes into edit mode it jumps up to the top of the cell and then reverts when the edit is completed. This is visually very annoying and seems like it would be pretty simple to fix.

  • Replied 8 September 2017, 1:14 pm EST


    It would seem simple to fix except for one issue. There are no Windows controls that we can use as editors of the cells that support any other vertical alignment other than Top. If you have another control that supports this functionality, then you can use that control as the editor of the cell.

  • Replied 8 September 2017, 1:14 pm EST

    Hello Scott,

    Sorry to sound kinda grouchy in my first post. From your response, I am guessing that you are using a TextBox or something similar for the edit control. Could you use a Label with AutoSize set to False? This would then give you access to the Label TextAlign property which supports TopLeft, TopCenter, TopRight, MiddleLeft, MiddleCenter, MiddleRight, BottomLeft, BottomCenter and BottomRight.

  • Replied 8 September 2017, 1:14 pm EST


    Yes. We are using our own editors that are like textboxes with a lot of extra code written  on them. How would you edit a label?

Need extra support?

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

Learn More

Forum Channels