Summary: | PIVOTTABLE: Copy of Datapilot is non-functional static table | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | famo <richard.llom> |
Component: | Spreadsheet | Assignee: | Kohei Yoshida (inactive) <libreoffice> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | minor | ||
Priority: | high | CC: | LibreOffice |
Version: | 3.3.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | target:3.5.0 | ||
i915 platform: | i915 features: | ||
Attachments: | Issue_Datapilot-Copy.ods |
Description
famo
2011-03-11 12:46:30 UTC
[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 |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.