Ask Your Question

Can you cut column data of unknown format and paste to calc? [closed]

asked 2014-08-29 17:36:15 +0100

jspreadsheet gravatar image

I want to paste 4 columns of data to a calc file I cut from a utility listing phone info. Many attempts were made to paste special this data using "Text Import". I came close once with all columns lined up but each cell was bordered in red which required clearing the direct format. This was acceptable but unfortunately I could never duplicate this again later on a subsequent try. Any clues as to how I got there?

Related was an attempt to use the "Other" separator that appeared to be a right arrow symbol → like the one from the Liberation Sans font. This proved to be problematic since I could not figure out any way to change the "Text Import" separator font. The only font allowed was a greyed-out Ubuntu which did not list the " → " special character. This attempt to try a different separator may be a "reaching for straws" but is there some way to change the font separator just for "Text Import"?

PS. The default font for the calc doc is Liberation Sans not the single Ubuntu font option for "Paste special - Text import".

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 10:39:23.621519

1 Answer

Sort by » oldest newest most voted

answered 2014-08-29 17:47:40 +0100

karolus gravatar image

updated 2014-08-29 17:49:05 +0100


The Arrow-symbol in Textimport-preview indicates there are <tab>chars in the imported Text.
Check the [x]Tabulator as Column-Separator..


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-08-29 17:36:15 +0100

Seen: 129 times

Last updated: Aug 29 '14