https://bugs.documentfoundation.org/show_bug.cgi?id=158694
Bug ID: 158694
Summary: TEXT() function is not formatting months correctly.
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I want to display the current month name from a date-formatted cell. I am using
the TEXT function as follows: =TEXT(month(cell-id),"MMMM"). Cell-id is the cell
containing the date.
Steps to Reproduce:
1.Enter 1/1/23 in cell A1, 1/2/23 in A2, 1/3/23 in A3, etc until 1/12/23 in
A12.
2.Enter =MONTH(A1) in B1, =MONTH(A2) in B2, and copy down to MONTH(A12) in B12.
3.Enter =TEXT(B1,"MMMM") in C1. Copy down to and including C12.
Actual Results:
C1 shows "December".
C2 - C12 all show "January".
Expected Results:
C1 should show January, C2 February, C3 March and so on down to C12 which
should show December.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
