Bug 119494 - Conditional formatting error using "this week"
Summary: Conditional formatting error using "this week"
Status: RESOLVED DUPLICATE of bug 119402
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2018-08-25 14:44 UTC by Marcos Cabanas Esteves
Modified: 2018-08-25 16:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Image demonstrating failure (1.08 MB, image/png)
2018-08-25 14:48 UTC, Marcos Cabanas Esteves
LibreOffice file with failure already performed (10.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-25 14:49 UTC, Marcos Cabanas Esteves

Note You need to log in before you can comment on or make changes to this bug.
Description Marcos Cabanas Esteves 2018-08-25 14:44:55 UTC
When I select the conditional formatting and use the condition "THE DATE IS" "THIS WEEK", LibreOffice finishes formatting eleven days.

Therefore, it is a bug since the correct one would be the mark of only seven days. It is worth mentioning that the conditions "PREVIOUS WEEK" and "NEXT WEEK" are working correctly.

I therefore report the same and wish everyone a good week.

Steps to Reproduce:
1. Produce a spreadsheet with sequences dates of 15 days from the current date, for example
2. Select the "Date" option in Format -> Conditional Formatting -> Date.
3. Create the following condition: "The date is" "This week". Choose any style (I've used neutral). When finished, click ok.

Actual Results:
The result obtained shows that eleven cells were formatted as "THIS WEEK".

Expected Results:
The expected result would be that only the cells for the current week were formatted. In other words, that only 7 cells were formatted.

Reproducible: Always

User Profile Reset: Yes

OpenGL enabled: Yes

Additional Info:
Comment 1 Marcos Cabanas Esteves 2018-08-25 14:48:35 UTC
Created attachment 144434 [details]
Image demonstrating failure
Comment 2 Marcos Cabanas Esteves 2018-08-25 14:49:38 UTC
Created attachment 144435 [details]
LibreOffice file with failure already performed
Comment 3 Xisco Faulí 2018-08-25 16:57:51 UTC
Thanks for reporting this issue.
This is a dupe of bug 119402 and it will be fixed in LibreOffice 6.1.1

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