Bug 106516

Summary:	Start of week does not come from locale in conditional formatting
Product:	LibreOffice	Reporter:	Aron Budea <aron.budea>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	cno
Priority:	medium	Keywords:	implementationError
Version:	4.0.0.3 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	87351
Attachments:	Screenshot

Description Aron Budea 2017-03-12 20:43:17 UTC

Created attachment 131836 [details]
Screenshot

In an empty spreadsheet I set A1-A20 to 2017-03-01 to 03-20, and set conditional formatting with condition: Date is / This week / Apply Style: Warning. This colors text in the relevant cells red.
Today is a beautiful Sunday (2017-03-12), and my locale is set to Hungarian (relevant detail: start of the week is Monday).

Bug: Calc considers week from Sunday to Saturday instead of Monday to Sunday (based on locale). See cells A12-A18 in attached screenshot.

Markus' comment from IRC:
<@moggi> bearon: good point with sunday vs monday, can you open a bug report? it is hard coded in the code

Comment 1 Aron Budea 2017-03-12 20:46:56 UTC

First version "Date is" option is available from is 4.0.0.3. Also tested with 5.3.1.2.

Comment 2 Cor Nouws 2017-03-12 21:17:04 UTC

Hey Aron,

Looks as bug 70551.

*** This bug has been marked as a duplicate of bug 70551 ***

Comment 3 Aron Budea 2017-03-13 04:12:38 UTC

Hey Cor! How certain are you about these two bugs being the same? I was a bit surprised to find that WEEKS() is an add-in function (not sure what that means), and not part of the standard date/time functions.