e-mail addresses highlighted in spreadsheet

Discuss the spreadsheet application
Post Reply
samcl
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

e-mail addresses highlighted in spreadsheet

Post by samcl »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: e-mail addresses highlighted in spreadsheet

Post by RoryOF »

Turn off /View /Field Shading. This shading does not print.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
samcl
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

Re: e-mail addresses highlighted in spreadsheet

Post by samcl »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: e-mail addresses highlighted in spreadsheet

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
samcl
Posts: 3
Joined: Wed Mar 20, 2019 4:37 pm

Re: e-mail addresses highlighted in spreadsheet

Post by samcl »

How can I remove it, when I print it shows.
Sam OpenOffice 4.1.6 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: e-mail addresses highlighted in spreadsheet

Post by Villeroy »

No, it doesn't
Attachments
Untitled 1.pdf
(18.38 KiB) Downloaded 88 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: e-mail addresses highlighted in spreadsheet

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: e-mail addresses highlighted in spreadsheet

Post by Zizi64 »

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; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Post Reply