[Solved] Sorting with blank
-
- Posts: 3
- Joined: Thu Oct 11, 2018 4:33 pm
[Solved] Sorting with blank
Thank you in advance. I have column's with blank spaces between the values. How can I sort and keep the spacing.
Last edited by Hagar Delest on Fri Oct 12, 2018 9:58 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.1 on Windows 7
Re: Sorting with blank
Please upload a sample file here in ODF format - with "before"/"after" contents of the cellrange.
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.
-
- Posts: 3
- Joined: Thu Oct 11, 2018 4:33 pm
Re: Sorting with blank
OK, I hope this works. I would like to sort column 'J' and keep the spacing blanks between each team. When I sort all the team compress in the column. Thanks
- Attachments
-
- NFL SCHEDULE 2018-19 (1).ods
- (11.86 KiB) Downloaded 81 times
OpenOffice 4.1.1 on Windows 7
Re: Sorting with blank
Why you need the empty rows?
I suggest you to use filled rows only, and - if you need some space between the data - use rows with larger height, and vertically middle-adjusted content. Use the Cell styles instead of the direct fomatting properties for the align.
I suggest you to use filled rows only, and - if you need some space between the data - use rows with larger height, and vertically middle-adjusted content. Use the Cell styles instead of the direct fomatting properties for the align.
Last edited by Zizi64 on Thu Oct 11, 2018 9:07 pm, edited 1 time in total.
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.
-
- Posts: 3
- Joined: Thu Oct 11, 2018 4:33 pm