Strange sorting

Anthony Dardis adardis at gmail.com
Wed Oct 6 18:19:48 EDT 2010


Speaking as an old young programmer, seems like it would be non-trivial  
for the "interpret as octal" hook to grab onto the transaction number  
field, since it appears to be a string. But stuff happens.




On Wed, 06 Oct 2010 16:10:11 -0400, Robert Heller <heller at deepsoft.com>  
wrote:

> 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.
>>
>>


More information about the gnucash-user mailing list