Issue 29734 - Provide ability to Refresh all Ranges from Data source
Summary: Provide ability to Refresh all Ranges from Data source
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-06-01 08:00 UTC by kelvine
Modified: 2013-02-07 22:34 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description kelvine 2004-06-01 08:00:59 UTC

It would be nice to refresh all ranges of data which have been included in a 
spreadsheet from the data source.

The option to refresh a range only applies to the current range.

If the spreadsheet consists of multiple ranges, each range appears to have to 
be manually refreshed which can be a bit tedious.

For example:

Open Calc
Open the Data Source window (F4)
Select the Biblio table
Drag and drop the table into the spreadsheet
Now repeat this and drag and drop a second copy so the spreadsheet has two 
copies. (Try to think of these as being two separate queries from the one data 
source. I am only using the one table because it makes it easy to demonstrate 
what I mean.)
Now change the Type from 1 to 2 in the first row of the table
Click in the first Range
Select Data -> Refresh Range

Notice that as expected only one of the ranges is refreshed.

Each range has to be done manually.

If there multiple ranges (eg States in a Country, months in a year etc) then 
this can become tedious.

May I suggest extending the current approach.

The Refresh Range to have a sub menu.
The first item works as currently. That is disabled if the cursor is not 
within a range and enabled if it is.
The second item would be a Refresh All.

IMHO this would considerably increase the functionality in this area whilst 
still maintaining compatibility with Excel.


Comment 1 christoph.lukasiak 2004-06-07 15:11:16 UTC
rather mine
Comment 2 christoph.lukasiak 2004-06-07 16:37:46 UTC
correct os
Comment 3 christoph.lukasiak 2004-06-07 16:43:13 UTC
set new
Comment 4 frank 2004-06-08 08:47:41 UTC
Changed component and QA Contact
Comment 5 christoph.lukasiak 2004-06-08 09:12:23 UTC
change owner to bh
Comment 6 bettina.haberer 2010-05-21 14:50:43 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".