convert formula results to fixed number?
by piobair from LinuxQuestions.org on (#4W0A9)
I have a LibreOffice spreadsheet. I inserted a new column A and then generated ascending numbers. Then, if I sort on column C, the column A does not change, since the result of the sort apparently copies the formula instead of the value.
Is there some way to convert the calculated value to a fixed number so that it will sort correctly?
Is there some way to convert the calculated value to a fixed number so that it will sort correctly?