Skip to main content
E
entec26-Contributor
6-Contributor
November 30, 2022
Question

Populating a combo box

  • November 30, 2022
  • 1 reply
  • 3311 views

Is there a procedure to use the data from an referenced Excel file or matrix to populate a combo box?

 

Thanks,

1 reply

T
terryhendicott21-Topaz II
21-Topaz II
December 1, 2022

Hi,

 

As far as I know no.

 

It is possible to cut and paste one value at a time!

 

Are the referenced Excel or matrix constant values or are they calculated?

If they are constant values there is a way to manipulate the underlying Prime xml file to create large data combo boxes

File shows examples with 2091 rows and 165 rows respectively.

Can the information needed in the combo box (if constant) be uploaded as either Excel or Matrix?

Cheers Terry

 

 

R
RantEng14-Alexandrite
14-Alexandrite
December 1, 2022

It can be very cumbersome working with large data sets associated with a combo box.  Mathcad 8 has added some functionality for pasting into a combo box.  The practical limit seems to be a table that can fit on the screen at one time. 

 

For larger systems, my solution is more of a workaround.  I use the combo box as a selection ID that I pass to an embedded.  The spreadsheet.  The spreadsheet then passes the lookup values back to Mathcad.  The spreadsheet can be hidden in a collapsed area.  

Terms & ConditionsAccessibility statement