https://bugs.documentfoundation.org/show_bug.cgi?id=172741
Bug ID: 172741
Summary: "year, month, day" function is not working in Calc
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I encounterd bug in Calc, that function is not working.
Windows11
AMD CPU
X86_64
Same bug include at leaset v25.2.x, v25.8.x, v26.2.x.
Just display formula.
=year(date cell)
=month(date cell)
=day(date cell)
e.g. If I entered =year(B2) and B2 cell is dae "2026/07/01", then calc respond
=year(B2) not "2026"
Steps to Reproduce:
1.=year(date cell)
2.=month(date cell)
3.=day(date cell)
Actual Results:
Calc just displayed entered formula.
e.g. If I entered =year(B2) and B2 cell is dae "2026/07/01", then calc respond
=year(B2)
Expected Results:
e.g. If I entered =year(B2) and B2 cell is dae "2026/07/01", then calc respond
"2026"
Reproducible: Always
User Profile Reset: No
Additional Info:
In my check, same bug include at leaset v25.2.7.2, v25.8.7, v26.2.4.
Windows11
x86_64
AMD CPU
--
You are receiving this mail because:
You are the assignee for the bug.
