[Solved] Removing Thick Black Border in altered cell

Discuss the spreadsheet application

[Solved] Removing Thick Black Border in altered cell

Postby neely2175 » Tue Dec 17, 2019 5:28 pm

SOLVED: All of sudden the cells that I alter in an existing spreadsheet are being "highlighted." This is NOT the "change recording" mark, but a thick black border on top & left in each cell altered. I can not figure out how to turn this off. It partially obscures cell contents. When I copy & paste to another sheet within the spreadsheet file, this black border persists in the new sheet.
Last edited by neely2175 on Tue Dec 17, 2019 8:40 pm, edited 2 times in total.
Apache OpenOffice 4.1.5 | Windoew 10 1909
neely2175
 
Posts: 3
Joined: Tue Dec 17, 2019 5:13 pm

Re: Removing Thick Black Border in altered cell

Postby FJCC » Tue Dec 17, 2019 5:35 pm

Can you upload an example file? To upload a file, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7680
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Removing Thick Black Border in altered cell

Postby neely2175 » Tue Dec 17, 2019 7:46 pm

Per the request for a sample of the problem ods file
Attachments
Sample ODS Border Cell issue 2019-12-17.ods
Per the request for a sample of the problem ods file
(15.01 KiB) Downloaded 14 times
neely2175
 
Posts: 3
Joined: Tue Dec 17, 2019 5:13 pm

Re: Removing Thick Black Border in altered cell

Postby FJCC » Tue Dec 17, 2019 8:34 pm

That is the wackiest thing I have seen in a while. The "borders" are actually shadows from the neighboring cells. The easiest way to get rid of them is to select the menu item Edit -> Select All and then the menu item Format -> Default Formatting. If I select less than all of the cells and set Default Formatting, the cells that were not selected suddenly have shadows.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7680
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Removing Thick Black Border in altered cell

Postby neely2175 » Tue Dec 17, 2019 8:38 pm

Thank you, as it worked and was simple to do. Like you said "wacky."
Apache OpenOffice 4.1.5 | Windoew 10 1909
neely2175
 
Posts: 3
Joined: Tue Dec 17, 2019 5:13 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 3 guests