ReoGrid Forum

[email protected]

Member

Registered: 2014-08-09

Posts: 24

Dropdown cell

Hi,

Is it would it be possible to add each string inuvidually instead of addrange.
This would be very convenient because exchange rates I am using change daily.

Regards, Peter

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Dropdown cell

OK, Could you provide some code to describe the expected practice?

e.g.

Dim dropdown As New DropdownCell("A", "B", "C")

[email protected]

Member

Registered: 2014-08-09

Posts: 24

Re: Dropdown cell

cbstr1 = arrlst1.ToArray(GetType(String))
                For i = 0 To cbstr1.Count - 1
                    If i = 0 Then
                        strQ = "{" & strQ & Chr(34) & cbstr1(i) & Chr(34)
                    ElseIf i = cbstr1.Count - 1 Then
                        strQ = strQ & Chr(34) & cbstr1(i) & Chr(34) & "}"
                    Else
                        strQ = strQ & Chr(34) & cbstr1(i) & Chr(34) & ","
                    End If

dropdowncell.add(strQ)  "Each string added seperately would be very helpfull. Otherwise I can't use Reogrid (I Love it)"

                Next i

Last edited by [email protected] (2014-09-03 13:03:53)

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Dropdown cell

The new version add a collection of items, which provides the ability to add or remove single item.

Dim body = New DropdownCell()
body.Items.Add("aa")
grid.CurrentWorksheet("A1") = body