G’day.
New to LO after years with OOo.
Latest LO on Win11
Not a power user, just relatively simple Calc spreadsheets.
I use Comments to store usage codes, which then can be viewed when mousing over.
This worked reasonably well in OO Calc. but not so good in LO.
The only other forum discussion I found that came close to this problem was an old posting:
I read through a lot of the LO help files / Wiki stuff and this info helped me to do a good job of getting the Comments to look like I wanted. The Comments box when in edit and show modes is all good.
When in hidden mode and then moused-over the comments box is squashed (as below) causing lines to wrap to a new line. Makes it very difficult to use.
Guess what: you demonstrate a picture of something, but from it, no one would ever guess how it was expected to look; nor would one be able to experiment, using different versions and programs.
Yeah, I knew that would be a problem. As a new user the ‘system’ would only allow me a single image. Couldn’t show what the desired layout looked like.
Yep. Read it. Working on how to upload the problem cell in my spreadsheet. May take some time to experiment. 75 year old brain and all that.
“LibreOffice 25.2 is up to date.” when checking for updates.
Hmmmm … we each do things our own way, eh? Basically I have a lot of simple codes that can be detected with simple IF statements ie if( b20=‘T1’; then do something) like place the $$s into a column that keeps track of just that category of expenses. Allows us to see just where all our money goes and in which category. Having the codes info in a comments box works for me, as my brain can’t remember all of them. Hence mousing over a cell to show the codes.
__
V 7 accepts and keeps changes in the width (by macro e.g.) also for hidden annotations. V 25 does not. It always sets the width automatically.
OO v7 vs LO v25? Yes, that could be an answer. The problem seems that LO can’t detect how wide it needs to be.
On V 25 shows mandatorily Author/Date only for hidden comments with MouseOver.
I assume the changes were intentional. However, I don’t understand “2.”
Yes. I looked that up and there is a setting that lets me put my name into that as ‘Author’. I’m not working collaboratively, however. Seeing as it is just me working on this spreadsheet, I haven’t bothered with Author name stuff. [Stuffed up the quoting. Sorry.]
OK … Let’s see if this is any help.
Ian
ARRRRRGGGGHHHHH. Stupid system. Won’t allow two links. Removed the screenshot of good Comment. Hopefully the ODS example will work.
Seems to be so. It may become a serious problem if you want help, and somebody trying to provide it has no chance to understand the concept behind the “own way”.
I expected your sheets would manage information, and annotations would actually be annotations.
= = = Wanting to create “categories” and to know what ways money goes …
I simply can’t see how monster annotations should help with the task.
If you just need a reminder for abbreviations you have chosen, a piece of paper, probably taped to the wall would be recommendable, imo.
This was also the way tutorials about programming showed the available keywords for decades.
Another approach for this: Use Validity. Put your codes in a seperate sheet/column and allow only values from this list. You will have then a drop-down when you try to enter something in that fields.
