See attached sample: the text in cell 1/1 fits perfectly in “Normal” view. But when switching to “PageLayout” view or print preview, it is wrapped and thus the second line of cell content is clipped.
error.png (6.3 KB)
AsposeCellsClippedText.zip (18.2 KB)
This seems to result from a combination of several steps:
a) I load a template which uses “Calibri” font.
b) I want to set the column width to 3 centimeters, following the approach from https://forum.aspose.com/t/setcolumnwidthinch-issue/226518/5 - excel displays the column width as “2.99”, but this small difference is OK for me.
c) finally I call “AutoFitRows” for this row.
If the “AutoFitRows” call is ommitted, the row is higher, but the cells seems to be too high in “Normal” view.
Could you take a look at this?
For your information: I am on vacation next week, so my replies might be delayed.