Issue 3773 - Wild cards in spreadsheet "database" criteria breaks DSUM function,
Summary: Wild cards in spreadsheet "database" criteria breaks DSUM function,
Status: CLOSED DUPLICATE of issue 3393
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: PC Linux, all
: P1 (highest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: peter.junge
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-04-01 14:41 UTC by vcjones
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Sample spreadsheet (.sxc) exhibiting DSUM errors (5.66 KB, application/octet-stream)
2002-04-01 15:13 UTC, vcjones 		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 vcjones 2002-04-01 14:41:26 UTC 
Using a database defined by a range of cells, wildcard matches in functions such
as DSUM cause the function to return zero regardless of setting of "allow
wildcards" and "partial matches" in the options pages.

Example:

Database range         Criteria "Fix"    Criteria "Fix2"    Criteria "wild"   
Criteria "wild2"
numba   nameo	     nameo                nameo            nameo              
nameo
   1        dad                   dad                   mom             
da.*                   mom  
   2        mom                                         
dad                                         da.*
   4        daddy

 DSUM (database; numba; Fix) returns 1 
 DSUM (database; numba; Fix2) returns 3
 DSUM (database; numba; wild) returns 0
 DSUM (database; numba; wild2) returns 0

This function works correctly in StarOffice5.2, so this breaks existing
StarOffice spreadsheets which use local database funtions.
Comment 1 vcjones 2002-04-01 15:13:45 UTC 
Created attachment 1293 [details]
Sample spreadsheet (.sxc) exhibiting DSUM errors
Comment 2 peter.junge 2002-04-03 16:16:26 UTC 
I'll have a look, Peter
Comment 3 ooo 2002-04-03 20:24:53 UTC 
The current i18n framework simply doesn't support regular expressions
yet.
Comment 4 peter.junge 2002-04-05 11:28:05 UTC 
Double.

*** This issue has been marked as a duplicate of 3393 ***
Comment 5 peter.junge 2002-04-05 12:11:11 UTC 
This one has to be closed instead of #3393.