Cell Overflow in Vertical direction

Cell Overflow in Vertical direction

Posted by: siddharth.shinde on 30 May 2018, 3:16 am EST

• 

  siddharth.shinde

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 May 2018, 3:16 am EST

  Hello,

  We have a multiline cell and I want to see a similar behavior like in excel where a cell can overflow in the vertical direction. Can you please help?

  At present, while editing in cell if I go to next line, the previous line hides away which is irritating for the user.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 31 May 2018, 8:26 am EST

  Hi Siddharth,

  When you have the multiline text in a cell, you would need to manually set the row height as per the cell content. You can have both the multiline and wordwrap set to true and after you finish editing you can call GetPreferredRowHeight() method to get the row height to make the cell content visible.
  
  For example to set the preferred height of Row[0], you can use the code as:

  fpSpread1.Sheets[0].Rows[0].Height = fpSpread1.Sheets[0].GetPreferredRowHeight(0);
  

  With Spread it does not automatically increase the row height while typing cell.

  Thanks,
  
  Deepak Sharma