[Solved] Is it possible to remove "empty" rows in drop list?

Discuss the spreadsheet application

[Solved] Is it possible to remove "empty" rows in drop list?

Postby Fredrik Nilsson » Thu Apr 11, 2019 1:56 pm

Hi!

Is it possible to remove "empty" rows in drop list?
I want to achieve a more compact list.

/Fredrik
Attachments
1.jpg
Blank cell in list example 1.ods
(36.78 KiB) Downloaded 13 times
Last edited by Hagar Delest on Wed Apr 17, 2019 9:30 pm, edited 1 time in total.
Reason: tagged solved
Apache openoffice 4.1.1
Windows 10
Fredrik Nilsson
 
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am

Re: Is it possible to remove "empty" rows in drop list?

Postby gerard24 » Thu Apr 11, 2019 4:59 pm

Check the box : "Sort entries ascending" in the data validity dialog (just above the source).
LibreOffice 6.2.4 on Windows 10
gerard24
Volunteer
 
Posts: 948
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Is it possible to remove "empty" rows in drop list?

Postby Villeroy » Thu Apr 11, 2019 5:39 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

[Solved] Is it possible to remove "empty" rows in drop list?

Postby Fredrik Nilsson » Wed Apr 17, 2019 7:38 pm

Hi!
Thanks to both of you who helped me! :D
Apache openoffice 4.1.1
Windows 10
Fredrik Nilsson
 
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests