LO 126.96.36.199 in UbuntuStudio 20.04
Suddenly in the middle of a sheet of a newly created spreadsheet, it has developed a rash of red
lines. Some enclose a range of cells and some just appear on the whole row.
If I hover over these red lines, a small yellow info box opens which informs me that I, at date,
time, deleted rows xx:yy. Or if the line is a box enclosing a range of cells, the note tells me
that on date/time I moved Range A12:B12 to C13:D13.
I don't know what I did to cause these lines to appear and what's worse. I don't know how to make
them vanish. I certainly didn't change anything in Tools/Options. I have checked all menu columns
and tried to find some reference in the Manual but without success.
What I was doing when these lines appeared was pasting text data into a single column over about 40
or 50 rows, deleting rows I didn't need and then selecting two adjacent cells, cutting them out
with Ctrl-X, selecting a new empty cell higher in the column and then pasting the contents in with
Paste Special (Shift-Ctrl-V) using the transpose function to paste to two adjacent cells in the
same row. I have done this hundreds of times over a lengthy period with many spreadsheets and this
evening I had completed the operations some 20 to 25 times with no problem then suddenly it all
I've tried copying the info over to a new sheet but red lines follow and, worse, everywhere I move
the cursor on the new sheet, a little box attached to the cursor provides info (unwanted).
No doubt I had some faulty manipulation somewhere but if anyone can tell me how to get rid of this
unwanted info, and what I did to provoke it, I'd be grateful.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] unwanted red lines on spreadsheet and info boxes · Philip Jackson
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy