Issue 125052 - Wildcards behaving unexpectedly in pivot table
Summary: Wildcards behaving unexpectedly in pivot table
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2014-06-05 14:03 UTC by markholbrook64
Modified: 2014-06-05 14:36 UTC (History)
1 user (show)

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

screenshot of wildcard search (162.54 KB, image/jpeg)
2014-06-05 14:03 UTC, markholbrook64
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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!)

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 and attach the
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.