Very long text in one Libre Calc cell. Hide/unhide tool?

Very long texts in one cell impair readability of the spreadsheet. How to get the text automatically truncated when exceeding a certain amount of lines, with a small triangle at the cell border indicating that the text continues? This way it would be possible to unhide the entire text only when needed.

Hi

You get the “small triangle” if you check FormatCellAlignment tab▸Properties: Wrap text automatically and if you adjust Height/Width according to your needs as in the screenshot below.

You can then use Expand / Collapse Formula Bar to read & scroll the text.

HTH - Regards