We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Auto fit rows after mergin columns


I would like to know if it's possible to auto fit a row after merging columns together ?

I would like the row height be bigger is the text won't fit.

Thanks a lot

Have a good day !

3 Replies 1 reply marked as answer

RB Rahul Balasundaram Syncfusion Team February 16, 2023 01:29 PM UTC

Hi Anthony,

We suggest using IWorksheet.AutoFitRow to fit the row height based on the content. To know more details, please refer to the documentation from the following link.




AB Anthony Benoit replied to Rahul Balasundaram February 16, 2023 03:33 PM UTC


It's not working with merge columns, the row won't fit whatever the autofitsRow i use.

Do you have an example with merge column and autofitRow ?

Thanks and have a good day !

MC Mohan Chandran Syncfusion Team February 17, 2023 07:45 AM UTC

Hi Anthony,

Sorry. As per Microsoft Excel behavior, it is not possible to auto-fit the rows with merged columns. XlsIO behaves similarly. So, it is not possible to achieve this requirement with XlsIO.



Marked as answer
Live Chat Icon For mobile
Up arrow icon