Using Calc in LO 6.4.2.2 on Ubuntu 18.04, but also on OnlyOffice 5.4.2 shipping with Nextcloud 18.0.3, I’m experiencing this:
Cell A1 contains a date, i.e. 03-02-20. Cell is formatted as date as well.
Formula in cell A2:
="Week "&(WEEKNUM(A1;21))&" ("&TEXT(A1;"DD")&" - "&TEXT((A1+6);"DD"&" "&TEXT(A1;"MMMM")&")")
Expected result:
Week 6 (3 - 9 february)
Actual result (LO 6.4.2.2, set to Dutch):
Week 6 (3 - 9 f20b20200a2020i)
Actual result (OnlyOffice 5.4.2):
Week 6 (3 - 9 fruri)
Can someone please try the formula above and confirm this bug?