[Libreoffice-bugs] [Bug 70111] CSV files to keep the original text delimiters and separators

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

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

--- Comment #10 from V Stuart Foote <vstuart.foote at utsa.edu> ---
Created attachment 171606
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171606&action=edit
Calc's 'Text Import' dialog with field separator setting for filtered import of
CSV, and reused at export

(In reply to Xisco Faulí from comment #9)
> (In reply to aljosha.papsch from comment #6)
> > Yes, the issue persists to this day.
> > 
> > Version: 6.0.5.2
> > Build-ID: 6.0.5-1
> > CPU-Threads: 4; BS: Linux 4.17; UI-Render: Standard; VCL: gtk3; 
> > Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
> > 
> > Steps to reproduce:
> > 
> > 1. Create a file test.csv with the contents:
> > 
> > foo;bar
> > 
> > 2. Open the file in Calc, leaving the import settings untoched.
> > 3. Write "baz" in A2, "quux" in B2.
> > 4. Choose File | Save and confirm CSV format.
> > 
> > Expected file contents:
> > 
> > foo;bar
> > baz;quux
> > 
> > Actual file contents:
> > 
> > foo,bar
> > baz,quux
> 
> Still reproducible in
> 
> Version: 7.1.4.0.0+ / LibreOffice Community
> Build ID: 06d5d625e1dc8489e51b962353ac423669e61fed
> CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
> Locale: en-US (en_US.UTF-8); UI: en-US
> Calc: threaded

Xisco, please rethink. When I take the simple step of setting values (i.e.
removing undesired separators) from the 'Text Import' dialog--the format is
retained on export save back to .CSV

It is an export filter action, not a native format, of a document that has been
taken through import filters.

Setting a format on import (here removing <Tab> & <Comma>), that is then
maintained for the export, is a reasonable accomodation. And a requirement
justifiable for reasonable workflows.

CSV are not native formats, we don't "edit" CSV.

-- 
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/20210503/5711c868/attachment.htm>