Posted 8 September 2017, 1:42 pm EST
I have few columns in my spread where the 3rd row cells are TextCellType .
It has Multiline set to True and WordWrap set to False. The Text Orientation : TextVerticalFlipped. The cell has text displayed in two lines.
I want to resize the row height based on the text present in the cell. For eg: if in a cell, the first line has 10 characters and second line has 15 characters,
then the row height must expand based on the text with maximum length.(15 characters here). I used GetPreferredRowHeight() method but it returns the rowheight for the two lines put together (so the row height is too big).How do i capture only the line with bigger text length within the same cell??..... Am using C#