[Libreoffice-bugs] [Bug 140010] New: Export as CSV should always "quote" Text fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140010
           Summary: Export as CSV should always "quote" Text fields
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: filters and storage
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

Description:
When importing from CSV, the "Format quoted fields as text" provides a way to
distinguish text from numeric fields.

However the corresponding export-to-CSV feature is missing: There is no way to
generate a CSV with Text fields quoted.  So the format gets lost in a
round-trip from spreadsheet to CSV and back to spreadsheet (often needed to use
text-oriented tools to manipulate the data).

IMO exporting to CSV should, by default quote fields which have Text (not
numeric) format even if they don't contain special characters (for example
numers).

Steps to Reproduce:
1. Load attached demo.ods spreadsheet; verify that the format of A2 is Text and
B2 is Number(General)
2. File->Save As... change file Name and set output drop-down to Text CSV(.csv)
3. File->Open...  navigate to the saved .csv file
     Check "Format quoted field as text"
4. Check format of A1 (rightclick->Format Cells...->Numbers:Category)

Actual Results:
A2 has numeric format in the imported document, rather than Text

Expected Results:
Export should have quoted A2 because it was Text, so it could be imported as
Text


Reproducible: Always


User Profile Reset: No



Additional Info:
.

-- 
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/20210129/1fca5a6a/attachment.htm>