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...
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
DateMatch problem sample (18.79 KB, text/plain)
2008-09-23 08:48 UTC, texaldo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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