Pertti, all, 1) This seems to be an old known problem (see e.g. [1])
2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO it's inherited from OOo 3) an easy Workaround exists (go over Data > Sort, choose proper column label Options) So IMO the next questions are, - how important is this bug? - is there general agreement about a default behavior / column label recognition algorithm? Then the bug could be pushed to a higher prio / dev visibility. Nino [1] https://bugs.documentfoundation.org/show_bug.cgi?id=77681 Am 27.03.2015 um 11:38 schrieb Pertti Rönnberg: > Tim Lloyd's comment is not acceptable! > This is not a question of a (unpaid) programmer's likings or priorities -- > this is a serious question of Libre Office's liability, > because both of the the sort buttons in the toolbar (asc & desc) give wrong > results as well as there is no clear explanation why and how the sort command > in Data=> sort must be "customized" if yopu want a correct result. > > A spreadsheet program that cannot be fully trusted is totally worthless!! > > These "bugs" are a result of very bad planning and an obviously total lack > of control & testing of the programming before it was accepted > as a feature in Calc and the complete LibreOffice suite. > > Neither is this really not a "game" -- anyone who goes for to programming > something for LibreOffice must feel the responsibility for the result -- as > well as > the controlling team (if any?). > > The sort feature is a very important feature why these faults have to be > corrected immediately >>> the function of both the sort buttons set to "normal" sort of a > selected range >>> all selections set to blanc in Data=>sort=>options > Pertti Rönnberg > > > > On 26.3.2015 2:12, Tim Lloyd wrote: >> Hi, >> >> while LO does allow a certain amount of customisation, at this point in >> the game this particular menu option can not be changed. >> >> This then becomes a feature request, either >> >> * change the default >> * allow the sort options to be customised >> >> Once a feature request is submitted it is really up to a (unpaid) >> programmer to step forward and take on the action. I can't see this being >> high on the programmer's list of priorities but it may be deemed an "easy >> hack" which an aspiring young person could field. >> >> Cheers >> >> >> >> >> On 26/03/15 10:58, Richard VINCK wrote: >>> Tim Lloyd >>> Thank you for pointing this. Indeed, unticking it works then correctly. >>> But it should be the default, and should remain unticked. (and should be >>> more visible, as it is hidden in the Option tab) >>> Can we make it as default? >>> >>> On 2015-03-26 00:42, Tim Lloyd wrote: >>>> A quick look at the doco reveals... >>>> >>>> Range contains column/row labels >>>> – omits the first row or the first column in the selection from the sort >>>> >>>> Untick this box and you are sorted. >>>> >>>> Cheers >>>> >>>> On 26/03/15 10:06, Wade Smart wrote: >>>>> Hmm I just tried to sort going through the >>>>> sort menu and I still cant get it to sort >>>>> properly. >>>>> >>>>> It does numbers just fine though. >>>>> -- >>>>> Registered Linux User: #480675 >>>>> Registered Linux Machine: #408606 >>>>> Linux since June 2005 >>>>> >>>>> >>>>> On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart <wadesm...@gmail.com> wrote: >>>>>> **cough cough** .. feature understood. >>>>>> -- >>>>>> Registered Linux User: #480675 >>>>>> Registered Linux Machine: #408606 >>>>>> Linux since June 2005 >>>>>> >>>>>> >>>>>> On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan >>>>>> <michael.tier...@gmail.com> wrote: >>>>>>> On 3/25/15 6:53 PM, Wade Smart wrote: >>>>>>>> I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not >>>>>>>> working. >>>>>>> When I reported it, I provided a great deal of information about it and >>>>>>> was told "Not a bug" and "works for me" by those who have the power to >>>>>>> close bugs. >>>>>>> >>>>>>> My argument was/is that if you use the sort arrows (as you have done >>>>>>> here) then you're asking/telling LO to sort the selected rows with no >>>>>>> options. >>>>>>> >>>>>>> Instead it was deemed correct that instead, LO assumes the first cell >>>>>>> found is used as a label regardless of any other settings. >>>>>>> >>>>>>> This "feature" (*cough*) cost me a number of hours of work to get around >>>>>>> and avoid. >>>>>>> >>>>>>> The argument is that since you can use the "Sort" menu option and change >>>>>>> this behavior *for each sort occurrence* then there's a work around for >>>>>>> the "feature" and we should be happy with that. >>>>>>> >>>>>>> -- >>>>>>> << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan >>>>>>> Non Impediti Ratione Cogatationis >>>>>>> Women and cats will do as they please, and men and dogs >>>>>>> should relax and get used to the idea. -Robert A. Heinlein >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>>>>>> Problems? >>>>>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>>>>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >>>>>>> List archive: http://listarchives.libreoffice.org/global/users/ >>>>>>> All messages sent to this list will be publicly archived and cannot >>>>>>> be deleted >>>> >>>> >>> >>> >> >> > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted