[Bug 381948] Re: Can't Manual Sort in Data Pilot
** Changed in: openoffice.org (Ubuntu) Status: Incomplete = Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/381948 Title: Can't Manual Sort in Data Pilot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/381948/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
[This is an automatic notification.] Thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal: apport-collect -p openoffice.org-core 381948 This will help us to find and resolve the problem. Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to Change Non-Private data as it will be adding information to your bug report. Thanks in advance! When reporting bugs in the future please use apport, either via the appropriate application's Help - Report a Problem menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs. ubuntu-bug openoffice.org-core Please do not set bugs back to 'New' after adding this information. ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
apport information ** Tags added: apport-collected ** Description changed: I used to be able to manual sort a data pilot no problem by just going into the options and setting to manual and then I could drag rows up and down into the correct orderthis method no longer works. I am running OpenOffice 3.1.0 in Ubuntu 8.10. - Thanks all, let me know if there is more detail that I can add. To - replicate you can just make a column with random months, then another - column with numbers (random is fine), then try to make a data pilot - using months as the rows and the numbers in the actual data pilot - center. Try to set the months to sort manually and see if you can move - anything around, I've tried a lot and it no longer works. + Thanks all, let me know if there is more detail that I can add. To replicate you can just make a column with random months, then another column with numbers (random is fine), then try to make a data pilot using months as the rows and the numbers in the actual data pilot center. Try to set the months to sort manually and see if you can move anything around, I've tried a lot and it no longer works. + --- + Architecture: amd64 + DistroRelease: Ubuntu 10.04 + InstallationMedia: Ubuntu 10.04 LTS Lucid Lynx - Release amd64 (20100429) + NonfreeKernelModules: wl + Package: openoffice.org-core 1:3.2.0-7ubuntu4.1 + PackageArchitecture: amd64 + ProcEnviron: + LANG=en_US.utf8 + SHELL=/bin/bash + ProcVersionSignature: Ubuntu 2.6.32-23.37-generic 2.6.32.15+drm33.5 + Tags: lucid + Uname: Linux 2.6.32-23-generic x86_64 + UserGroups: adm admin cdrom dialout lpadmin plugdev sambashare ** Attachment added: Dependencies.txt http://launchpadlibrarian.net/52295900/Dependencies.txt -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Still no good, when I try to move it the mouse pointer turns into a circle with a line through it, I included an image to show what it does ** Attachment added: DataSort.jpg http://launchpadlibrarian.net/51186657/DataSort.jpg ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = New -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Sorry I think I had it backwards... try this on Ubuntu's OOo 1. Highlight just the cells that say month names, 6 or so. 2. Click and hold in the 3rd month of the selection. The icon should change 3. Shift them up/down -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Yeah I can move regular cells no problem. Are you able to move data pilot cells using the cntrl + left button method? If so then I guess it's my machine but if not, I suspect it's OOo. Thanks for sticking with me on this one -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 381948] Re: Can't Manual Sort in Data Pilot
Can you move cells when you are not in a pivot table? It's much easier to try on a big selection of cells, click and hold somewhere the middle and then drag. -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
That didn't work, tried holding cntrl, shift and cntrl+shift, just selected cells -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Looks like it might just be we need to update that help page. These instructions helped me get this work http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Results_2 The key may be to press Ctrl to make it move the cell, 3.2.1rc from Oracle seems to let you move it with just a mouse click and hold, but 3.2 in Ubuntu seems to require the Ctrl or Shift key. Jmadero - please test if the above works for you. -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Agreed on it being dumb, do you happen to know with which version it still worked for you the way you wanted it to? -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
If you go to help on the dialog on image 3. You get this for Manual: Sorts values alphabetically. Yes.. that seems quite annoying as a definition for manual. This bug report *may* have a solution for you, please write back if it does: http://qa.openoffice.org/issues/show_bug.cgi?id=72304 ** Bug watch added: OpenOffice.org Issue Tracker #72304 http://qa.openoffice.org/issues/show_bug.cgi?id=72304 ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
This definitely wasn't how it was before...not sure if the developers changed their minds or something but before I could manually drag rows around (or columns) to resort them after the datapilot was madethat was functional and is a feature in other office suites (I believe Star office and MS Office have a manual sort). I'm not understanding why it's called manual if it's still automatic...how is that any different from Ascending or Descending options that are already available -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
I can't remember which one but I believe it was in intrepid that I could. The fact that it says manual still in sort options makes me think that it is supposed to be able to. I just tried again with Lucid and no go, can't move things at all. ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = New -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
I don't see where you see the manual sort option, which sheet/cell are you looking at? Perhaps a screenshot would help me find what you are looking at? ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Attached a file and three images to show how to get to the manual sort option. Thanks for the help ** Attachment added: datapilotexample.ods http://launchpadlibrarian.net/49182841/datapilotexample.ods -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
** Attachment added: 1.jpg http://launchpadlibrarian.net/49182843/1.jpg -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
** Attachment added: 2.jpg http://launchpadlibrarian.net/49182851/2.jpg -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
** Attachment added: 3rd.jpg http://launchpadlibrarian.net/49182852/3rd.jpg ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = New -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
I don't see a datapilot on the the third tab, but I do on the 2nd and 4th. It does look like you can't do a manual sort at least from what little I know of how datapilot works (most likely less than you). Which version of OOo supported manual sorting in a datapilot? ** Changed in: openoffice.org (Ubuntu) Status: Confirmed = Incomplete -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
** Changed in: openoffice.org (Ubuntu) Status: Incomplete = Confirmed -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
It's the 3rd sheet on this file, the data pilot is set but I can't adjust rows at all, I used to be able to by just dragging rows but that's not longer the case. Thank you much ** Attachment added: New Million Pages.ods http://launchpadlibrarian.net/32337232/New%20Million%20Pages.ods -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 381948] Re: Can't Manual Sort in Data Pilot
Can you please attach an example document showing this issue? ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- Can't Manual Sort in Data Pilot https://bugs.launchpad.net/bugs/381948 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
