Posted 12 April 2018, 3:26 am EST
Hi,
The application that I’m converting from VB 6.0 to VB 2017 uses combo boxes to display multiple values assigned to a particular cell. There can be more than one combo box (one per cell of course) depending on how many cells have more than one value assigned. Basically the application identifies those cells with multiple values by changing the background color and when the user selects that cell a combo box is shown to allow the user to select one value and return the selected value. The combo box disappears when the user moves to a different cell.
Using Spread.NET WPF I have created the VB logic to create a Combo Box in a selected cell(s) using the example from the Spread WPF Help file (ShowDrawingObjectOnly Property) and changed Button to ComboBox but after I created multiple combo boxes using Me.GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(New MyDrawingCell(row, column) [used different row/column numbers]) and a variable that contains the values to be displayed. I placed some data in the variable used the AddRule call for a cell, then modified the variable with different data and used the AddRule for another cell. The comboboxes are displayed in the correct cell/column but the data is the same for all comboboxes. Do you have any suggestions?
Thank you,
Luis