https://bugs.documentfoundation.org/show_bug.cgi?id=134455
Mike Kaganski <mikekagan...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
CC| |er...@redhat.com
--- Comment #4 from Mike Kaganski <mikekagan...@hotmail.com> ---
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:
> 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
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
