Skip to Content

Edit Specific Matrix Cell's Valid Values

Sep 06, 2017 at 06:46 AM


avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
DIEGO LOTHER 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

10 |10000 characters needed characters left characters exceeded