Unable to vertical cell overflow for Multiline textbox while editing.

Posted by: banshpatel on 8 September 2017, 3:03 pm EST

  • Posted 8 September 2017, 3:03 pm EST

    Hi All,

    Multiline textbox overflow is now working while editing any cell. Please review the attached screen-show and help me out to implement the functionality like that. Below is the code snippet I am using to achieve the functionality .............. but not working :(

    this.fpSpread.AllowEditOverflow = true;
    FarPoint.Win.Spread.CellType.TextCellType g = new FarPoint.Win.Spread.CellType.TextCellType();
    g.WordWrap = true;
    g.Multiline = true;
    this.fpSpread.AllowEditOverflow = true;
    this.fpSpread.ActiveSheet.Columns[10].CellType = g;

    <font size="2" face="Consolas"><font size="2" face="Consolas"></font></font>

     Please help me to resolve this problem. I am working with FarPoint4.0 windows c#

  • Replied 8 September 2017, 3:03 pm EST


    The AllowEditOverflow property is set at the Spread level, so now the cell would overflow to the adjacent empty cells while the user is editing the cell and this would apply to any cell across all the sheets in Spread. As far as I can understand, you are looking for a behavior, where in if the user types in a cell that is set to TextCellType with Multiline and WordWrap properties are set to true, then as soon as the typing characters reaches the column or cell width, it should automatically move onto the next line and the similar should be visible to the user. If this is the scenario you are looking for, then you can set the Multiline and Wordwrap properties to True and increase the height of the row more than the default, to make the editing vertical overflow visible to the user.

    Hope it will help you. Please let me know if you have any queries further.


    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels