[Solved] Prevent Calc from formatting a mailto: link

Discuss the spreadsheet application

[Solved] Prevent Calc from formatting a mailto: link

Postby belchergb » Mon Jan 30, 2017 11:23 pm

When I enter an email address in a cell, Calc automatically converts it to a mailto: link. I don't want it to do that. How/where can I turn that off?
Last edited by belchergb on Mon Jan 30, 2017 11:51 pm, edited 1 time in total.
belchergb
 
Posts: 36
Joined: Sun Mar 24, 2013 4:08 am

Re: How can I prevemt Calc from formatting a mailto: link

Postby coray80 » Mon Jan 30, 2017 11:28 pm

CTRL+M will change the link to text
OpenOffice 4.1.2 on Windows 7
If your question has been answered please add [solved] to the title by using the edit button at your first post
coray80
Volunteer
 
Posts: 357
Joined: Thu Mar 01, 2012 6:41 am

Re: How can I prevemt Calc from formatting a mailto: link

Postby RoryOF » Mon Jan 30, 2017 11:40 pm

Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29744
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How can I prevemt Calc from formatting a mailto: link

Postby belchergb » Mon Jan 30, 2017 11:45 pm

Unfortunately I had ctl-M mapped to a different command, but I can remove that.
What is the default mapping of ctl-M?
LibreOffice 3.5.7.2 Ubuntu 12.04
belchergb
 
Posts: 36
Joined: Sun Mar 24, 2013 4:08 am

SOLVED Re: How can I prevemt Calc from formatting a mailto:

Postby belchergb » Mon Jan 30, 2017 11:50 pm

Great! Answered at the libreoffice.org link above. Thank you.
LibreOffice 3.5.7.2 Ubuntu 12.04
belchergb
 
Posts: 36
Joined: Sun Mar 24, 2013 4:08 am

Re: [Solved] Prevent Calc from formatting a mailto: link

Postby coray80 » Tue Jan 31, 2017 1:27 am

reply to pm
Attachments
belchergb.PNG
OpenOffice 4.1.2 on Windows 7
If your question has been answered please add [solved] to the title by using the edit button at your first post
coray80
Volunteer
 
Posts: 357
Joined: Thu Mar 01, 2012 6:41 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 26 guests