Ask Your Question

Is it possible to define an arbitrary string indicative of text overflow in a Calc cell?

asked 2017-03-24 04:39:21 +0200

DAT gravatar image

The CSS specification describes the text-overflow property. This property defines how overflowed content (content that doesn't fit within the corresponding box) is indicated to the viewer. Is there a way to "style" a cell in Calc in a similar manner? In particular, is it possible to have Calc display an ellipsis in lieu of overflowed content (indicating the presence of overflowed content to the viewer)?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-03-24 07:35:33 +0200

No, there's no such setting in Calc.

edit flag offensive delete link more


Thanks -- disappointing but c'est la vie. Appreciate your taking the time to respond.

DAT gravatar imageDAT ( 2017-03-24 18:31:41 +0200 )edit

answered 2017-03-24 23:30:03 +0200

EasyTrieve gravatar image

You can test the string length, and if long, trim it and add "...". This is not exactly the same as CSS, but it is a workaround. It does depend on character widths. If you use a fixed width font it will work pretty well.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-24 04:39:21 +0200

Seen: 53 times

Last updated: Mar 24 '17