https://bugs.documentfoundation.org/show_bug.cgi?id=146235
Bug ID: 146235
Summary: Wrong value from TEXT function in CALC on calculated
dates (Rel. Versione: 6.4.7.2 Build ID:
1:6.4.7-0ubuntu0.20.04.2 Thread CPU: 4; SO: Linux 5.4;
Resa interfaccia: predefinito; VCL: gtk3; Versione
locale: it-IT (it_IT.UTF-8); Lingua interfaccia:
it-IT)
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The TEXT function appears to give a wrong result if used on a calculated date.
Steps to Reproduce:
Example:
1) Set A1 to 31/01/2022
2) Set B1 to =A1+1
3) Set C1 to =TEXT(MONTH(B1);"MMMM") (nella versione italiana è
=TESTO(MESE(B1);"MMMM")
Actual Results:
result displayed is january (nella versione italiana è gennaio)
Expected Results:
instead of february (nella versione italiana deve essere febbraio)
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
the MONTH function applied to B1 cell gives the correct result (2)
Versione: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.2
Thread CPU: 4; SO: Linux 5.4; Resa interfaccia: predefinito; VCL: gtk3;
Versione locale: it-IT (it_IT.UTF-8); Lingua interfaccia: it-IT
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
