How to setup FpSpread/sheets/column responsive ?

Posted by: wfargeot on 21 February 2019, 7:57 pm EST

  • Posted 21 February 2019, 7:57 pm EST

    Hi guys !

    After too many hours to looking for a way to render the column of my FpSpread responsive in my webForm project and failed, I ask the community to know if someone would know how to do it?

    Is there an option because I have not managed to find it?

    Thanks !!
  • Replied 24 February 2019, 7:54 pm EST

    Hello,

    You can adjust the width of columns as per the text width using the SizeToFit() method client side.
    To adjust the width of Spread control as per the size of the Browser Window you can use server side code similar to :

    fpSpread1.Width = Unit.Percentage(100);

    I hope it helps.

    Thanks,
    Deepak Sharma
  • Replied 12 March 2019, 1:06 am EST

    Thanks for your response.

    I've already put this code :
    fpSpread1.Width = Unit.Percentage(100);

    But I need to render the column of the activesheet responsive to fill all the spread horizontaly. I don't want blank space in my spread to the right. See attachment to see what I mean.

    The SizeToFit() method did the reverse effect of what I want.
    I need the columns to lengthen to complete the entire table.

  • Marked as Answer

    Replied 12 March 2019, 10:27 pm EST

    Hello,

    The columns of Spread for ASP.Net do not auto size by itself. It is not responsive by default. You may call the client side method i.e. SizeToFit() to adjust the column width as per the largest text in the cell.
    Example:
    <script type="text/javascript">
    function FitSpread()
    {
    FpSpread1.SizeToFit()
    }
    </script>

    Thanks,
    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels