Issue 94281 - DataPilot: Cannot start, when data are filtered
Summary: DataPilot: Cannot start, when data are filtered
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-09-24 14:46 UTC by Stefan Weigel
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

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

Attachments
proposed fix (653 bytes, patch)
2008-09-30 00:35 UTC, kyoshida 		no flags Details | Diff
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 Stefan Weigel 2008-09-24 14:46:39 UTC 
Preliminary note:
DataPilot does not care whether its base data are filtered (AutoFilter,
StandardFilter) or not, but refers to all data selected prior to its call. This
is a normal property of DataPilot.

Normal operation:
(1) Select a list of data in a spreadsheet
(2) Choose Data|Filter|AutoFilter. Do not select any filter criteria.
(3) Choose Data|DataPilot|Start...
(4) Click OK
(5) See DataPilot´s dialog.
(6) After creating some DataPilot (on an other sheet) you may come back to the
original data and set some filter criteria to the AutoFilter you activated
before. This has no impact on the DataPilot, even when you refresh it. That´s ok.

Bug report:
(1) Select a list of data in a spreadsheet
(2) Choose Data|Filter|AutoFilter
(3) Select some filter criteria
(3) Choose Data|DataPilot|Start...
(4) Click OK
Bang. Nothing happens.
Comment 1 kyoshida 2008-09-27 17:54:21 UTC 
confirmed.  this appears to be a regression since 2.4.1 works just fine with
filtered sources.
Comment 2 kyoshida 2008-09-30 00:35:00 UTC 
Ah, simple fix.  This was caused by the change to support filtered marked area.
 Fixing this only takes two lines of code change.
Comment 3 kyoshida 2008-09-30 00:35:57 UTC 
Created attachment 56909 [details]
proposed fix
Comment 4 kyoshida 2008-09-30 22:15:24 UTC 
I'm taking ownership.
Comment 5 kyoshida 2008-09-30 22:15:40 UTC 
started.
Comment 6 kyoshida 2008-09-30 22:17:09 UTC 
fixed in koheidatapilot02 cws.
Comment 7 kyoshida 2008-09-30 22:17:52 UTC 
setting target to 3.1 since it's a little too late for 3.0.
Comment 8 kyoshida 2008-11-17 16:08:03 UTC 
re-assigning to oc for qa.
Comment 9 oc 2008-11-21 08:32:38 UTC 
Fix does not work, "start" is still greyed out for filtered dataranges
Comment 10 oc 2008-11-21 08:33:42 UTC 
reassigned for fixing
Comment 11 kyoshida 2008-11-21 15:49:13 UTC 
oc: I double-checked the fix to make sure it's committed & it is committed. 
Because the test document you sent me works fine on my copy, I'm suspecting the
issue is the buildbot build.  I have started another buildbot build and
hopefully that will resolve the issue.
Comment 12 kyoshida 2008-11-21 15:49:44 UTC 
back to oc for re-verification.
Comment 13 oc 2008-11-26 11:05:03 UTC 
verified in internal build cws_koheidatapilot02
Comment 14 Stefan Weigel 2008-12-05 12:54:08 UTC 
verified in OOODEV300m37.
Comment 15 Stefan Weigel 2008-12-28 19:18:18 UTC 
verified, fixed --> closed.