Description: Calc: Wrong first week day for RU locale (previous Sunday instead Monday) This wrong result gives conditional formatting with condition : Date - This week (or Last week or Next week) Steps to Reproduce: 1. Open file from attach (Attention! now in LO 6.0 and 6.1 we have another bug 119402 with 9 days in this week instead 7) 2. In RU locale week should start with Monday, but now Conditional formatting in Calc start week with previous Sunday and end it in Saturday (see attach). Actual Results: week starts with previous Sunday for RU locale Expected Results: week starts with Monday for RU locale Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 144353 [details] wrong CF with Date (this week)
Created attachment 144354 [details] wrong CF with Date (this week) in LibreOffice Calc 5.4.7
The Previous/This/Next Week conditional formattings are not locale dependent and the week always starts on Sunday. AFAIK they mimic the Excel behaviour. Or does Excel adapt to the current locale? If someone could check that?
(In reply to Eike Rathke from comment #3) > The Previous/This/Next Week conditional formattings are not locale dependent > and the week always starts on Sunday. AFAIK they mimic the Excel behaviour. > Or does Excel adapt to the current locale? If someone could check that? In RU Excel i have the same behaviour. I checked in MS Excel 2007, 2010 and 2016.
Thanks, so notabug.
(In reply to Eike Rathke from comment #5) > Thanks, so notabug. I don't agree. To have functional one to one as in Excel is good, but why do we have wrong functional? LibreOffice should be better than MSO. Eike, may be this is a really bug?
I second that calculating the week locale dependent would be "more natural" in some cases. However, if we derive from what Excel calculates we'll get bug reports from people that open their Excel documents and the calculation differs. Another problem is that if you open the same document in different locales you may get different results. The only solution to that would be an extra option to determine the start of week, which again needs to be stored as file format extensions as neither ODF nor OOXML provide means for it. We can change this bug into an RFE though as it is a valid request.