[Libreoffice-bugs] [Bug 134455] Timevalue Err:502 REGRESSION

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134455

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|                            |erack at redhat.com

--- Comment #4 from Mike Kaganski <mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200702/4573d37f/attachment.htm>