Bug 127975

Summary:	convert text in board doesn't work
Product:	LibreOffice	Reporter:	totolafrimousse
Component:	Writer	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	buzea.bogdan, serval2412
Priority:	medium
Version:	6.3.2.2 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description totolafrimousse 2019-10-05 15:27:26 UTC

Description:
when y try to convert in board a selected part of text in a .txt file the résult is a lot of cell board. Writer does not use separator char to create collums

Steps to Reproduce:
1.open a txt file with lines like 
" text1; text2;text3
  auther text1; auther text2; auther text3
...."
2. select text
3. menu > board > covert text to board
4. in form choose ";" as collum separator 


Actual Results:
bad construction of board

Expected Results:
A good board whith collum created by ";"


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Y am french and y use the french version.

Comment 1 Julien Nabet 2019-10-05 17:20:07 UTC

On pc Debian x86-64 with LO Debian package 6.3.2, I don't see anything wrong.

Could you provide the txt file example + odt file?

Comment 2 totolafrimousse 2019-10-08 12:57:57 UTC

Hi
I can explain the problem:
1 I made a copy of txt from a web page
2 I made a paste in a new writer document
3 I tried to convert txt in board (no work correctly) then ctrl Z and save in txt file
4 With notpad + i looked at the no visible chars in the txt file and i see LF in the and of lines.
5 With notpad + i changed LF in CR LF on all the lines
6 I made a copy from my new txt file and paste in writer document.
7 then to convert txt in board was OK
Thank you for your fantastic libre office.

Comment 3 Julien Nabet 2019-10-08 13:44:15 UTC

Would it be possible you indicate the website?
Indeed, when I tested by copying paste your example in comment 1:
" text1; text2;text3
  auther text1; auther text2; auther text3
...."
the table conversion was ok on Writer.

Comment 4 totolafrimousse 2019-10-08 14:20:09 UTC

https://www.visorando.com/randonnee-boucle-de-puy-saint-pierre/

I make a copy from part titeled "Points de passage :" in this page

D/A : km 0 - alt. 1250m - Parking Géant Casino
1 : km 0.42 - alt. 1231m - Pont sur la Guisane - Carrefour de la boucle
2 : km 0.55 - alt. 1233m - La Ribière - Départ de chemin
3 : km 0.96 - alt. 1290m - Canal des Queyrelles
4 : km 1.85 - alt. 1287m - Route
5 : km 2.53 - alt. 1297m - Le Pinet
6 : km 3.38 - alt. 1346m - Canal Neuf
7 : km 3.91 - alt. 1382m - Fourche
8 : km 4.8 - alt. 1543m - Puy-Saint-Pierre
9 : km 8.25 - alt. 1426m - Chemin vers Pramorel
10 : km 9.04 - alt. 1328m - Route ancienne de Pramorel
11 : km 9.91 - alt. 1244m - Pont sur la Guisane
D/A : km 10.84 - alt. 1250m - Parking Géant Casino

first i tryed with "-" char as separator then i replaced "-" with ";" char
no good result then replacing LF by CR LF with notpad+ result OK

Comment 5 Julien Nabet 2019-10-08 14:25:47 UTC

On Win10 with LO 6.3.2, I could reproduce this.
I noticed that if you copy from website then unformatted paste, it worked.

Comment 6 totolafrimousse 2019-10-08 15:08:17 UTC

OK Thank you. This way make a paste with CR LF. i notice to use this method.
Sorry for my ignorance.