Ask Your Question
0

How to paste from HTML into a Calc cell without popups

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

Ian Mackinnon 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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 314 times

Last updated: Aug 11 '16