https://bugs.documentfoundation.org/show_bug.cgi?id=123365
Bug ID: 123365
Summary: Calculation of time values of by one with custom
formating
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: maximilian.j.walter+li...@gmail.com
Description:
The calculation with time value with a custom formating are off by one minute.
It happens mostly for negative value calculations.
Steps to Reproduce:
1.Format Cells with custom formater [HH]:MM
2. Enter 40:00 in Cell A1
3. Enter 3:29 in Cell B1
4. Enter 45:29 in Cell C1
5. Enter =A1-C1+B1 in D1
Actual Results:
-1:59
Expected Results:
-2:00
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Linux 4.20; UI render: default; VCL: gtk3;
Flatpak
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded
--
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
