Edit Specific Matrix Cell's Valid Values

[Former Member]

Hello everybody,

I have created a user form using SAP Business One Studio for Visual Studio with a Matrix. One of Matrix's cells is a combo box. My issue is that each line's combo box may have different valid values from another line. If I try to remove/add valid values for a specific line, all valid values change.

Here is a code sample for choosing combo box cell at a specific line and trying to add/remove valid values

SAPbouiCOM.ComboBox _ComboBox;

_ComboBox = (SAPbouiCOM.ComboBox)this.Matrix0.Columns.Item("Col_4").Cells.Item(1).Specific;

_ComboBox.ValidValues.Remove("01", "Sample01");

_ComboBox.ValidValues.Add("02", "Sample02");

Kind regards,

Dimitris Theotokatos

[former_member185682 · Accepted solution]

Hi Dimitris,

This is not supported on standard matrix combobox column. A workaround is create your own control like the choose from list. Add a EditText on your matrix, and when the user press tab key on this column, open a form with the options.

Hope it helps.

Kind Regards,

Diego Lother