<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - after loading files in "csv-text-format" into the calc-application, formatting of date fields doesn't work correctly, because of quot-mark chars"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125929">125929</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>after loading files in "csv-text-format" into the calc-application, formatting of date fields doesn't work correctly, because of quot-mark chars
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.6.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>amu91@gmx.net
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>