Created attachment 374170 [details] screenshot showing wrong sorting order In the screenshot shown, I am attempting to sort the accounts by the Total (Period) column in descending order. However, it puts CN¥530.15 above £256.93, which is wrong (CN¥530.15 is less than £256.93).
By rather a lot. HKD 2005 is also less than £257, assuming that the £ means GBP. Do you have more or less correct exchange rates, around 9p to the HKD and 11p to the CNY, as the latest in the price database? Do all of the other columns mis-sort the same way?
Yes, all exchange rates are entered. They are shown correctly at "Present (GBP)" column.
OK. And do the other mixed-commodity columns sort the same (incorrect) way? Does Present (GBP) sort correctly?
(In reply to John Ralls from comment #3) > OK. And do the other mixed-commodity columns sort the same (incorrect) way? > Does Present (GBP) sort correctly? Sorting by Present (GBP) is also wrong. See attachment.
Created attachment 374181 [details] Sorting by Present (GBP) is wrong
Does your theme put the reveal arrows on the left of the column label instead of Adwaita's right side? If not then that's sorted by the present column rather than the present(GBP) one.
The arrow is placed on the left for right-aligned columns, and on the right for left-aligned columns.
OK, thanks.
Fixed. The problem was that no currency was being passed to the balance functions so each was returning a value in the account currency, which was then ordered numerically, so one would get HKD 110 > £100, even if the values shown in the column *were* converted to some currency, so one might get £20 > £100 if the account with the £20 balance was an HKD account. The fix will appear in GnuCash 4.7 and tomorrow's flatpak nightly.
