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 <wadesmart@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.tiernan@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+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
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.