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 <nn.l...@kflog.org> 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 <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 > -- 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