Calc Error Message

Discuss the spreadsheet application

Calc Error Message

Postby dickartale » Wed Jun 12, 2019 11:08 pm

Keep getting knocked out of calc and getting an Internet Explorer message that states "Could not perform this operation because the default mail client is not properly installed'
Just started to get message yesterday. Had older version but also got message after downloading 4.1.6.
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby robleyd » Thu Jun 13, 2019 2:44 am

What action are you trying to do when you get this error?
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2865
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Calc Error Message

Postby dickartale » Thu Jun 13, 2019 5:00 am

We are changing the text in a cell.
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby Zizi64 » Thu Jun 13, 2019 5:24 am

"Could not perform this operation because the default mail client is not properly installed'

It is trelated to the mail sending function. You need install a real (and local) email client software (like the Thunderbird) for this function. But the next infirmation is very strange:
What action are you trying to do when you get this error?

We are changing the text in a cell.


Is it a pure text or is it a Link, Hyperlink? If it is a pure text, then try to reset your User profile in AOO4.1.6.

...Or maybe you hit some hotkey accidentally and the "send the document" function is assigned to that key?
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: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc Error Message

Postby dickartale » Thu Jun 13, 2019 5:58 am

It is an email addr
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby dickartale » Thu Jun 13, 2019 6:00 am

It is an email address that we are entering into the cell. Cell had an email address that we are changing.
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby RusselB » Thu Jun 13, 2019 6:15 am

A quick test shows that right-clicking on a cell with an e-mail address will highlight the cell, and bring up a menu....but there's no Edit in that menu, so once that menu shows, just ignore it, and press F2 to go into the text editing mode.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5284
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Calc Error Message

Postby robleyd » Thu Jun 13, 2019 6:30 am

By default Calc will recognise URLs including email addresses and format them as a clickable link to create an email - subject to a suitable email client being available on Windows. Web addresses are treated similarly.

You can turn off this behaviour via Tools | AutoCorrect Options, select the Options tab and uncheck URL Recognition.

Note that existing addresses will be unchanged; you can select the cells and use Ctrl + M to set them to default formatting.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2865
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Calc Error Message

Postby Zizi64 » Thu Jun 13, 2019 6:38 am

The links (like the email addresses) will work, when you click on it. It will call the email client software.
Use the method to edit them described by RusselB.

And you can adjust the working method of the links (Ctrl-Click or pure click) in the settings - against the accidental clicking:
Tools - Options - Open/LibreOffice - Security - Options - Ctrl-click required to follow hyperlinks
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: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc Error Message

Postby dickartale » Fri Jun 14, 2019 1:54 pm

Tried going into tools and unclicking URL recognition. Still got above error message and got kn ocked out of Calc
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby robleyd » Fri Jun 14, 2019 2:20 pm

Is this in respect of existing email address, or new ones you are adding? If the former, note that I said above
"Note that existing addresses will be unchanged; you can select the cells and use Ctrl + M to set them to default formatting."
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2865
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Calc Error Message

Postby dickartale » Fri Jun 14, 2019 3:36 pm

Trying to change cell content in existing spreadsheet. Changing to new email address. Sheet is used as a record of internet sign ins. There are no formulas in the cells.
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm

Re: Calc Error Message

Postby robleyd » Sat Jun 15, 2019 12:57 am

Navigate to the cell using the keyboard arrows. Once at the cell, press Ctrl + M to clear the formatting that displays it as a clickable URL and reset the formatting to default settings. Or as I suggested above, select all the affected cells and use Ctrl + M.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2865
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Calc Error Message

Postby dickartale » Sat Jun 15, 2019 3:30 pm

Looks like this last suggestion might work. Will get back on if there are issues. Thank you.
open office 4.1.6 on windows 7
dickartale
 
Posts: 7
Joined: Wed Jun 12, 2019 11:01 pm


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 33 guests