Bug 54008 - FILESAVE: if BETWEEN in Conditional Formatting, after save and reopen document the Conditional Formatting is spoiled
Summary: FILESAVE: if BETWEEN in Conditional Formatting, after save and reopen documen...
Status: RESOLVED DUPLICATE of bug 54077
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-24 13:54 UTC by Valentin
Modified: 2012-08-26 18:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
File show the bug for Between in conditonal formatting. (10.14 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2012-08-25 23:17 UTC, m_a_riosv 		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 Valentin 2012-08-24 13:54:59 UTC 
Problem description: 

Steps to reproduce:
1. Conditional Formatting 
2. "Cell value is" "Between" "01.01.2012" and "10.10.2012"
3. Save and reopen the file 

Current behavior: Conditional Formatting is spoiled.

No such problem with the older versions.

LibreOffice 3.6; Windows XP
Comment 1 Markus Mohrhard 2012-08-24 19:38:59 UTC 
Problem is already fixed in 3.6.1

Please test with 3.6.1.2 and reopen if not fixed there.
Comment 2 Valentin 2012-08-25 17:37:30 UTC 
Unfortunatelly, it doesn't work in 3.6.1.2 as well. Besides Conditional Formating with "Between" dates doesn't work at all in this version.
Comment 3 m_a_riosv 2012-08-25 23:17:05 UTC 
Created attachment 66121 [details]
File show the bug for Between in conditonal formatting.
Comment 4 m_a_riosv 2012-08-25 23:20:11 UTC 
(In reply to comment #3)
> Created attachment 66121 [details]
> File show the bug for Between in conditonal formatting.

Win7x64-LibreO-3.6.1.2

With dates Between never satisfy the condition.
Not Between always satisfy the condition.
Comment 5 Valentin 2012-08-26 08:45:25 UTC 
Date format syntax: '01.08.2012' after save and reopen becomes: "1,080,2012"
Date format syntax: '1/8/2012' is ok
Comment 6 Jean-Baptiste Faure 2012-08-26 09:12:57 UTC 
Indeed, I reproduce the problem for dates with LO 3.6.2.2 under Ubuntu 11.10 with FR localization.
I did tests with French dates formats (10/08/2012) and ISO format (2012-08-10). Neither one nor the other works. No problem with numbers.

Modified summary accordingly.

Best regards. JBF
Comment 7 Markus Mohrhard 2012-08-26 09:33:55 UTC 
Please never reopen a fixed bug report for a different problem. And please redo all the changes and close this bug report again and open anew one.

The original problem is fixed and you are now misusung this bug report for another problem that is not related with the first one. This might not be obvious but as soon as you noticed that the original bug description is fixed you should never reopen a bug report. The right solution is to open a new one with a new description and put the developer who fixed the bug report into cc.

Reopening a fixed bug and misusing it for a different bug report only creates problems and distracts developers and makes it harder to keep record of fixed bug and all references in the source code to this bug report are now more or less becoming useless.
Comment 8 Jean-Baptiste Faure 2012-08-26 10:44:51 UTC 
Hi Markus,

You are right. This bug report is a duplicate of bug 53010.

Best regards. JBF

*** This bug has been marked as a duplicate of bug 53010 ***
Comment 9 Markus Mohrhard 2012-08-26 17:58:55 UTC 

*** This bug has been marked as a duplicate of bug 54077 ***
Comment 10 Markus Mohrhard 2012-08-26 18:00:52 UTC 
I think it makes more sense right now to track it as duplicate of Bug 54007. The other problem is already fixed but as Rainer mentioned dates in conditional formats never really worked and I can imagine why but this is then not a regression in 3.6