Custom width for flexsheet columns and vertical alignment to center

Custom width for flexsheet columns and vertical alignment to center

Posted by: siddharthan on 9 September 2020, 12:48 am EST

• 

  siddharthan

  • Post Options:
  • Link
    Copy

  Posted 9 September 2020, 12:48 am EST

  Hi,
  
  How to do vertical align middle and how to increase column width in flexsheet angular

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 10 September 2020, 3:34 am EST

  Hi,

  You can increase the column width by setting the width property of the column:

  flexSheet.columns[1].width = 200;
  

  Or you can also increase the width by dragging the edges of the columns.
  
  API: https://www.grapecity.com/wijmo/api/classes/wijmo_grid.column.html#width

  Regarding the vertical-align, please refer to the demo link below:

  https://www.grapecity.com/wijmo/demos/Grid/Merging/CustomMerging/purejs

  In the above demo, observe the centerCell function only. You can center the cells by handling the formatItem event of the FlexSheet and the centerCell is the event handler for the event.

  Note that this demo is for FlexGrid but since FlexSheet extends FlexGrid, the same concept can be used in it also.

  Regards,
  
  Ashwin