https://bugs.documentfoundation.org/show_bug.cgi?id=159421
Bug ID: 159421
Summary: calc date function returns wrong value
Product: LibreOffice
Version: 7.6.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rps...@cox.net
Description:
Date function works with literal values but is unreliable with calculated
values. This occurred in both 7.6.2 and just now installed 7.6.4.
Steps to Reproduce:
1.PICK A CELL, A10, TYPE 4.15202
2.IN CELL B10 TYPE =INT(A10)
3.IN CELL C10 TYPE =A10-B10
IN CELL D10 TYPE =C10*100
IN CELL E10 TYPE =INT(D10)
IN CELL F10 TYPE =D10-E10
IN CELL G10 TYPE =F10*10000
IN CELL H10 TYPE =DATE(G10,B10,E10)
Actual Results:
IN H10: 04/15/2021
Expected Results:
IN H10: 04/15/2022
Reproducible: Always
User Profile Reset: Yes
Additional Info:
TOO BAD THE HELP INF REQUESTED CAN NOT BE COPIED!
Version: 7.6.4.1 (X86_64)
Build: e16e193f88cd6c0525a17fb7a...
Environment: CPU threads: 24; OS: Windows 10.0 build 22621
User interface: UI render: Skia/Raster; VCL: win
Locale: en-US (en-US); UI: en-US
Misc: Calc threaded
--
You are receiving this mail because:
You are the assignee for the bug.
