https://bugs.documentfoundation.org/show_bug.cgi?id=170543
Bug ID: 170543
Summary: Formatting Text(<nr>; "mmmm) function returns wrong
result with month numbers
Product: LibreOffice
Version: 25.8.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:
On alist with dates grouped by month, putting the related month's name has
brought weird results. My function for each is =Text(<month-nr>; "mmmm")
Month 1 resulted in "Januar" (German for January)
Months 2..12 resulted each in "Dezember" (German for December).
Steps to Reproduce:
1. Put some date with month from Febraury to December
2. Use Month() function of the date
3. Use Text(<Month() result>; "mmmm")
4. check resulting formatted month' name
Actual Results:
1. Put some date with month from Febraury to December in say cell A1
2. Put =Month(A1) in cell B1
3. Put =Text(B1; "mmmm") in cell C3
4. check resulting formatted month' name in C3
Expected Results:
For Month(2) I expect formatted string to be Februar / february
... 3 - " - März / march
... 4 - " -
... ... ... ... ... ...
... 11 - " - November
... 12 - " - Dezember / December
Reproducible: Always
User Profile Reset: No
Additional Info:
I don't have clue what you're expecting here...
The help files don't include formatting a number with "mmmm".
If you appreciate additonal feedback, on the end of this bug report page,
relating to attachments, you tell "once the bug is filled." Maybe you mean "the
bug is filed" ?
--
You are receiving this mail because:
You are the assignee for the bug.
