Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Multiline cell

I set a cell in edittable as multiline:
Set_Property(Ctrl, "OLE.CellMultilined[2; All]", On$)

If I enter (say) "This is a test" , on tabbing out of the cell it shows as "T..."
But the cell is wider than the text.
Is this expected behaviour as I can see where it would be annoying to the user.

click/tab on the cell and it shows expanded OK.

Comments

  • Can you let me know the Windows OS, height of the cell, the font being used, and anything else you think could be relevant?
  • Ah, the cell height.
    Changed to 16 and it works.

    Windows OS=Win10
    Cell Height=14
    Font=Tahoma, 8, 400

    thank you
  • edited March 2016
    This tells me that the font was too tall to fit the cell, which causes the text measuring algorithm to decide that ellipses are warranted.
  • How can you determine what the cell height should be, given the font size?
  • Check out the Utility TEXTRECT service.
Sign In or Register to comment.