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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134455
           Summary: Timevalue Err:502 REGRESSION
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: william.full.moon at gmail.com

Description:
Timevalue function produces "Err:502" on a long used and established formula.  

* This forula has not changed since 2015

* It is used to convert a number in minutes to a time value
    x Example: =TIMEVALUE("0:66") --> used to give "01:06" (one hour and 6
minutes).

* A spreadsheet included that works: v6.3.4.2, fails: v6.4.3.2

* The required result is a time value that is used in other time related
formulas.

* The error itself fails to provide an number time value.  For example time for
5 minutes:  =TIMEVALUE("0:05") -> "00:05" or 0.003472 (numeric)
    x No numeric version for:  =TIMEVALUE("0:66") is available, just the error
string.


Steps to Reproduce:
See attached example.

1.  Enter formula ' =TIMEVALUE("0:66")' should give 1 hour and 6 minutes
2.  So on for similar time values
3.  Foruma must give a decimal value suitable for use in further time
caculations.

Actual Results:
The resulting value is:

Err:502


Expected Results:
The correctly formatted time text string must be converted to a the
corresponding valid time value


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:

This is a SHOW STOPPER.  I must UNINSTALL the release version v6.4.3.

I must revert v6.3.4.2.

We use probably millions of time calculations in Excel or LibreOffice.  

This bug is a really serious Q/A failure.

LibreOffice About box included with the screen shots.

I hae not found out how to provide uploads/screenshots and sample spreadsheet.

-- 
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/992a93da/attachment.htm>