ReoGrid Forum

asparatu

Member

Registered: 2014-08-20

Posts: 196

Remove column Error

Hello Jing,
    I have notice that when i remove more then one column in the spreadsheet the control looks like this

The code

 With rgInputDataSheet
            'checks to see if the column count is greater then 2
            If .ColumnCount > 2 Then
                '*******************************************************************************
                '* Resets the validrange that can be accessed
                '*******************************************************************************
                'Sets the validrange values
                Dim posOne As New ReoGridPos(1, 1)
                Dim posTwo As New ReoGridPos(.RowCount - 1, .ColumnCount - 2)

                'Sets the validrange
                validRange = New ReoGridRange(String.Format("{0}:{1}", posOne.ToAddress, posTwo.ToAddress))

                'Sets the selection range of the validrange
                .SelectionRange = New ReoGridRange(validRange.StartPos)

                '*********************************************************************************
                '* Removes the column from the worksheet
                '*********************************************************************************
                .DeleteColumns(.ColumnCount - 1, 1)

                '*********************************************************************************
                '* Checks to see if the button should be enabled or disabled
                '*********************************************************************************
                If .ColumnCount > 2 Then
                    btnSubtractColumn.Enabled = True
                Else
                    btnSubtractColumn.Enabled = False
                End If

                If rgInputDataSheet.ColumnCount > 21 Then
                    btnAddColumn.Enabled = False
                Else
                    btnAddColumn.Enabled = True
                End If
            End If
        End With

Shane

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Remove column Error

Thanks Shane, I'm now going to check this problem.

asparatu

Member

Registered: 2014-08-20

Posts: 196

Re: Remove column Error

Hello Jing,
   Did you find a problem with the removing a column in worksheet?

Shane

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Remove column Error

No, I can't find problems when deleting columns, could you provide an example rgf?