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@lists.freedesktop.org
Reporter: william.full.m...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
