Follow https://bugs.freedesktop.org/show_bug.cgi?id=54008 found in "Conditional Formatting" date syntax (d.m.Y): "01.08.2012" after reopen becomes: "1,080,2012" BG locale, Windows XP, LO 3.6.1.2
[Reproducible] with "LibreOffice 3.6.1.2 German UI/Locale [Build-ID: e29a214] on German WIN7 Home Premium (64bit) and Attachment 66121 [details] for Bug 54008 I open that document, add a blank in an empty cell, save under new name, close and reopen, no unexpected date formatting. @reporter: Thank you for your report – unfortunately important information is missing. May be hints on <http://wiki.documentfoundation.org/BugReport> will help you to find out what information will be useful to reproduce your problem? If you believe that that is really sophisticated please as for Help on a user mailing list Please: - Attach a sample document (not only screenshot) or refer to an existing sample document in an other Bug with a link; to attach a file to this bug report, just click on "Add an attachment" right on this page. - Attach screenshots with comments if you believe that that might explain the problem better than a text comment. Best way is to insert your screenshots into a DRAW document and to add comments that explain what you want to show - Contribute a document related step by step instruction containing every key press and every mouse click how to reproduce your problem (similar to example in Bug 43431) – if possible contribute an instruction how to create a sample document from the scratch - add information -- concerning your PC -- concerning your OS (Version, Distribution, Language) -- concerning your LibO localization (UI language, Locale setting) –- Libo settings that might be related to your problems -- how you launch LibO and how you opened the sample document –- Whether your problem persists when you renamed your user profile before you launch LibO (please see <https://wiki.documentfoundation.org/UserProfile#User_profile_location>) -- everything else crossing your mind after you read linked texts
Created attachment 66174 [details] Test files for between dates in conditional formatting
Problem description: Steps to reproduce: 1. Conditional Formatting 2. "Cell value is" "Between" "15.02.2012" and "15.12.2012" 3. Save and reopen the file Current behavior: Conditional Formatting is spoiled. LibreOffice 3.6.1.2; WinXP(32), Win7(64) Libo Language Settings: User interface: Default - English (USA) Locale settings: Default - Bulgarian Decimal Separator (.) Bulgarian date format: dd.mm.YYYY
Hm, for first, my comment 1 was wrong, damned copy/past. It was NOT reproducible. [Reproducible] with reporter's sample document and "LibreOffice 3.6.1.2 German UI/Locale [Build-ID: e29a214] on German WIN7 Home Premium (64bit), same already in 3.3.3 More or less also reproducible with Attachment 66121 [details] (Cell E6) for Bug 54008 and LibO 3.3.3 when I change all locale and language settings to BG. Localization related? Should not bee too serious by the moment because this date related conditional formatting does not work at all due to "Bug 54077 - Conditional FORMATTING needs day number instead of formatted date in condition"
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 or maybe ISO dates. This is not a bug and will not be changed.