Hi!
Is it possible to remove "empty" rows in drop list?
I want to achieve a more compact list.
/Fredrik
[Solved] Is it possible to remove "empty" rows in drop list?
-
- Posts: 12
- Joined: Fri Mar 29, 2019 9:51 am
[Solved] Is it possible to remove "empty" rows in drop list?
- Attachments
-
- Blank cell in list example 1.ods
- (36.78 KiB) Downloaded 67 times
Last edited by Hagar Delest on Wed Apr 17, 2019 9:30 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Apache openoffice 4.1.1
Windows 10
Windows 10
Re: Is it possible to remove "empty" rows in drop list?
Check the box : "Sort entries ascending" in the data validity dialog (just above the source).
LibreOffice 6.4.5 on Windows 10
Re: Is it possible to remove "empty" rows in drop list?
Delete cells in order to shrink the list.
Insert new cells before filling them in order to expand the list.
This works with all references in the entire Calc applications, formulas, names, charts, conditional formatting, validity, list boxes, combo boxes, whatelse.
Make sure that Tools>Options>Calc>General: "Expand references ..." is turned on. This way you can also insert new cells directly below the reference, for instance insert at X11 in order to expand a reference X1:X10.
Insert new cells before filling them in order to expand the list.
This works with all references in the entire Calc applications, formulas, names, charts, conditional formatting, validity, list boxes, combo boxes, whatelse.
Make sure that Tools>Options>Calc>General: "Expand references ..." is turned on. This way you can also insert new cells directly below the reference, for instance insert at X11 in order to expand a reference X1:X10.
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
-
- Posts: 12
- Joined: Fri Mar 29, 2019 9:51 am
[Solved] Is it possible to remove "empty" rows in drop list?
Hi!
Thanks to both of you who helped me!
Thanks to both of you who helped me!
Apache openoffice 4.1.1
Windows 10
Windows 10