Dear Aspose team,
In Excel, if a row with the standard/default height contains a cell with the double underscore, the row height is increased slightly. The text is also elevated a bit. E.g. height 12.75 → 13.5.
Aspose handles it in the same way.
The problem appears in the following scenario.
— Row 1: no formatting.
— Row 2: double underscore
— Row 3: no formatting
— Row 2 is changed to be hidden
— Row 1: automatically adopts double underscore
In Excel Row 1 is 13.5 after this step.
In Aspose Row 1 is 12.75.
A short demo is attached.
It that demo, on result worksheet, rows 4 and 9 are supposed to have height 13.5.
Open in Excel, row 4 displays 13.5, but just because no height is set (automatic),
row 9 displays 12.75, but just because no height is set (automatic).
Aspose reports 12.75 for rows 4 and 9.
It may look very subtle, however we have a number of clients who end up with truncated/cropped text in such rows. Especially for capital T, F.
Aspose Demo — Truncated text.zip (70.7 KB)