Bug 54077 - Conditional FORMATTING needs day number instead of formatted date in condition
Summary: Conditional FORMATTING needs day number instead of formatted date in condition
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 54008 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-08-26 10:52 UTC by Jean-Baptiste Faure
Modified: 2013-12-12 15:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Test kit (14.79 KB, application/x-7z-compressed)
2012-08-26 15:35 UTC, Rainer Bielefeld Retired 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Baptiste Faure 2012-08-26 10:52:47 UTC 
Steps to reproduce:
- Open a new spreadsheet with LO 3.6.1.2
- in A1 type the date 2012-08-31
- Format > Conditional Formatting > Conditional Formatting > Add a "value is" with 2012-08-31 value and choose the style Results as style to apply

Current behavior: the Result style is not applied.

Best regards. JBF
Comment 1 Jean-Baptiste Faure 2012-08-26 10:55:27 UTC 
Hi Markus,

This one seems to be for you.

Best regards. JBF
Comment 2 Rainer Bielefeld Retired 2012-08-26 15:34:32 UTC 
For me that never worked, same results with  with Server Installation (own profile) of "LibreOffice 3.4.5 RC1  - WIN7 Home Premium (64bit) German UI [Build ID: OOO340m1 (Build:501)]" and with Server Installation of "LibreOffice 3.3.3  German UI/Locale [OOO330m19 (Build:301) tag libreoffice-3.3.3.1] on German WIN7 Home Premium (64bit) 

Results with 3.6.1 and 3.4.5 see attached samples created with LibO 3.6.1 and LibO 3.4.5. 

Conditional Formatting needs the day number "41147" in condition, that will work. Any formatted in condition seems to fail.

All the same opening my sample documents with AOOo 3.4. so the problem seems inherited from OOo

BTW, Autofilter is more flexible, recognizes 26.8., 2012-08-26 and 41147 correctly in the same column as filter condition.
Comment 3 Rainer Bielefeld Retired 2012-08-26 15:35:23 UTC 
Created attachment 66138 [details]
Test kit

Sample documents, see previous comment
Comment 4 Markus Mohrhard 2012-08-26 17:58:55 UTC 
*** Bug 54008 has been marked as a duplicate of this bug. ***
Comment 5 Markus Mohrhard 2012-08-26 18:02:15 UTC 
I have an idea why it is not possible but need to check it. If my suspicion is correct this is an old bug and not a regression in 3.6
Comment 6 Rainer Bielefeld Retired 2012-08-27 14:34:37 UTC 
@Markus:
Can you please check whether this one has any influence to "Bug 54084 - In Conditional FORMATTING dialog fields date '01.08.2012' after reopen becomes: '1,080,2012'"
Comment 7 Markus Mohrhard 2012-08-28 12:03:30 UTC 
(In reply to comment #6)
> @Markus:
> Can you please check whether this one has any influence to "Bug 54084 - In
> Conditional FORMATTING dialog fields date '01.08.2012' after reopen becomes:
> '1,080,2012'"

They are having most likely the same root cause. The date detection does not work in conditional format code and the result is that the code tries to interpret the string as a number.
Comment 8 Markus Mohrhard 2012-08-28 13:58:57 UTC 
Comment from Eike our expert for such things:

This can't work, if you need to use dates in these formulas use the DATE
function.

This is not a bug and will not be changed.
Comment 9 Jean-Baptiste Faure 2012-08-28 18:29:52 UTC 
(In reply to comment #8)
> Comment from Eike our expert for such things:
> 
> This can't work, if you need to use dates in these formulas use the DATE
> function.

Indeed, it works with DATE function. Unfortunately this info is not in the help.

Many thanks to Eike.

Best regards. JBF