Download it now!
Bug 119407 - Allow flexible start-of-week days in Previous/This/Next Week conditional formattings
Summary: Allow flexible start-of-week days in Previous/This/Next Week conditional form...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-08-21 19:17 UTC by Roman Kuznetsov
Modified: 2018-08-24 23:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
wrong CF with Date (this week) (15.92 KB, application/octet-stream)
2018-08-21 19:19 UTC, Roman Kuznetsov
Details
wrong CF with Date (this week) in LibreOffice Calc 5.4.7 (68.39 KB, image/png)
2018-08-21 19:20 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-08-21 19:17:20 UTC
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:
Comment 1 Roman Kuznetsov 2018-08-21 19:19:41 UTC
Created attachment 144353 [details]
wrong CF with Date (this week)
Comment 2 Roman Kuznetsov 2018-08-21 19:20:19 UTC
Created attachment 144354 [details]
wrong CF with Date (this week) in LibreOffice Calc 5.4.7
Comment 3 Eike Rathke 2018-08-22 18:15:05 UTC
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?
Comment 4 Roman Kuznetsov 2018-08-22 18:19:57 UTC
(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.
Comment 5 Eike Rathke 2018-08-22 18:24:38 UTC
Thanks, so notabug.
Comment 6 Roman Kuznetsov 2018-08-22 18:29:15 UTC
(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?
Comment 7 Eike Rathke 2018-08-23 09:26:06 UTC
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.