Issue 94913 - Impossible to consolidate data with other spreadsheets
Summary: Impossible to consolidate data with other spreadsheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.2 RC2
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-13 08:50 UTC by norbert2
Modified: 2013-01-29 21:45 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
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 norbert2 2008-10-13 08:50:37 UTC 
Hi.

Please...

- open two (blank) spreadsheets

- Click Data/Consolidate...

- Click the small button next to the input field in the "Source data range" area
OR in the "Copy results to" area

- Now try to select a cell range from the other spreadsheet

It does not work.

I think consolidating data with data from other spreadsheets is what the user
most want to do with this feature.

MS Excel 2003 SP2 allows to reference cells from other spreadsheets.
Comment 1 Uwe Altmann 2010-01-18 09:33:56 UTC 
Using a cell or range in another sheet/file than the document in which the consolidation shall take place 
itself is not possible.
Consolidation over multiple documents / consolidation ranges of type ‘file:///…' would be an 
enhancement.