Set entire Rows Height

Posted by: stylish16 on 8 September 2017, 2:53 pm EST

  • Posted 8 September 2017, 2:53 pm EST

    Hello all,

    I want to set same height to all rows present in a sheet.

    This height should be applicable to dynamically added rows also.

    How can i do this through designer as well as through code.

    I can be able to set height for single row.

    Please help me in this.

    I know its very simple, but can't be able to find it.

    Thanks in advance.

  • Replied 8 September 2017, 2:53 pm EST


    You could set the height of all the rows in Spread and the dynamically added rows to the same value by passing -1 as the row index, here is the line of code to implement the same:

                 fpSpread1.Sheets[0].Rows[-1].Height = value;

    In the designer, you could do the same by clicking on the SheetCorner, this would select all the rows in Spread, then in the property grid you could set the height of the rows, by clicking on the Rows property, and further clicking on the Default would show you the Height property, simply set the value of this property to change the height of all the rows in the Spread.

    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