Strange sorting

[Robert Heller]

At Wed, 6 Oct 2010 15:50:14 -0400 "Derek Atkins" <derek at ihtfp.com> wrote:

> 
> It's a known bug in 2.2.x where it's reading the numbers as OCTAL.

Ah, yes, the old leading 0 == base 8 trick...  This seems to trip up
people (both non-programmers and 'young' programmers).

> 
> -derek
> 
> On Wed, October 6, 2010 3:43 pm, Fred Bone wrote:
> > In my bank-account register, most entries are blank in the "Num" column
> > (e.g. for standing orders / direct debits, direct credits, ATM
> > withdrawals). For cheques I record the cheque number (6 digits); for one-
> > off online transactions I often record the merchant's reference number
> > (could be anything); etc.
> >
> > Looking for a particular cheque number just now, I sorted the register on
> > "Number".
> >
> > As expected, entries with blank "Num" were first. However, the non-blank
> > ones were not in the expected order, even after allowing for numeric
> > filing after alphabetic. This makes finding the required entry something
> > of a hit-and-miss affair. (Yes, I know I can use "Find" instead).
> >
> > Among the all-numeric ones, I got:
> > 001800 to 001886 (in order), then
> > 000192
> > 000193
> > 001686 to 001699
> > 001780 to 001799
> > 003790
> > 000163 to 000165
> > 000172
> > 001768 to 001769
> > 001778 to 001779
> > 002348
> > 002378
> > 002379
> > 002618
> > 002619
> > 004558
> > 004559
> > 001700
> > 001761 to 001767
> > 001770 to 001777
> > 002110
> > 002345 to 002347
> > 002350 to 002354
> > 002376 to 002377
> > 002616 to 002617
> > 002620 to 002621
> > 004410 to 004415
> > 004555 to 004557
> > and so on.
> >
> > Any comments?
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
>                                                                                  

-- 
Robert Heller             -- 978-544-6933
Deepwoods Software        -- Download the Model Railroad System
http://www.deepsoft.com/  -- Binaries for Linux and MS-Windows
heller at deepsoft.com       -- http://www.deepsoft.com/ModelRailroadSystem/