[Solved] Email address background

Discuss the spreadsheet application

[Solved] Email address background

Postby Bob Coleman » Fri Jul 19, 2019 11:06 pm

If I enter an email address in a cell that otherwise has a default/white background, the background of the email address becomes gray. Is there any way to avoid this?
Last edited by Bob Coleman on Sun Jul 21, 2019 5:06 pm, edited 1 time in total.
OOo 3.0.X on Ms Windows XP
Bob Coleman
 
Posts: 26
Joined: Wed Dec 03, 2008 4:00 am

Re: email address background

Postby floris v » Fri Jul 19, 2019 11:15 pm

That's field shading - a visual aid that reminds you that the plain text has been converted to a link. You can set the color to something else, or white (Tools, Options, Appearance, Text document, Field shadings), but remember that it's an aid for you.
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4114
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: email address background

Postby Villeroy » Fri Jul 19, 2019 11:45 pm

The grey shading indicates a text field which is an important hint to the editor of a text. The text in a text field is one character. When you put the cursor before or behind the field and then hit the Del key or Backspace key respectively you delete the entire field with all the text in it. The shading is gone when you watch the document in print preview, export the document to PDF or when you print it to paper (PDF is a paperless print-out to a file).
Text fields show all kinds of hyperlinks in Calc, and in Writer they show page numbers, the current date, external data, repeating text snippets and a lot more.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26980
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: email address background

Postby Bob Coleman » Fri Jul 19, 2019 11:54 pm

floris v wrote:That's field shading - a visual aid that reminds you that the plain text has been converted to a link. You can set the color to something else, or white (Tools, Options, Appearance, Text document, Field shadings), but remember that it's an aid for you.


I suppose that would work, but my current interest is in a spread sheet, not a text document.
OOo 3.0.X on Ms Windows XP
Bob Coleman
 
Posts: 26
Joined: Wed Dec 03, 2008 4:00 am

Re: email address background

Postby Zizi64 » Sat Jul 20, 2019 12:01 am

OOo 3.0.X on Ms Windows XP


Please update your signature in this forum.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8149
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: email address background

Postby floris v » Sat Jul 20, 2019 12:03 am

Bob Coleman wrote:
floris v wrote:That's field shading - a visual aid that reminds you that the plain text has been converted to a link. You can set the color to something else, or white (Tools, Options, Appearance, Text document, Field shadings), but remember that it's an aid for you.


I suppose that would work, but my current interest is in a spread sheet, not a text document.


I know, the odd thing is that the color setting for field shadings in Text documents also works for spreadsheets. I tested that before posting my previous.
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4114
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: email address background

Postby Bob Coleman » Sat Jul 20, 2019 12:17 am

floris v wrote:
Bob Coleman wrote:
floris v wrote:That's field shading - a visual aid that reminds you that the plain text has been converted to a link. You can set the color to something else, or white (Tools, Options, Appearance, Text document, Field shadings), but remember that it's an aid for you.


I suppose that would work, but my current interest is in a spread sheet, not a text document.


I know, the odd thing is that the color setting for field shadings in Text documents also works for spreadsheets. I tested that before posting my previous.


Ah, right you are!
OOo 3.0.X on Ms Windows XP
Bob Coleman
 
Posts: 26
Joined: Wed Dec 03, 2008 4:00 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests