calc problem

users
#1

Hi,

I would like to ask you how to solve a problem with Calc. Ill try to explain you how to reproduce it.

Just open any web page in your browser and find there an e-mail contact which is in html link form. I.e. users+subscribe@global.libreoffice.org <mailto:users+subscribe@global.libreoffice.org>
Copy this contact with ctrl+c and try to paste it to Calc list with ctrl+v.

What happen is, that some "import dialog" appear and you must click your decision. In that dialog there is no checkbox like "remember my decision and dont ask again". So when you need to copy+paste like 400 email addresses, you must everytime click this dialog. This is bad, very bad...
So my question is: is there any option how to turn this dialog off? I didn't find it...

LibreOffice 3.4.4 in Ubuntu 11.10.

Thank you,
V. Medek

#2

Still no answer. Can anybody help me please?
Thank you.

Václav Medek

Systémový administrátor lokální sítě

#3

I right-click the hyperlink in my browser, mail program, office document, whatever and choose a command like "Copy Link Address".
Then I paste the naked URL string into a Calc cell.

#4

Hi Andreas,

thanks for reply. Yes this works. But it is only half solution. I need it to work with ctrl+c/ctrl+v because it is faster then clicking with mouse.
(Btw. in my opinion both should be the same, not different)

Dne 27.2.2012 13:34, Andreas Säger napsal(a):

#5

Am 27.02.2012 14:19, Václav Medek wrote:

Hi Andreas,

thanks for reply. Yes this works. But it is only half solution. I need
it to work with ctrl+c/ctrl+v because it is faster then clicking with
mouse.
(Btw. in my opinion both should be the same, not different)

So you have a problem with your browser and/or your operating system.
The context menu should be available from the keyboard. Some keyboards have a special key for that.
The browser may be configuarable so a certain shortcut copies the address of the selected link.

A professional data miner would write a simple script to extract all hyperlinks without using any browser at all. And certainly he would not use a spreadsheet to collect data.

#6

Curious: How can right click, left click pop up menu, and Ctrl+V be
slower than highlight the link, Ctrl+C, and Ctrl+V? I really do not see
the difference. How are you selecting the links?

--Dan

#7

Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working
right as expected. When ctrl+c/ctrl+v some email address to Calc, no
dialogue appear and address is just filled into Calc cell (as link, not as
clear text, but it is not important for me).
But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you
are right that it is OS/browser problem.

I tried it and I never saw a dialogue. The link was pasted into the
cell as pure text. I don't know if that's what you are looking for,
though.

Operating system: Ubuntu 10.10
Web browser: Opera 11.61

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#8

Am 27.02.2012 16:53, Johnny Rosenberg wrote:

Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working
right as expected. When ctrl+c/ctrl+v some email address to Calc, no
dialogue appear and address is just filled into Calc cell (as link, not as
clear text, but it is not important for me).
But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you
are right that it is OS/browser problem.

I tried it and I never saw a dialogue. The link was pasted into the
cell as pure text. I don't know if that's what you are looking for,
though.

You see the text import dialog when you copy and paste multi-line text. This will never happen when you use the URL copy of the respective browser.
Under Linux you can also use the system clipboard (middle mouse) to paste previously selected unformatted text. But this will also trigger a text table import in case of multiple lines.
If you want multi-line text in one cell, you can always hit F2 before pasting.

#9

If I paste into the formula entry bar there is no dialogue.
steve

#10

Dne 27.2.2012 17:27, Andreas Säger napsal(a):

Am 27.02.2012 16:53, Johnny Rosenberg wrote:

Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working
right as expected. When ctrl+c/ctrl+v some email address to Calc, no
dialogue appear and address is just filled into Calc cell (as link, not as
clear text, but it is not important for me).
But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you
are right that it is OS/browser problem.

I tried it and I never saw a dialogue. The link was pasted into the
cell as pure text. I don't know if that's what you are looking for,
though.

You see the text import dialog when you copy and paste multi-line text. This will never happen when you use the URL copy of the respective browser.
Under Linux you can also use the system clipboard (middle mouse) to paste previously selected unformatted text. But this will also trigger a text table import in case of multiple lines.
If you want multi-line text in one cell, you can always hit F2 before pasting.

URL copy works fine.
Anyway, it seems like it happen in some circumstances only in latest Ubuntu 11.10. Now I tried it in Xubuntu 11.04 with Libre Office 3.3.4 and Firefox 10.0.2 and there it is ok - no dialogue (Import Options) appear and its just pasted as link into a cell.
I still dont have any idea what and how to configure to avoid that dialogue. There must be some reason why Libre Office see it as multi-line (or whatever else).