Ask Your Question

Calc sort is broken in 5.1.0

asked 2016-03-02 01:31:52 +0200

MikeFinch gravatar image

updated 2016-03-07 15:13:18 +0200

Alex Kemp gravatar image

The sort was broken a few versions ago and was subsequently fixed.


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-03-02 02:13:04 +0200

m.a.riosv gravatar image

updated 2016-03-02 02:13:28 +0200

What is broken?

Maybe the option

Menu/Tools/Options/LibreOffice calc/General - Update references when sorting range of cells.

edit flag offensive delete link more


Please see my new thread "Sorting a range that is referenced elsewhere". But thanks for the tip about the update references setting...

Al Vesper gravatar imageAl Vesper ( 2016-03-05 16:37:54 +0200 )edit

I have tested before comment, and works for me. If you like, share a sample file where to verify the issue.

m.a.riosv gravatar imagem.a.riosv ( 2016-03-05 16:42:57 +0200 )edit

In 4.2.8 I can't find that option (Update references when sorting range of cells) yet, so maybe it will help if I upgrade; thank you!

A lame attempt at anonymity gravatar imageA lame attempt at anonymity ( 2016-03-27 17:43:46 +0200 )edit

I think it is there since 4.4.

m.a.riosv gravatar imagem.a.riosv ( 2016-03-27 18:26:14 +0200 )edit

Why is this not enabled by default??

endolith gravatar imageendolith ( 2016-07-06 21:19:15 +0200 )edit

answered 2016-03-27 17:34:14 +0200

A lame attempt at anonymity gravatar image

updated 2016-03-27 17:38:22 +0200

I managed to break sort in 4.2.8 using the following clever procedure:

a) First, I wanted to enter some 2015 dates when it is 2016 now. (See

b) I entered them in column A, used a formula to compute the 2015 dates in column B, and hid column A

c) Then I selected the whole range and sorted by the results of the formula, but I think column A was not included

d) I think Calc obediently moved the rows around according to the date value, but then recomputed the formula values, so it looked like the other columns were sorted, but not the computed date in column B, so it looked like sort was broken.

This means I have to type it over again, since I didn't figure it out til the next morning and I had already closed the spreadsheet so I could not do control-Z. (I could try to reconstruct the inverse operations)

The Calc question in here is whether it would work if I had included column A. I couldn't sort by column A. Would I have to change any setting about what the references will do when columns are sorted? It should be simple since it's the same formula on every row.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-02 01:31:52 +0200

Seen: 247 times

Last updated: Mar 27 '16