Created attachment 114835 [details] TAB separated file that LibreOffice does not import correctly I tried importing a TAB separated text file (see attachment). Unfortunately, LibreOffice only imports 163 lines of 231 correctly. All other lines are imported into a single line. In Microsoft Excel the import works without any issue...
(In reply to Ronny Standtke from comment #0) > Unfortunately, > LibreOffice only imports 163 lines of 231 correctly. All other lines are > imported into a single line. I can confirm this. After a quick look at the file, problem is cause by double-quotes just after the Tan in line 163: Invalid_Partition_Size "{0}" is no valid partition size. Please use inter values. Changing "Text delimiter" to single quote cure the problem. I don't know if we should consider this as a bug, so I let status to Unconfirmed waiting for another opinion.
(In reply to GerardF from comment #1) > After a quick look at the file, problem is cause by double-quotes just after > the Tan in line 163: correction typo: read Tab.
(In reply to GerardF from comment #1) > (In reply to Ronny Standtke from comment #0) > > Unfortunately, > > LibreOffice only imports 163 lines of 231 correctly. All other lines are > > imported into a single line. > > I can confirm this. > After a quick look at the file, problem is cause by double-quotes just after > the Tan in line 163: > > Invalid_Partition_Size "{0}" is no valid partition size. Please use inter > values. > > Changing "Text delimiter" to single quote cure the problem. > I don't know if we should consider this as a bug, so I let status to > Unconfirmed waiting for another opinion. Sure not a bug. just change Text delimiter: to ' or delete it as Gerard wrote. Then import contain 231 rows. Closing as notabug.