Issue 8180 - database query ranges remaining after delete/move sheet
Summary: database query ranges remaining after delete/move sheet
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows NT
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
: 25494 47016 (view as issue list)
Depends on:
Reported: 2002-10-09 15:12 UTC by Unknown
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-10-09 15:12:28 UTC
The problem involved database ranges not being removed on sheet delete and
interfereing with other database ranges on other sheets.

1 have a jdbc data source
2 create a new spreadsheet (by default will have 3 sheets)
3 drag-n-drop  table/query 1 into cell A1 sheet1
4 drag-n-drop table/query 2 into A1 sheet2
5 drag-n-drop table/query 3 into A1 sheet3
6 delete sheet1 and sheet2
7 data->refresh range on sheet3
8 table/query 3 is replaced in sheet3 with on of the other tables (1 or 2)

On inspection of the ranges all three (import1,import2,import3) database ranges
belong to sheet3. My expected result was the sheet3 would retain query3 and the
other ranges (import1,import2) would be removed (or at least not interfer with
existing database range on sheet3.
Comment 1 oc 2003-08-07 14:39:09 UTC
Hi Niklas, please have a look
Comment 2 niklas.nebel 2003-09-11 13:12:26 UTC
Comment 3 niklas.nebel 2003-09-11 15:30:45 UTC
This should have target "later".
Comment 4 oc 2003-09-22 10:35:33 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 5 frank 2003-10-28 08:12:24 UTC
nothing for ms_interop., so no blocking of 21783
Comment 6 niklas.nebel 2005-04-08 18:01:07 UTC
*** Issue 25494 has been marked as a duplicate of this issue. ***
Comment 7 niklas.nebel 2005-04-08 18:04:25 UTC
*** Issue 47016 has been marked as a duplicate of this issue. ***
Comment 8 iannz 2005-04-08 22:49:37 UTC
As issue 15494 has been marked as a duplicate of this one, I want to make sure
that it is recorded here that the issue also applies to data pilots.
Comment 9 hans_werner67 2005-04-11 07:37:46 UTC
FMA->FST: Please re-target this issue to OOo 2.0.1, it is important enough to
have it in OOo 2.0.x. If not possible please escalate it!
Thx. FMA
Comment 10 hans_werner67 2005-04-12 11:11:52 UTC
added fma and jj on CC-list
Comment 11 niklas.nebel 2005-04-12 11:43:21 UTC
Changing target to 2.0.1 (carried over from issue 47016).
Comment 12 niklas.nebel 2005-04-22 15:41:12 UTC
Fixed on CWS "dr37".
Comment 13 niklas.nebel 2005-08-22 12:55:54 UTC
back qo QA for verification

re-open issue and reassign to
Comment 14 niklas.nebel 2005-08-22 12:55:58 UTC
reassign to
Comment 15 niklas.nebel 2005-08-22 12:56:08 UTC
reset resolution to FIXED
Comment 16 oc 2005-09-12 15:02:52 UTC
verified in internal build cws_dr37
Comment 17 oc 2005-10-31 15:08:07 UTC
closed because fix available in OOo2.0m136