Worked fine with Server Installation of "LibreOffice 3.6.2.1 rc  German UI/ German Locale [Build-ID:  ba822cc] on German WIN7 Home Premium (64bit), so Regression

(In reply to comment #0)
> 1. Open Attached Sample document and do inputs as shown in table below
> fields.

Sorry, but I don't understand this. What is "do inputs as shown in table below fields"? Do I have to type something?

Created attachment 69477 [details]
screenshot: this is what I see

Using default "Date acceptance patterns" D/M/Y;D/M -> screenshot attached.

Also appending patterns ";D.M.Y;D.M" and File > Reload gave same result

My description was a little too rare.

Steps how to reproduce with parallel installation of Master "LOdev  3.7.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: 1219bc)]"  {tinderbox: @16, pull time 2012-11-01 23:27:25} on German WIN7 Home Premium (64bit) with separate User Profile for Master Branch:

0. Open sample document, do Settings as visible in screenshot in document, 
   close again!
1. Open attached sample document from LibO Start Center File menu
   > Should look similar to Korrawit's screenshot
2. Right from text "Auftragsdatum" (in 2 columns section at top of page in
   left column) double click field with crazy date "11.05.6806" 
   > Dialog appears 'Edit Fields: Variable'
3. Modify 'Value' from "17.9.2012" to "18.9.2012" <ok>
   Expected: New value in Field "18.9.2012"
   Actual:   New value in Field "24.02.7080"

Confirmed on Win7 64bit, by following steps in comment 4, with build from W2008R2@16-minimal_build, pull time 2012-11-09 00:53:19, core: 70ec826eeb8f0b311095869e23be1db95fc9d109

(In reply to comment #1)
> Worked fine with Server Installation of "LibreOffice 3.6.2.1 rc

Rainer, are you sure that it worked in 3.6.2.1? Could you please check again?

I just tested again on Windows XP, en_US User Interface, Thai locale, and got following results:

* 3.5.7 release: both input 16/9/2012 and 16.9.2012 give correct date

* 3.6.0.alpha1 and 3.6.1 release: 16/9/2012 => correct, but 16.9.2012 => wrong
Note: Starting in 3.6, there is a locale-dependent date acceptance patterns.

* 3.6.2.1 rc:
** Before adding custom patterns, as in comment 4 step 0
*** same result as in 3.6.0.alpha1 and 3.6.1: correct when using /, wrong when .
*** Calc detect 16/9/2012 as date, but _not_ 16.9.2012 (as expected)

** After added patterns
*** same result as not adding patterns: correct when using /, wrong when .
*** Calc detect both 16/9/2012 and 16.9.2012 as date (as expected)

Note: Starting in 3.6.2, there is a edit-able pattern in Options menu.

Rainer, please confirm these results.

(In reply to comment #6)
> Note: Starting in 3.6, there is a locale-dependent date acceptance patterns.
> Note: Starting in 3.6.2, there is a edit-able pattern in Options menu.

Ref: https://wiki.documentfoundation.org/ReleaseNotes/3.6#Localization


(In reply to comment #6)
> * 3.6.2.1 rc:

Anyway, test result for 3.6.2.1 rc also same for 4.0.1.1 rc.


(In reply to comment #6)
> Rainer, please confirm these results.

If confirmed, it means the custom date acceptance patterns doesn't apply in this scenario, which is a cause and needs a fix. :)

@Korrawit Pruegsanusak (In reply to comment #7)
I will need a little time for this, my observations currently are inconsistent. I remember that I saw that problem with existing documents very often the days I reported the problem, and the problem was persistent. Currently the problem vanishes after I have typed 18.9.2012 1 time to the field. I will leave a comment until next week after some more tests.

Currently I am not at all able to reproduce my results of report. I see the strange result when open with all (also old) results, but it changes after first different result, and nevermore reappears.

Strange, but I co not want to invest too much time here, I close this one WFM due to Korrawit's and my results for now. 

I will watch this one