Issue 63748 - Named Character Classes with Advanced Filter
Summary: Named Character Classes with Advanced Filter
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All Unix, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-03-29 07:15 UTC by villeroy
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Sheet with predefined db-range and filter-criteria (11.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-03-29 07:17 UTC, villeroy 		no flags Details
updated testcase (11.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-09-13 12:37 UTC, kpalagin 		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 villeroy 2006-03-29 07:15:32 UTC 
Named character classes like [:digit:] are changed to ucase [:DIGIT:] which
makes the filter unusable (never matches). In the UI you can see the modified
filter in the standard filter dialog. Changing the filter to lowercase class
names makes it work.
Comment 1 villeroy 2006-03-29 07:17:55 UTC 
Created attachment 35336 [details]
Sheet with predefined db-range and filter-criteria
Comment 2 villeroy 2006-04-13 18:02:40 UTC 
Posted an evaluation spreadsheet for all my related regex-issues at issue 64368
Comment 3 villeroy 2006-04-13 18:02:52 UTC 
Posted an evaluation spreadsheet for all my related regex-issues at issue 64368
Comment 4 villeroy 2006-04-16 23:21:20 UTC 
In fact "Advanced Filter" changes all kinds of criteria (regex or not) to upper
case. This makes it unusable with option "Case Sensitive" and with all
case-sensitive regex-patterns like "A[a-h].+"
Method createFilterDescriptorByObject of interface
com.sun.star.sheet.XSheetFilterableEx gives the uCased string-values in the
sequence of TableFilterFields of the returned filter-descriptor.
Comment 5 kpalagin 2006-09-13 12:22:02 UTC 
Confirming that Advanced Filter changes criteria from lower case to upper case 
(m180 on Win XP). 
Repro steps:
1. Open the file that I attach and click cell B1.
2. Click Data\Filter\Standard. Make sure that value is displayed with lower 
case "digit". Click Cancel.
3. Click Data\Filter\Advanced. In "read Filter criteria from" choose "crit" 
and click OK.
2. Click Data\Filter\Standard. Note that value is displayed with upper 
case "DIGIT". 
IMO, this behaviour is incorrect.
Comment 6 kpalagin 2006-09-13 12:37:42 UTC 
Created attachment 39116 [details]
updated testcase
Comment 7 frank 2006-09-13 13:29:44 UTC 
Hi Eike,

maybe a double or related to Issue 64368 ?

Frank
Comment 8 ooo 2006-09-14 14:48:18 UTC 
May be related to issue 64368. However, that one is primarily about correct
handling of named character classes, which needs separated inspection. Here,
_any_ text is converted to uppercase in this sequence of UI steps, e.g. "foo" in
C2 => "FOO". Reason being the internal methods CreateQueryParam and subsequent
obtain cell content via GetUpperCellString, which is plain wrong. However, if
changing that, places using the ScQueryParam must be inspected for correct usage
and handling of transliteration respectively regexp context.
Comment 9 ooo 2008-05-30 16:03:34 UTC 
Propably not doable in time frame for 3.0, retargeting to 3.x
Comment 10 Marcus 2017-05-20 11:11:11 UTC 
Reset assigne to the default "issues@openoffice.apache.org".