[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vstuart.foote at utsa.edu

--- Comment #3 from V Stuart Foote <vstuart.foote at utsa.edu> ---
Created attachment 161154
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161154&action=edit
Text import dialog for the Semicolon separated CSV attachment 161149

I had no issues importing the CSV using the Text Import dialog.

I had to be sure the locale set used comma as decimal separator (Tools ->
Options -> Languages) and on the Text Import dialog, to set the Searator
Options to _just_ the Semicolon check box. I also set the Fields column type to
correct date format determined visual scan of the preview.

On import sheet is created with 7109 rows, no LO complaint/warning and visual
inspection all cells seem correctly populated with no run overs.

-- 
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/20200522/efcd15ab/attachment.htm>