Skip to Content
avatar image
Former Member

Edit Specific Matrix Cell's Valid Values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 09, 2017 at 07:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded