Why does text to columns not work?

[jb129186]

Tab separated words and numbers pasted into one column. Should be seven columns.

The “Data - > Text To Column” preview box shows the data CORRECTLY split into seven columns when tab is selected as delimiter. It looks perfect.

So I hit OK button.

Nothing happens. No obvious glitches. No messages. No response at all.

What’s wrong with it?

Note: the drop downs under “Import” (character set, language, from row) are all grayed out.

Note: the selected column has a lot of rows (105 K).

Note: I have the most recent version of LibreOffice (5.3.7.2) installed.

Edit (ajlittoz): retagged this question as “calc” instead of “common”

[Lupp]

Where did the data come from?
Why were they pasted into a single column instead of spltting the properly when importing?
Is there surely not any kind of write protection?
Having an example file at hand would be far better.

[mikekaganski]

It should work. Please provide a sample to test (use an external share and post a link here).

[jb129186]

The data was from a seven column table displayed on a web site.
As for write protection, it copy / pasted without any trouble. Other than that, I do not know “write protection” well enough to say.

It was stock price action data. Looks like this:

Mon 01-22-2018 282.21 284.76 282.19 284.73 4499727

I don’t know why it pasted into a single column. Should it have pasted into seven columns to begin with?

[mikekaganski]

Please provide the file. Whatever could happen on the way, providing the file might enable others to see the problem, and describe it directly, instead of trying to guess and suggest advises that might or might not address your issue.

[jb129186]

I understand.
I think I’m going to have a go at the file with c# first. The preview box saw a delimiter. It has to be there. Maybe I’ll be able to explain it. Thanks all.