[Libreoffice-bugs] [Bug 144842] LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144842

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
That data doesn't look space-separated but fixed-width.
But even if it was space-separated it would not fulfil the criteria for quoted
fields because for that the *entire* field content has to be "enquoted like
this", which
logdesc="SSL VPN tunnel up"
or any other of that data is not.

Import as fixed-width, placing a column separator between column 40/41 and if
after import you want to get rid of the extra spaces in column A then use a
formula in C1 =TRIM(A1) and fill that down until end of data. You may then copy
those results into clipboard and Paste-Special it onto the data in column A,
only Strings but not Formulas.

Not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210930/2709f8b5/attachment-0001.htm>