Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

Hi :)
That is exactly the most perfect use-case that would be better in a
database than in a spreadsheet.

What makes it even more perfect is that Base can use the existing
spreadsheet as an external back-end.  This means that while you struggle to
get Base set-up you can keep using the existing spreadsheet in the way you
are familiar with.  Also at any random moment in the future, even after
Base is set-up, you can just use the spreadsheet method that you are using
all the time at the moment.

Regards from
Tom :)





On 28 March 2015 at 09:50, Michael Tiernan <michael.tiernan@gmail.com>
wrote:

> On 3/27/15 8:01 AM, Nino Novak wrote:
> > 1) This seems to be an old known problem (see e.g. [1])
> It's older than that by a bit, I reported it back in 2012 I think. (I'd
> have to hunt it down.) However, "known" isn't as accurate as we'd like
> if people seem to find this as "new" on a semi-regular basis.
> > 2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO
> it's
> > inherited from OOo
> Also, from my perspective, I'm not accusing/blaming those working on
> this for it having happened, it did, time to move on, now I'd like to
> get it fixed.
> > 3) an easy Workaround exists (go over Data > Sort, choose proper column
> > label Options)
> A point I'd tried to make back "then" but got no where with was that
> it's not an "easy" work-around when you have to do it multiple times
> over and over in the process of using a collection of data means you
> waste a *lot* of time during this "work around" which, when you have to
> do it multiple times, stops being easy and becomes long and tedious.
>
> I have a spreadsheet of ~450 entries, one for each machine in a data
> center. Sometimes I have to sort it on the names, sometimes the serial
> number, sometimes the rack location, etc. In my cases, when I was
> building this list, to, EACH TIME, bring up the menu option, go and
> click off *AGAIN* the button to choose the second page of the dialog,
> click the "label" button, then click "Ok" *AGAIN* wasted a lot of time
> and introduced new places for me to trigger an error in the process when
> really, "assuming" the minimum choices was the correct approach.
>
> Maybe that's what we need, a button to set the sort options, just once
> to "smart" or "standard" meaning don't *ass*u*me* anything when trying
> to decide what to do with the data.
> > 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.
> The "philosophical" arguments I'd like to make is that using the
> assumption of "lowest common expectation" (for lack of a better term) is
> that you assume the least number of optional choices that you can unless
> explicitly told otherwise.
>
> As someone previously stated, if I select/highlight a number of words in
> a word processor to effect change on them such as bold/italic/underline,
> I expect the operation to be done in the simplest of terms, I don't want
> you to avoid doing capital letters because that's an option somewhere I
> didn't expect.
>
> --
>   << 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+unsubscribe@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+unsubscribe@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