Issue 94205

Summary: MATCH function doesn't work on DDE link on a date with special format using minus character
Product: Calc Reporter: texaldo <aldo.texier>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.0 RC2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---
Description Flags
DateMatch problem sample none

Description texaldo 2008-09-23 08:47:39 UTC
The spreadsheet  match1.ods contains a date with a special format MMM-AA
The spreadsheet match.ods contains a formuala with a MATCH function on a DDE
link with  on the fisrt date.

DateFormat Value        Result  Formula                           File Range
MMM-AA	   sept.-08	#N/A	=MATCH(B7;DDE("soffice";E7;F7);0)
U:\OpenOffice\match1.ods	Sheet1.A2:Z2

The match function returns N/A.

the MATCH function is not working probably due to the minus character in the
date format.
Comment 1 texaldo 2008-09-23 08:48:54 UTC
Created attachment 56750 [details]
DateMatch problem sample
Comment 2 amy2008 2008-10-30 08:01:19 UTC
There are four #N/A, but not the only one you painted in the file match.ods
In the column E, I changed the address to my local machine one. The result is 
the same as the one when we open the original match.ods file.
I will attach two images to show testings on WinXP.
Li Meiying 
Comment 3 Edwin Sharp 2013-05-10 11:49:07 UTC
Both Sep-08 and Sep 08 fail to be recognized by match function.
Only 09/01/08 works.

Rev. 1479897 Win 7