Looks like the problem occurs when spreadsheet is automatically generated or converted to Excel format from something different.
I've saved spreadsheet from google drive as excel spreadsheet (.xlsx) and found out that all multiline cells are displayed as single line cells:
If I select such cell's value and press enter it turns into multiline cell and finally displayed as intended (after setting proper row size):
To fix it you can just:
- Select range with affected cells.
- Press F2 and then enter again and again until all cells fixed.
But this way only acceptable for smaller spreadsheets.
Isn't there any better solution?