cancel
Showing results for 
Search instead for 
Did you mean: 

How to know if a cell is enabled to edit

Former Member
0 Kudos

Hello

How I can know if a specific cell in a matrix is enabled, to avoid errors when I try to update the content.

I have tried with "Editable" property but when the column is disabled, returns Editable = True

....

If oMatrix.RowCount > 0 Then

Dim wrow As Integer

For wrow = 1 To oMatrix.VisualRowCount

If Not oMatrix.Columns("1").Editable Then Exit Sub

Set oEditText = oMatrix.Columns("1").Cells.Item(wrow).Specific

....

....

Thanks in advance.

Blas Gonzalez

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I use very similar code, and it works fine on 2004A Patch 9.

Which version are you using?

Former Member
0 Kudos

I'm using SBO2004A P14

Thanks

former_member185703
Active Contributor
0 Kudos

Hi Blas,

So you mean the column is visible, but disabled in the form settings?

Could you try it with PL 18 (or ask Carmen)?

If it is not working, I propose to report this as a bug on SAP Service Marketplace.

Thanks + sorry for the inconvenience,

Frank

Former Member
0 Kudos

Hi Frank,

I have a similar problem... I added some user fields in the deliveries form and I want to write some values in them even they're invisible(I don't want extra columns to be accessible to the user). When I try to hide them by code ( Columns("U_xxx").Visible = false, Columns("U_xxx").Enabled = true) the values are simply not written. If I left them visible, the code works fine.

I worked around this setting the columns width to 1

Is this by design ?

Thanks