https://bugs.documentfoundation.org/show_bug.cgi?id=172097
Bug ID: 172097
Summary: The formatted result of a sample formula in DATE
function help is incorrect
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Description:
The formatted result of a sample formula in DATE function help is incorrect.
Steps to Reproduce:
1. Open Date function page.
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_date.html
2. See "Examples".
LibreOffice 26.2 Help [2026-05-15]
=DATE(00;1;31) yields the date 2000-01-31
written as 1/31/00 if the cell format setting is MM/DD/YY.
^^^^^^^ ^^^^^^^^
Actual Results:
3. written as 1/31/00
Expected Results:
3. written as 01/31/00
Probably this is what he meant to say.
Reproducible: Always
User Profile Reset: No
Additional Info:
Probably it would be better to correct the results rather than changing the
format.
--
You are receiving this mail because:
You are the assignee for the bug.
