Ask Your Question

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

asked 2016-03-13 14:32:19 +0200

LecturesLaw gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-13 15:39:10 +0200

pierre-yves samyn gravatar image


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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-13 14:32:19 +0200

Seen: 1,191 times

Last updated: Mar 13 '16