<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Timevalue Err:502 REGRESSION"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134455">bug 134455</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;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Timevalue Err:502 REGRESSION"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134455#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Timevalue Err:502 REGRESSION"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134455">bug 134455</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>Confirmed in Version: 6.4.5.2 (x64)
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win;
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL
OASIS OpenDocument 6.1.18 tells:
<span class="quote">> TIMEVALUE
> Summary: Returns a time serial number from given text.
>
> Syntax: TIMEVALUE( Text T )
>
> Returns: Time
>
> Constraints: None
>
> Semantics: This computes the serial number of the text string T, which is a time,
> using the current locale. This function shall accept ISO time format (HH:MM:SS),
> which is locale-independent. If the text of T has a combined date and time format,
> e.g. YYYY-MM-DD HH:MM:SS, the fractional part of the date serial number is returned.
> If the text of T does not have a time format, an evaluator may attempt to convert
> the number another way (e.g., using VALUE), or it may return an Error (this is
> implementation-dependent).
>
> See also TIME 6.10.17, DATE 6.10.2, DATEVALUE 6.10.4, VALUE 6.13.34</span >
As I read it, it accepts *a* time format (see the "If the text of T does not
have a time format"), so the requirement to accept ISO time format is not
exclusive, but a minimal requirement, not denying accepting other formats like
non-ISO "0:66". Additionally, there's an explicit provision that the value may
be converted using *another* (unspecified) way (and an example given, which
again is not exclusive).
This issue creates interoperability problem, since e.g. MS Excel 2016 accepts
such values, thus formulas working in Excel don't work in Calc.</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>