opinion FWIW: I tend to use sort on an entire sheet (using data>sort), and I nearly always have a column headings row at the top; I get narked when, coming to repeat a sort on a sheet, I find that LO has "forgotten" that I have previously checked the "has headings" box and ends up sorting the headings into the data - so I definitely prefer the "has headings" to be default. (It mightn't be *quite* so bad if one didn't have to go to an options tab in order to see what the current setting is - it's just too easy for feeble-minded people like me to forget to do that!). So it would definitely be good to be able to rely upon the setting being unchanged since the last sort. It would also be good to have the possibility to set the required behaviour on a per-sheet basis. OTOH, sorting a selected range, as has been the case in this thread, is a different kettle of fish - in that case, the default should definitely be to assume no column headings and to sort everything that's given. A thought for future development: maybe best of all would be good to be able to mark a row (or column) as being a headings row (or column) and hence be excluded from any sort automatically. This would have the advantage that more than one row (or column) could be used for this purpose. It would also have the advantage of making that "contains headings" checkbox redundant, whilst avoiding problems of the kind that have been experienced here. Just some thoughts... /Gary From: Tom Davies <[email protected]> To: Nino Novak <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Friday, 27 March 2015, 12:18 Subject: Re: [libreoffice-users] Re: LibreOffice Sort Bug ? Hi :) Personally i think that it is quite annoying.
If i select something to sort i tend to leave out any stuff i don't want sorted. Similarly if i want to make some things bold. I select the things i want to make bold and leave out the rest! Regards from Tom :) On 27 March 2015 at 12:01, Nino Novak <[email protected]> wrote: > 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 <[email protected]> > 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 > >>>>>> <[email protected]> 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: [email protected] > >>>>>>> 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: [email protected] > 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: [email protected] 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: [email protected] 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
