To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94205
Issue #|94205
Summary|MATCH function doesn't work on DDE link on a date with
| special format using minus character
Component|Spreadsheet
Version|OOo 3.0 RC2
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|texaldo
------- Additional comments from [EMAIL PROTECTED] Tue Sep 23 07:47:39 +0000
2008 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
