Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


LO 6.4.7.2 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 
went wrong.

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: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.