Issue 94205 - MATCH function doesn't work on DDE link on a date with special format using minus character
Summary: MATCH function doesn't work on DDE link on a date with special format using m...
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.0 RC2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-09-23 08:47 UTC by texaldo
Modified: 2013-05-10 11:49 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

DateMatch problem sample (18.79 KB, text/plain)
2008-09-23 08:48 UTC, texaldo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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