Bug Hunting Session
Bug 96312 - Add "Later than / earlier than" to date conditional formatting
Summary: Add "Later than / earlier than" to date conditional formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
 
Reported: 2015-12-07 16:21 UTC by Yan Pas
Modified: 2018-03-08 21:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
where to add (66.09 KB, image/png)
2015-12-07 16:21 UTC, Yan Pas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yan Pas 2015-12-07 16:21:41 UTC
Created attachment 121112 [details]
where to add

Date conditional formatting presets do not have useful options like Date later (or before) then "$TIME".
For example my project's deadline is 01.02.2016 17:00. I want to highlight cells, which have time more then this as RED. Currently I need to enter long formula:

OR(A1>DATE(2016;2;1); AND(A1>=DATE(2016;2;1); HOUR(A1)>16))

which is absolutely unhandy.
Comment 1 m.a.riosv 2015-12-07 23:56:12 UTC
Hi @Yan, thanks for reporting.

I would not expect is implemented in this way.

But I think you can use simpler formulas for what you like:
A1>=(DATE(2016;2;1)+TIME(17;0;0))
A1>=(DATE(2016;2;1)+17/24)
if you put the dead line in a cell e.g. D1, so it's possible change it without edit CF with Formula is.
A1>=D1
with Cell value is
[greater than or equal to] D1
Comment 2 Buovjaga 2015-12-10 09:48:18 UTC
Yan: are you happy with the solution in comment 1?
Comment 3 Yan Pas 2015-12-10 12:16:26 UTC
Yes, your solution is much easier, but I still think that adding these two entries to data list in cond formatting is necessary
Comment 4 Markus Mohrhard 2016-01-26 19:15:09 UTC
Actually I think it is a good proposal. The only open point is how to represent a date time in the UI and how to parse it as well as how to implement the OOXML export.