<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - If cell is formatted as time or duration, then allow inputs with parts greater than 59"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135249#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - If cell is formatted as time or duration, then allow inputs with parts greater than 59"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135249">bug 135249</a>
from <span class="vcard"><a class="email" href="mailto:gabrielhml@hotmail.com" title="gabrielhml@hotmail.com">gabrielhml@hotmail.com</a>
</span></b>
<pre>This is tricky
It is also possible that the person writes 1:1:40 but does not mean time
I agree with the suggestion that if the first particles are 0: or 00: then it
should be understood as time,
but more than that, it would be nice if as a general rule Calc would try to
conform to the format of the cell. This would apply to other cases too.
For example, when I have a date cell, if I input "1/5" it identifies a date.
But if I input "1/2" it identifies as simply a "half". But the fact that I am
writing "1/2" on a cell that was formated as a date should tell Calc that I
actually mean a date. (maybe we could open a suggestion for this as well)
In this case, if the cell is formatted as time, then it should override
whatever other function and try to treat the cell as time. Calc doesn't have to
try to decipher what the user is trying to input if the user has already stated
what he is trying to input on the cell's formatting.</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>