We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Spreadsheet sort issue for cashbook [closed]

asked 2014-06-23 04:32:14 +0200

Ananda gravatar image

updated 2020-08-02 14:41:29 +0200

Alex Kemp gravatar image

Hi am using v4.1.6.2 on win 8 I have made a spread sheet for my cashbook and cannot seem to sort the expences column and then have all the rows sort themselves according so things are not mixed up like date, data (amount), etc.
thanks Libre helpers

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-26 00:08:56.098251

1 Answer

Sort by » oldest newest most voted

answered 2014-06-23 08:27:57 +0200

ROSt52 gravatar image

updated 2014-06-23 10:20:47 +0200

When you want to sort a data array by one column and have the other following this sorting, the array must be connected. This means there may not be empty rows of columns in between.

Your data structure is not know thus a very precise advice is difficult. However, there is kind of fall-back possibility.
- Select the entire data range - empty rows and columns within your data range must be included
- Menu: Data > sort > select your expense column => sort window opens
- Select ascending or descending > OK

It is worthwhile to have a look into the free guides: http://www.libreoffice.org/get-help/d...

To make sure, that the order of all cells are changed together with the column, which is sorted, I background-color one or two rows completely and this allows me to see if all is correct.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-06-23 04:32:14 +0200

Seen: 82 times

Last updated: Jun 23 '14