spreadsheet: paste columns from clipboard without dialog [closed]

asked 2014-05-31 03:54:27 +0200

pbfoo gravatar image

updated 2015-09-05 20:36:49 +0200

Alex Kemp gravatar image

This is for win7, spreadsheet (i.e, calc).

Is there a way to paste a column of figures extracted from another document without going through a dialog? For example, after I go through the dialog once (which wants to know a lot of stuff about character code, field separators, etc.), is there a way to say "do this from now on without asking me again"? This is just exactly nothing more than a column of figures copied from a pdf, which are exactly this in the clipboard (pasted directly from clipboard into this form):

34,757.78
34,365.02
35,097.64
35,097.64
11,214.23
22,428.46
33,642.69
44,856.92
11,214.23
22,428.46
33,642.69
44,856.92

Note that although these contain line feeds, those are not displayed by default, because this silly thing only does html and I do not know how to make it work in some kind of verbatim mode, so I added
's to the source so it would be rendered in a column

--p.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-24 11:45:18.681037