Issue 89715

Summary: Database range with option "Insert and delete cells"
Product: Calc Reporter: villeroy <villeroy>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 2.4.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
2 database ranges and a chart none

Description villeroy 2008-05-21 12:04:46 UTC 
I'll attach a demo spreadsheet where I tried to get a dynamically resizing chart
by using two database ranges "Source" and "Target" where the latter is the
target range of the other's filter descriptor (Option "Copy Output").
It works perfectly while the target range grows. The more values are matched by
the filter, the more values are drawn into the chart. Database range "Target"
adjusts to the new size and so does the chart. This desired feature seems to
rely on option "Insert and delete cells" applied to the target range.
However, when we apply a filter that matches fewer rows than the previous one
the size does not adjust.
If this feature would work in both directions, it could provide a good
work-around for some of the more tricky issues.
Comment 1 villeroy 2008-05-21 12:06:30 UTC 
Created attachment 53816 [details]
2 database ranges and a chart
Comment 2 jm38706415 2008-07-08 08:46:23 UTC 
Validating on Dev_DEV300_m21_winXP Chinese.
Comment 3 Edwin Sharp 2014-01-12 07:06:13 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian