Created attachment 44365 [details] Issue_Datapilot-Copy.ods My explanation refers to the attached OD-Spreadsheet Issue_Datapilot-Copy.ods == Explanation == Issue_Datapilot-Copy.ods contains one sheet ("Coyp_me") with some source data and a simple Datapilot. 1. Right-click on the table tab and choose "Move/Copy Sheet" 2. Save document 3. Choose File -> Refresh 4. See static table on copy of "Coyp_me" sheet. == Problem == The Datapilot on the copy of the sheet is rendered useless (static), instead of working copy. == See Also == This Issue in the OOo Bug-tracker from 2004: Copies of Datapilot are non-functional http://openoffice.org/bugzilla/show_bug.cgi?id=27611
[Reproducible] with "LibreOffice 3.3.1 – WIN7 Home Premium (64bit) English UI [OOO330m19 (build 8 / tag 3.3.1.2)]". Very worrying that the sort buttons only are static drawings in the pasted sheet, that's why I see this as a bug and not as an enhancement request. Only low priority problem, this OOo limitation exists at least since 2004 with only 10 votes, what is not very much within 7 years. Copy / paste Shett contents to an existing empty sheet does not pretend to create a new Data Pilot, no sort buttons will be pasted. I have problems to imagine a "real life application" where you need a 'copy / paste sheet' with working data pilot, but I see the same effect when I use menu 'Insert > Sheet from File' or sheet tab context menu 'Insert Sheet > Sheet - from file' @famo: Currently this only is confirmed for WIN (also from OOo IZ). What OS / Platform did you test? @Kohei: Your area? Your estimate?
(In reply to comment #1) > [Reproducible] with "LibreOffice 3.3.1 – WIN7 Home Premium (64bit) English > UI [OOO330m19 (build 8 / tag 3.3.1.2)]". > > Very worrying that the sort buttons only are static drawings in the pasted > sheet, that's why I see this as a bug and not as an enhancement request. > On "3. Choose File -> Refresh" they are gone. Whether bug or enhancement, I cannot see this setting here, are you referring to the OOo issue? > I have problems to imagine a "real life application" where you need a 'copy / > paste sheet' with working data pilot, but I see the same effect when I use menu > 'Insert > Sheet from File' or sheet tab context menu 'Insert Sheet > Sheet - > from file' > Recently I had two cases: • I wanted to have two layouts at hand for the same source (Ok, one can argue here if it is really faster than creating a new datapilot from scratch) • I wanted to have the very same datapilot (a very extensive one) for a different source (since newer versions of OOo you can change the source range of datapilots) However, certainly these are not everyday applications, so Prio low is OK, IMHO. > @famo: > Currently this only is confirmed for WIN (also from OOo IZ). What OS / > Platform did you test? > Windows XP
@famo > Whether bug or enhancement, I cannot see this setting here, are you > referring to the OOo issue? Yes, the OOo Bug is classified as enhancement request.
This bugs persist with "LibreOffice 3.4.3 – WIN XP Professional (Portuguese) LibreOffice 3.4.3 - OOO340m1 (Build:302) This resource is important and exists a long time (at least since 2004)...
Oh I didn't know we still had this open... This is now fixed in 3.5.0.
@kohei: Thanks for the fix! On a related note to pivot tables: you wrote the patch to the data sources in pivot tables (https://issues.apache.org/ooo/show_bug.cgi?id=23658), any chance to get this also for pivot tables which used DB tables / queries as sources? Shall/can I fill an issue for this? :-)
(In reply to comment #6) > @kohei: > Thanks for the fix! > > On a related note to pivot tables: you wrote the patch to the data sources in > pivot tables (https://issues.apache.org/ooo/show_bug.cgi?id=23658), any chance > to get this also for pivot tables which used DB tables / queries as sources? > > Shall/can I fill an issue for this? :-) That's an entirely different feature. So, I'd say filing a new bug is appropriate.
(In reply to comment #7) > That's an entirely different feature. So, I'd say filing a new bug is > appropriate. Ok, I filled bug 46381