[Libreoffice-bugs] [Bug 125929] New: after loading files in "csv-text-format" into the calc-application, formatting of date fields doesn't work correctly, because of quot-mark chars

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125929
           Summary: after loading files in "csv-text-format" into the
                    calc-application, formatting of date fields doesn't
                    work correctly, because of quot-mark chars
           Product: LibreOffice
           Version: 6.1.6.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: amu91 at gmx.net

Description:
When loading files in „.csv-text-format“ into the calc-application, unwanted „
' “-Characters (single quotation marks) are prepositioned to „date-fields“ by
the program. These become only visible to the user in the program, if the
format of the „date-field“ is changed. Only after extinguishing of theese
unwanted Characters, the „date-field“ is shown properly formatted in the way,
the user has selected, for instance yyyy-mm-dd.

Steps to Reproduce:
1. Import an example-file containing date fields in csv-format into spreadsheet
application (calc)
2. Mark some date-fields to change their format
3. Change the format of date, for instance from dd.mm.yyyy to yyyy-mm-dd
4. See, that the change has no effect
5. See the selected field in the edit-box: there is a quotation mark at the
beginning of the field
6. Remove this quotation mark character
7. See, that now the field is formatted in the way, the user wanted

Actual Results:
the program inserts unwanted quotation-mark-characters, which prevent the
fields to bee formatted correctly

Expected Results:
the program should not do this, as it did in very old versions, for instance
5.0.5.2


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.1.6.3 (x64)
Build-ID: 5896ab1714085361c45cf540f76f60673dd96a72
CPU-Threads: 16; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-CH (de_CH); Calc: group threaded

-- 
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/20190614/25a10a13/attachment-0001.html>