Skip to Content
0
Feb 14, 2020 at 12:11 PM

AutoFitHeight does not work with WrapText for Excel in xml?

479 Views

Hi!

Please, tell me, do Row ss:AutoFitHeight="1" and Cell ss:WrapText="1" work together?

style for Cell

'<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>'.

Row

'<Row ss:AutoFitHeight="0">'

xml is ok but if the text (string) is long, then it is not seen completely in Excel and a user has to widen the cell to see all the text in it.

Thank you.