Sorting a column in Calc

[Giraffe]

Although I have Office 2003 I prefer to use LibreOffice Calc for dabbling in spreadsheets.
If I download an .xls file of my bank statement it opens in Calc but the bank has the Date in descending order - I prefer it ascending (seems more logical).
If I sort the Date field (either the whole data or just the column but let it extend the sort) most of the columns are OK but the Totals column isn't (sometimes another one will 'fail' as well) and the same thing happens in Excel, so it's not just Calc.
Any tips please on how to make all columns keep with the Date - I seem to have a problem with reconciling the statement when the data are random!

[cookie365]

What do you mean by 'the Totals column isn't'?

Do you mean it doesn't sort and stays at is?

I don't know anything about Calc, but if it's like a proper spreadsheet then make sure there are no empty columns or rows in the table you're trying to sort.

[Giraffe]

When the Date column is sorted, the Totals column does change its order but not to the correct order to match Date, so the final total can be any figure in the Totals column and other balances are wrong for the date.

I've just transferred all of the debits to the credit column and deleted the credit column, thus eliminating blank cells and the Totals column still is in the wrong order.

Thanks for the suggestions.

[cookie365]

I only know Excel, but you don't need to eliminate blank cells, just blank rows or blank columns within the table so I guess Calc will be the same?

Are you saying it seems to reorder the total column apparently at random? What exactly is in the totals column? Is it a formula?

Any way you could anonymise the data and upload it here?

[Giraffe]

There aren't any blank rows or columns within the selected area and eliminating 2 blank rows above that area makes no difference.
I've tried all ways of selecting/extending the column/area and also with/without recognising special numbers (currency; date).
There are no formulae - in a way it's not a 'real' spreadsheet but just the data in rows and columns.
I don't want to post it as there is a lot of specific, traceable detail and if I alter it to the extent necessary I might well do something to make it behave in a different way from the original file - sorry.