https://bugs.documentfoundation.org/show_bug.cgi?id=158845
Bug ID: 158845
Summary: function NUM.SETTIMANA (or NUM.WEEK in english) gives
wrong results for a leap year
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
function NUM.SETTIMANA (or NUM.WEEK in english) in Libreoffice Calc gives 1
for the date of 30/12/2024 rather than 53 !
Then next year is a leap year!
Steps to Reproduce:
1.set A1 value to 30/12/2024
2.set B1 to formula =NUM.SETTIMANA(A1)
3.
Actual Results:
1
Expected Results:
53
Reproducible: Always
User Profile Reset: No
Additional Info:
The next year has 29 february.
The same function in other spreadsheets gives the correct answer that is 53
--
You are receiving this mail because:
You are the assignee for the bug.
