Issue 89078 - GETPIVOTDATA doesn't allow to reference a data pilot in another document
Summary: GETPIVOTDATA doesn't allow to reference a data pilot in another document
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2008-05-06 18:30 UTC by camillem
Modified: 2013-02-07 22:42 UTC (History)
4 users (show)

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

Attachments
SpreadSheet referencing the data pilot in another file (10.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-05 09:49 UTC, camillem 		no flags Details
File containing the Data Pilot, to be saved in C:\Local\OOo\ (10.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-05 09:51 UTC, camillem 		no flags Details
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 camillem 2008-05-06 18:30:45 UTC 
GETPIVOTDATA gives a #REF error if the referenced data pilot is in an another
spreadsheet

For instance something like  
=GETPIVOTDATA("Prix";'file:///the_path_to_the_other_spreadsheet/the_file_where_the_data_pilot_is.ods'#$Sheet.A25;"Auteur";"Picasso")
wouldn't work.
As this features exists in Excel, it causes migrations issues.
Comment 1 camillem 2008-06-05 09:49:07 UTC 
Created attachment 54247 [details]
SpreadSheet referencing the data pilot in another file
Comment 2 camillem 2008-06-05 09:51:49 UTC 
Created attachment 54248 [details]
File containing the Data Pilot, to be saved in C:\Local\OOo\
Comment 3 oc 2008-07-15 10:44:25 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 4 camillem 2009-12-23 14:08:36 UTC 
Would it be possible to have this issue confirmed ? Thanks.
Comment 5 davide 2011-03-29 13:25:02 UTC 
Can someone confirm such issue????
It's very similar to a problem of mine....
Comment 6 niklas.nebel 2011-03-29 14:39:23 UTC 
confirming