Calc - Force import text dialog to pop up when pasting data

Dear all,
is there a quick way, when pasting data into calc, to go through the “import text dialog” instead of pasting the data directly?

I know I can use shift+ctrl+v but that prompts a request before bringing me to the import text dialog and I would like to skip that step.

Here’s the background of the request:
I have structured data in a txt file which I normally copy and pasto to calc. If I paste more than one row then the Import Dialog pops up and let me select the language for the date and everything works well. However, if I import one line only, the dialog does not pop up and the a wrong date forward is applied (i.e. October 8th becomes August 10th).

Thanks

Shift+Ctrl+Alt+V, but that doesn’t work on one line either. On purpose, because usually one line of text is just to be pasted.

1 Like