https://bugs.documentfoundation.org/show_bug.cgi?id=159148
Bug ID: 159148
Summary: Entering more than 65535 hours reset the count
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191889
--> https://bugs.documentfoundation.org/attachment.cgi?id=191889&action=edit
Hours are limited to 65,536
Entering more than 65,535 hours in a cell returns the value modulo 65,536.
Steps to reproduce:
1. In cell A1, enter 65000:00, then enter. Cell A1 shows 65000:00 (format
[HH]:MM)
2. In cell A2, enter 66000:00, then enter. Cell A2 shows 464:00. This is wrong,
the cell is now equal to 66000 mod 65536. Note that 65536 is equal to 2^16, so
there must be a wrong type of variable somewhere.
3. In cell A3, enter 65000:00, then enter.
4. In cell A4, enter =A1+A3. Cell A4 shows the correct calculation, 130000:00.
--
You are receiving this mail because:
You are the assignee for the bug.
