Hello,
I am putting an HTML content into a cell in order to control formatting of individual text parts:
var workbook = new Workbook();
var sheet = workbook.Worksheets[0];
var cell = sheet.Cells[0, 0];
cell.HtmlString = @"<Font Style=""FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #808080;"">Updated </Font><Font Style=""FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #000000;"">translation</Font><br/><Font Style=""FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #ff7f50;"">Reviewer </Font><Font Style=""FONT-FAMILY: Arial;FONT-SIZE: 10pt;COLOR: #000000;"">translation</Font>";
var cellStyle = cell.GetStyle();
var row = sheet.Cells.Rows[0];
var style = row.Style;
style.IsTextWrapped = true;
row.ApplyStyle(style, new StyleFlag { WrapText = true });
sheet.AutoFitRows();
sheet.AutoFitColumns();
workbook.Save(@"f:\test\cells-format.xlsx", SaveFormat.Xlsx);
However, the cell does not display correctly. In particular, its height does not fit the content:
https://www.dropbox.com/s/m6wu86nkkwl94qj/aspose_cells.PNG?dl=0
Is there anything I can do about it?
Thank you.