914858_en-US

liliconcom

ComboBox dropdown resizing issue with lengthy values

<!--StartFragment -->

I’m running into an issue with the ComboBox in JMP. The dropdown width is automatically adjusted based on the longest value in the list. Since I’m loading data from a database, most values are short, but a few are very lengthy. When those long values are included, the entire dropdown becomes excessively wide.

</CODE></PRE>
<P>I haven’t been able to find any documentation on how to control or fix the dropdown size. Is there a way to set a maximum width or otherwise prevent the ComboBox from expanding too much when one value is lengthy?</P>
<PRE><CODE class=" language-jsl"><!--EndFragment -->

<BR />// Example ComboBox with mixed-length values
New Window( "ComboBox Size Issue",
    <<BACKGROUND color=""></BACKGROUND>

Automation and ScriptingBasic Data Analysis and ModelingRe: ComboBox dropdown resizing issue with lengthy values

I'm not sure if you can force the max size of combo box so you would have to first shorten those values. 

Re: ComboBox dropdown resizing issue with lengthy values

Truncating the data would be costly since the data is in the thousands.

Re: ComboBox dropdown resizing issue with lengthy values

Have you tried how costly it would be if you do it in JMP either with Transform Each() or with formula column/transform column only on unique values?

Re: ComboBox dropdown resizing issue with lengthy values

You can "force" Combo Box width at least with Lineup Ruler Box + Lineup Box

Names Default To Here(1);

nw = New Window("",
	Lineup Ruler Box(
		Widths({100}),
		Lineup Box(N Col(1),
			Combo Box({"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"})
		)
	)
);