Auto fit rows after mergin columns

[Anthony Benoit]

Hello,

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 !

[Rahul Balasundaram]

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.

https://help.syncfusion.com/file-formats/xlsio/worksheet-rows-and-columns-manipulation#auto-fit-rows-and-columns

Regards,

Rahul

[Anthony Benoit]

Hello,

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 !

[Mohan Chandran]

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.

Regards,

Mohan.