Issue 8180 - database query ranges remaining after delete/move sheet
Summary: database query ranges remaining after delete/move sheet
Status: CLOSED FIXED
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
URL:
Keywords:
: 25494 47016 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
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 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.

Steps:
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 
accepting.
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 OpenOffice.org roadmap
(http://tools.openoffice.org/releases) 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 oc@openoffice.org
Comment 14 niklas.nebel 2005-08-22 12:55:58 UTC 
reassign to oc@openoffice.org
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