Hello. I am trying to learn LibreOffice Calc, 7.5 version.
.
My spreadsheet has numerous columns, so I must limit the column width in order to display them all on the screen. However, one “Description” column contains a LOT of text, which certainly doesn’t fit into the narrow column width.
.
Does LibreOffice Calc have some way that I could display ALL the text in a wrapped format when I click into the cell or hover over it?
.
THANK YOU.
If you are sufficiently familiar with programming (in Basic using the API e.g.) you could create for each cell of the respercive range an annotation (aka comment) taking all the text. Having set it to sufficient width it would show the text then “on mouse over”.
Unfortunately, I do not know how to program this in Basic, @Lupp , but I do appreciate your suggestion. I was hoping this would be a simple display setting.
Extend the height of the formula bar to fit your text
I will think about that suggestion, @EarnestAl . Unfortunately, the amount of text in that field would mean the spreadsheet will then display only a small number of rows. I would really prefer that I don’t see the full description unless I click on it. Thanks!
I didn’t actually expect you to be the one doing the work.
This hope will not come true.
On the other hand, I had already created some relatively clean code for a related task about a year ago, and have now invested another hour in a proof of concept for my proposal. That was quite successful, but some fine points would still have to be worked out. Also, each user needs to at least know how to allow document macros on a case-by-case basis, or… … …
But I can’t spend much time on guidance or even direct support.
Should any other user be interested in finishing the whole thing, I’m happy to provide what I have:
annotationWonderPOC.ods (20.0 KB)
The small trick is, the cells which should show their content in large width on MouseOver, get a cellstyle with a special name. Then a simple macro call is enough to arrange an update.
Valuable help by www.DeepL.com/Translator (free version)
Thank you very much for sharing. I will keep this in case I learn how to do this some day.