Unable to include empty cell in excel sheet

[rajgopalbh4]

I am trying to paste this two lines , but in second line after this value 360239 there is an empty cell . so I am loosing this values(360239 | 929862 | 375 ) after pasting in my excel document .

884 | 637 | 1521 | 1080753 | 640934 | 1721687 | 32542972 | 6324
319 | 0 | 319 | 360239 | | 360239 | 929862 | 375

can some one please tell me how to include the remaining values after the empty cell while pasting the data.

Thank you .

[gabix]

Untick Skip empty cells in the dialog that appears when you paste the text.

[rajgopalbh4]

Okay I started using the latest version but still the problem did not solve even after Unticking the Skip empty cells

[gabix]

Read the other answer.

[rajgopalbh4]

while copying the values from terminal I am not able to find this option gabix
"Skip empty cells "

[gabix]

Do not answer your own question (unless you have found a real answer). Modify the original question or use the comment field.

What is the LO version that you use? Perhaps, you should upgrade.

[rajgopalbh4]

I am using 6.0.0.1 version . Is the option to “skip the empty cells” available in latest version ?

[gabix]

It is available in 6.3.2.2 that I use.

[anon73440385]

Hello,

your answer ( which isn’t an answer but additional details and should go to the question details using edit functionality) seems to show you selected | as a string delimiter, which is wrong. | is the separator and the String delimiter should be empty (there is none).

Have tested on my system and if using the same incorrect | setting for string delimiter, this produces the same behavior you face (to be precise: 360239 | 929862 | 375 end up in cell E2, if import starts at A1)

Hope that helps.