Multi line in FpSpread

Posted by: senthilkcg-fp on 8 September 2017, 2:54 pm EST

  • Posted 8 September 2017, 2:54 pm EST

    Dear sir,

            I want to use the spread sheet cell as multiline as like in the .net textbox. I have found there is an option called multiline in cell properties but i dont know how is it working. Please help me out. 

  • Replied 8 September 2017, 2:54 pm EST

    Hello,


    You would need to set the celltype of the cell to TextCellType, and set the Multiline property of the TextCellType to true, to achieve the behavior similar to that of the multiline TextBox in .net. Here is the code to implement the same.


                               FarPoint.Win.Spread.CellType.TextCellType txt = new FarPoint.Win.Spread.CellType.TextCellType();
                               txt.Multiline = true;
                               fpSpread1.Sheets[0].Cells[0, 0].CellType = txt;


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


    Thanks,


    Manpreet Kaur.

Need extra support?

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

Learn More

Forum Channels