Issue 89715 - Database range with option "Insert and delete cells"
Summary: Database range with option "Insert and delete cells"
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-21 12:04 UTC by villeroy
Modified: 2014-01-12 07:06 UTC (History)
2 users (show)

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

2 database ranges and a chart (21.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-05-21 12:06 UTC, villeroy
no flags Details

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