<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Date acceptance pattern can interfere with entering decimal numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116184">bug 116184</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>oliver.brinzing@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Date acceptance pattern can interfere with entering decimal numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116184#c27">Comment # 27</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Date acceptance pattern can interfere with entering decimal numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116184">bug 116184</a>
from <span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span></b>
<pre>i can confirm this too.
for convenience we added "D." to Date acceptance patterns.
this worked by default with AOO 4.1.5, but with LO it has
some side effects.
steps to reproduce:
- Menu Tools/Options/Language Settings/Languages
-> Locale setting: "German (Germany)"
-> add to Date acceptance patterns: "D."
- create new spreadsheet
- enable Menu "View/Value Highlighting"
- cell A1, enter: 1.
-> Date: 01.04.19
- cell B1, enter: -1.234,56
-> Text: -1.234,56
- Cell B2, enter: =Value(B1)
-> Err:522
now remove "D." from Date acceptance patterns and
- create new spreadsheet
- cell A1, enter: 1.
-> Text: 1.
- cell B1, enter: -1.234,56
-> Value: -1234,56
- cell B2, format as Text @ and enter: -1.234,56
- cell B3, enter: =Value(B2)
-> Value: -1234,56</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>