I try to sort data in a column using the sort icon, nothing happens (the data are % results of a calculation). I would like all the rows to be included in sorting the calculation results.
Thanks for your help.
[Solved] Unable to sort
[Solved] Unable to sort
Last edited by Hagar Delest on Mon Jun 19, 2017 9:41 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice v.4.0.1 on Windows 7
Re: unable to sort
Please upload your .ods type example file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: unable to sort
What a cellrange did you selected before the sorting?
If you selected the results (the calculation formulas) only, then it is a normal behavior.
Same formula, on a non-sorted input data: the order of the result will not be changed, because the order of the input data is not changed.
In this case you need use the 'Extend selection' option (or you must select the related cellranges /input data/) too.
If you selected the results (the calculation formulas) only, then it is a normal behavior.
Same formula, on a non-sorted input data: the order of the result will not be changed, because the order of the input data is not changed.
In this case you need use the 'Extend selection' option (or you must select the related cellranges /input data/) too.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: unable to sort
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Unable to sort
Thanks for your reply:
I had a blank column before my results--sorting is OK now
I had a blank column before my results--sorting is OK now
OpenOffice v.4.0.1 on Windows 7