Summary: | Allow flexible start-of-week days in Previous/This/Next Week conditional formattings | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Roman Kuznetsov <79045_79045> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | erack, marina.latini |
Priority: | medium | ||
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: |
wrong CF with Date (this week)
wrong CF with Date (this week) in LibreOffice Calc 5.4.7 |
Description
Roman Kuznetsov
2018-08-21 19:17:20 UTC
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. |