How to setup FpSpread/sheets/column responsive?

How to setup FpSpread/sheets/column responsive?

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

• 

  wfargeot

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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 !!

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  wfargeot

  • Post Options:
  • Link
    Copy

  Posted 12 March 2019, 1:06 am EST - Updated 30 September 2022, 2:48 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.

  

  855×551 21.8 KB

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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:

  Thanks,
  
  Deepak Sharma