I've got a table in Calc v 2.3.0 that I'd like to sort.
One of the columns to be used in the sort contains either a date value or is
blank. I'd like to be able to sort the blanks before the dates. Regardless
of whether I select ascending or descending sort for that column the blanks
always sort
At 16:02 12/10/2007 -0400, Alan Boba wrote:
I've got a table in Calc v 2.3.0 that I'd like to sort.
One of the columns to be used in the sort contains either a date
value or is blank. I'd like to be able to sort the blanks before the
dates. Regardless of whether I select ascending or
Brian,
It works.
Yes the cells are empty not blank. And adding a space, , to each cell
changed the sort as desired. Have to update formulas in the worksheet now
that the cells are not empty to get the desired results in the formula
cells.
Though this solution works I would say it is not
On Friday 12 October 2007 23:13:27 Alan Boba wrote:
Brian,
It works.
Yes the cells are empty not blank. And adding a space, , to
each cell changed the sort as desired. Have to update formulas in
the worksheet now that the cells are not empty to get the
desired results in the formula