Hello,
I want to ascending - descending my data. But for normal behavior, Libreoffice Calc will change my data permanent. How to ascending - descending then undo my changed.
Thank you.
A couple of questions:
- Where should the sorted data set be placed? In a differnt column or row?
- And i assume you data “to be” sorted is in one column range, correct?
- From you undo requirement, it sounds like you want to sort the data “in-place” is that correct?
A simple way is to exit the file without saving after the changes in order were made.
A database is the tool to handle such “sequencing arbitration”.
Managing this in a spreadsheet is possible, but requires some work. Different strategies:
- Add a sequence field to your table. Insert a number series down the column. Sort on this field to revert to original order.
- Use functions
RANK(),LARGE()andSMALL()to extract data in sort sequence from an unsorted dataset.
Both strategies pose challenging situations.
- Challenge for sort/re-sort using the sequence field: When you add data, you must remember to add the next-in-sequence number to the record.
- Challenge for sequencing “in-place” using ranking functions: Ties/duplicates are difficult to manage gracefully.
For more than a trivially simple and small dataset, consider building a proper database.
calc ‘undo’ - ctrl-z - is very powerful … but be careful:
-
once you run out of undo’s data may get lost,
-
similar on crashes,
-
work done in such temporarily sorted data will be lost by undo as well … you have ‘redo’, but then the sorting will reappear too,
for frequent use some preparation of the data will be better, a ‘sequence field’ as proposed by @keme, and keyboard shortcuts to sort by that and to renew it after adding / deleting data will be quite good,
if you need the sorting to find data identical in one column / property autofilter might be faster, i’d build me a utility which toggles filtering the column of the actually selected cell for the value of that selected cell … very handy …
P.S. ‘solved marks’ and ‘likes’ welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the “^” above it if you ‘like’ the answer,
“v” if you don’t,
do not! use ‘answer’ to add info to your question, either edit the question or add a comment,
‘answer’ only if you found a solution yourself …