Issue 125052

Summary: Wildcards behaving unexpectedly in pivot table
Product: Calc Reporter: markholbrook64
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: rainerbielefeld_ooo_qa
Version: 4.1.0Keywords: needmoreinfo
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
screenshot of wildcard search none

Description markholbrook64 2014-06-05 14:03:03 UTC
Created attachment 83502 [details]
screenshot of wildcard search

I am using a wildcard to include all descriptions that start with shell(shell*) for data analysis in a pivot table.  This causes either a crash, or unexpected results, according to which field the wildcard is in.
Comment 1 markholbrook64 2014-06-05 14:09:14 UTC
Note amount field is incorrect, field is correct without wildcard.
Comment 2 Rainer Bielefeld 2014-06-05 14:18:45 UTC
Only 1 issue per report!

AOO does not support "Wildcards", but regular expressions (what, of course, may not cause a crash - for crash please submit a separate Issue!)

@reporter:
Thank you for your feedback – unfortunately important information we will 
need to reproduce your problem is missing.
Please add all information requested in following:
a) Write a meaningful Summary describing exactly what the problem is
b) Attach a sample document (not only screenshot) or refer to an existing 
   sample document in an other Bug with a link; to attach a file to this 
   bug report, just click on "Add an attachment" right on this page.
   If you want to attach a test kit with multiple documents zip them into
   a single testkit.zip and attach the  testkit.zip
c) Contribute a document related step by step instruction containing every 
   key press and every mouse click how to reproduce your problem 
f) add information 
   f1) what EXACTLY is unexpected. 
   f2) and WHY do you believe it's unexpected (cite Help or Documentation!)
   f3) concerning your PC (video card, ...)
   f4) concerning your Operating System (Version, Distribution, Language)
   f5) concerning your AOO version (with Build/revision ID if it's not a 
      public release) and localization (UI language, Locale setting)
   f6) AOO settings that might be related to your problems 
   f9) Whether that worked in former OOO / AOO Versions 
   f10) whether (and how) a competitor's software (MSO, LibreOffice, ...)
        fulfills your needs

Please do not cite these hints in your reply, but cite the items like:
f7): Desktop-icon for soffice.exe / AOO File menu -> Open
Comment 3 Rainer Bielefeld 2014-06-05 14:36:48 UTC
Some quick tests with regular expressions in own pivot table documents and  with "AOO 4.2.0-Dev – German UI / German locale [AOO420m1(Build:9800)  -  Rev. 1599676  2014-06-04]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions did not show anything unexpected.