Code: Select all
[Title] [QTY] [Value]How can I do it?
[Solved] How to sort group rows based on first column?
[Solved] How to sort group rows based on first column?
I have something like
I need to sort TITLE alphabetically but this will re-arrange items in one column mismatchig existing values, I want to take into account the rest of the columns that form a logical row.
How can I do it?
How can I do it?
Last edited by Hagar Delest on Sat Jul 31, 2021 10:05 am, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 3 on Windows 10/7
Re: How to sort group rows based on first column?
You should be able to click on any cell in the Title column and then either click on the sort button on the main tool bar or use the menu Data -> Sort. The selected range will expand to the contiguously filled area around the selected cell. Does that not work for you?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: How to sort group rows based on first column?
Is there any way to lock table header or final summary row from sorting? If I sort selected range in column A it wont sort the associated rows properly, sadly.
OpenOffice 3 on Windows 10/7
Re: How to sort group rows based on first column?
viewtopic.php?f=9&t=72449&p=326195#p326195
Create a valid header row, that is a row with text only, no blanks, no numbers.
Create a valid header row, that is a row with text only, no blanks, no numbers.
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