Ask Your Question

How can I remove warning arrow when cell content is wider than cell width?

asked 2021-01-22 20:41:46 +0200


I'm running LibreOffice on a Mac.

In spreadsheets, if the content that I have added to a cell exceeds the width of the cell - and if the adjacent cell on the right has content - there is a little right-pointing arrow for the "offending" cell. I would like to get rid of those warning arrows, but have searched through formatting options and have not found a setting that I can tweak.

The attached screenshot shows the arrows. I'm pretty sure their existence is fairly new, and I would greatly appreciate help in figuring out how to get rid of them!

C:\fakepath\Screen Shot 2021-01-22 at 2.38.31 PM.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-22 21:22:38 +0200

dscheikey gravatar image

Hi, in Windows we have the option - Calc - View - Text overflow. Here you can hide the triangles.

C:\fakepath\Screenshot 2021-01-22 211909.png

edit flag offensive delete link more


On macOS it is LibreOffice -> Preferences -> LibreOffice Calc -> View -> Option: [ ] Text overflow, which needs to be deactivated.

Opaque gravatar imageOpaque ( 2021-01-23 00:06:28 +0200 )edit

Thank you - that took care of the issue. It never occurred to me to check that path for options that I could tweak! I appreciate the speedy help.

Dug McV gravatar imageDug McV ( 2021-01-23 17:52:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-22 20:41:46 +0200

Seen: 25 times

Last updated: Jan 22