Confirmed. The first column has the data which has an extra space in some places due to which OOcalc was seeming to sort incorrectly. I was trying to find the extra space in the 2nd column and it took me some time till i converted the spreadsheet to csv format and looked at the data in a text editor. Can such mistakes not be allowed to occur if oocalc removes forward and trailing whitespace automatically in columns? Would this be a requested feature or is this functionality already implemented in oocalc?
Thank you for helping sort the problem. Kussh On Wed, Nov 25, 2009 at 12:21 AM, WeatherGod <ben.v.r...@gmail.com> wrote: > networker, at first, it looked like I was able to confirm the bug. > However, further double-checking revealed that there is a slight error > in column A. Most of the values are "dr. visit", but some of them are > "dr. visit " with an extra space. When deleting those spaces, the > columns sort correctly. > > It is an easy mistake that occurs often. Therefore, I will be setting > this bug report as "Invalid". Please feel free to report any other bugs > you find with open office. > > ** Changed in: openoffice.org (Ubuntu) > Status: Incomplete => Invalid > > -- > DATA SORTING IS BUGGY in ascending and desending order for any 2 columns > https://bugs.launchpad.net/bugs/486965 > You received this bug notification because you are a direct subscriber > of the bug. > > Status in “openoffice.org” package in Ubuntu: Invalid > > Bug description: > Binary package hint: openoffice.org > > I tried to sort a few rows (by marking the data) in a datasheet of oocalc. > When the rows and columns are marked and command is given to sort by any 2 > columns, oocalc works better but not absolutely correctly when the sorting > order for the 2nd column is to be in descending order. When the sorting > order is to be in ascending/default order for the 2nd column, the result is > more faulty--ie. result looks almost unsorted. > > in sum, sorting works PARTIALLY when sorting is to be done by 2 columns > when the 2nd column to be sorted is in DESCENDING order. Sorting does not > work in case the 2nd column to be sorted by, is in ASCENDING order. > > Haven't tried to sort for more than 2 columns at a time. > > ProblemType: Bug > Architecture: i386 > DistroRelease: Ubuntu 9.04 > Package: openoffice.org-core 1:3.0.1-9ubuntu3.1 > ProcEnviron: > PATH=(custom, no user) > LANG=en_IN > SHELL=/bin/bash > SourcePackage: openoffice.org > Uname: Linux 2.6.28-16-generic i686 > -- DATA SORTING IS BUGGY in ascending and desending order for any 2 columns https://bugs.launchpad.net/bugs/486965 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
