|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| 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: | programming | Assignee: | 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: | --- | ||||||
| Attachments: |
|
||||||
Created attachment 56750 [details]
DateMatch problem sample
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 Both Sep-08 and Sep 08 fail to be recognized by match function. Only 09/01/08 works. Rev. 1479897 Win 7 |
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.