Ask Your Question
0

How to paste from HTML into a Calc cell without popups [closed]

asked 2016-08-11 12:39:04 +0100

Ian Mackinnon gravatar image

updated 2020-08-11 17:11:07 +0100

Alex Kemp gravatar image

When I copy numeric values from a web browser and try to paste them into a cell in Calc using ctrl-v a popup appears:

Select the Language to Use for Import
-  Automatic
-  Custom
Options
- Detect special numbers (such as dates)

If I perform “Paste Special” with ctrl-shift-v I get a different popup:

Selection
- Unformatted text
- HTML

I do not want any special formatting or spellchecking in my spreadsheets. I just want to perform numeric calculations. Can I change the behaviour of Calc so that it just pastes the number with whatever default settings and lets me continue working without interruption?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 17:11:20.768259

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-11 23:00:21 +0100

Ratslinger gravatar image

The easiest way is to record a macro and assign to an unused key combination. See this post: click here.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-08-11 12:39:04 +0100

Seen: 360 times

Last updated: Aug 11 '16