[Libreoffice-bugs] [Bug 127651] LibreOffice calc fails to properly perform a simple sort

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127651

Ted Waugh <tedwaugh at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|6.0.1.1 release             |6.3.0.1 rc

--- Comment #7 from Ted Waugh <tedwaugh at gmail.com> ---
Okay, nailed it.

The reason the sort did not work correctly was due to numbers not being
formatted as expected.

Under 'Tools' AutoInput was turned on by default.

The effect of this was to make my 'year' entries in the column into whatever
was above it, effectively turning some entries into Text and leaving others as
'numbers'

AutoInput by default is like working with a Spellchecker, sometimes it's a good
thing and sometimes it's not.

Apparently when entering both text in some columns and numbers in others it is
dangerous to use the number column as one of the SortKeys when there may be a
possibility of some numbers being sorted as text and others sorted as numbers.

I tried testing the column of "mixed" number/text by just using another column
and adding a '1' to the "mixed" columns. The output was what I would expect if
I was just adding a number to each of the years. 2005 + 1 = 2006, etc.

So, if Sort didn't like the format of the numbers, why would adding a number to
a text number work?

I am still at somewhat of a loss.

Version: 6.3.1.2
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190921/e779fde7/attachment-0001.html>