e-mail addresses highlighted in spreadsheet

Discuss the spreadsheet application

e-mail addresses highlighted in spreadsheet

Postby samcl » Thu Apr 25, 2019 5:37 pm

I have an e-mail column in my spreadsheet phonebook the e-mail address is always highlighted in gray.
Sam OpenOffice 4.1.6 on Windows 10
samcl
 
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

Re: e-mail addresses highlighted in spreadsheet

Postby RoryOF » Thu Apr 25, 2019 6:12 pm

Turn off /View /Field Shading. This shading does not print.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29478
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: e-mail addresses highlighted in spreadsheet

Postby samcl » Thu Apr 25, 2019 9:54 pm

The field value highlighting ? I did not see Field Shading, value highlighting was turned off and does not seem to have any effect on my issue.
Sam OpenOffice 4.1.6 on Windows 10
samcl
 
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

Re: e-mail addresses highlighted in spreadsheet

Postby Villeroy » Thu Apr 25, 2019 11:02 pm

This is not an issue at all. The grey shading indicates that the visible text is not a string of characters.
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: 27112
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: e-mail addresses highlighted in spreadsheet

Postby samcl » Thu Apr 25, 2019 11:54 pm

How can I remove it, when I print it shows.
Sam OpenOffice 4.1.6 on Windows 10
samcl
 
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

Re: e-mail addresses highlighted in spreadsheet

Postby Villeroy » Fri Apr 26, 2019 12:07 am

No, it doesn't
Attachments
Untitled 1.pdf
(18.38 KiB) Downloaded 11 times
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: 27112
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: e-mail addresses highlighted in spreadsheet

Postby Zizi64 » Fri Apr 26, 2019 7:12 am

Turn off /View /Field Shading. This shading does not print.

I did not see Field Shading, value highlighting was turned off and does not seem to have any effect on my issue.


toggle Field Shading:
It is a Writer feature, it is not present in my Calc application.
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: 8226
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: e-mail addresses highlighted in spreadsheet

Postby Zizi64 » Fri Apr 26, 2019 7:15 am

How can I remove it, when I print it shows.

How you tried to print it? By creating a screenshot image??? Of course the shading will be appeared on a printed screenshot, but not on a normally printed sheet.
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: 8226
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests