[RESOLVED] Is anyone here working with the Farpoint spread control?

Hi Folks,
I am working with Spread Designer 2.5, after a very long time.
I want to make a few cells in a specific column non editable.

I am populating the spread control from an array. This array has an element "approval_status". If the value of approval status is "Y", then the cell needs to be locked down. I tried using blockmode, but it is not working for me.

Code:

---

      spdApprovalList.Col = mnApprovalStatus
      spdApprovalList.CellType = SS_CELL_TYPE_CHECKBOX
      spdApprovalList.TypeCheckTextAlign = SS_CELL_H_ALIGN_RIGHT
      spdApprovalList.TypeCheckText = "Yes"
      spdApprovalList.BlockMode = True
      spdApprovalList.Row = ilIdx
      spdApprovalList.Row2 = ilIdx
      spdApprovalList.Col2 = mnApprovalStatus
      spdApprovalList.Lock = True
      spdApprovalList.Protect = True
      spdApprovalList.BlockMode = False
      If arrETApproval(ilIdx).Approval_Status = "Y" Then
            spdApprovalList.Col = mnApproveDate
            spdApprovalList.text = arrETApproval(ilIdx).Approval_Date
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
            spdApprovalList.Col = mnApprovedBy
            spdApprovalList.text = arrETApproval(ilIdx).Approved_By
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
      Else
            spdApprovalList.TypeCheckType = 0
            spdApprovalList.TypeCheckText = "No"
            spdApprovalList.Protect = False
      End If

---

:wave:

Figured it out for now.

Code:

---

      spdApprovalList.Col = mnApprovalStatus
      spdApprovalList.CellType = SS_CELL_TYPE_CHECKBOX
      spdApprovalList.TypeCheckTextAlign = SS_CELL_H_ALIGN_RIGHT
      spdApprovalList.TypeCheckText = "Yes"
      If arrETApproval(ilIdx).Approval_Status = "Y" Then
            spdApprovalList.BlockMode = True
            spdApprovalList.Col = mnETApproved
            spdApprovalList.Row = ilIdx
            spdApprovalList.Row2 = ilIdx
            spdApprovalList.Col2 = mnTerminateDate
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
            spdApprovalList.BlockMode = False
            spdApprovalList.Col = mnApproveDate
            spdApprovalList.text = arrETApproval(ilIdx).Approval_Date
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
            spdApprovalList.Col = mnApprovedBy
            spdApprovalList.text = arrETApproval(ilIdx).Approved_By
            spdApprovalList.Lock = True
            spdApprovalList.Protect = True
      Else
            spdApprovalList.TypeCheckType = 0
            spdApprovalList.TypeCheckText = "No"
            'spdApprovalList.Protect = False
      End If

---

:wave:

Are you still using this control?

You can still license it. Just USD $1499 per developer.