Display error when cell type is checkbox with ThreeState = True

Posted by: ghr on 8 September 2017, 2:24 pm EST

  • Posted 8 September 2017, 2:24 pm EST

    Hi, I detected this issue in the spread's grid:


    FpSpread1.Sheets(0).SetClipValue(0, 0, 1, 3, 2 & vbTab & 2 & vbTab & 2 & vbCrLf)

    MsgBox(FpSpread1.Sheets(0).GetValue(0, 0))

    Column 0 is set as a three state checkbox .

    The message box displays the value of 2 correctly, but the cell 0, 0 doesn't display the state 2 (undeterminated), nor states 0 or 1 in the grid.

    However using  SetClip, renders it correctly.

    1) It is an error?

    2) SetClipValue and SetClip are equivalents? Is there a difference between them? Is better using one of them?


    Thanks in advance...


  • Replied 8 September 2017, 2:24 pm EST


    "SetClipValue( )" sets a tab-delimited string of unformatted data in a specified range of cells on
    this sheet.The data is put directly into the data model without being parsed.where as "SetClip( )" method is used to set the formatted text, the data in the range is formatted using the composite style for the cell in the
    column header style model.

    They both seem to work fine for other graphical cell types.

    I am able to replicate the issue at my end, I will further investigate it to know if it is a bug.



  • Replied 8 September 2017, 2:24 pm EST


    I have reported this issue as a bug (#<span class="dlgtitle">99917274</span><span class="lockmsg"> </span>). It should be fixed  in our next maintenance release of Spread for Windows Forms.




  • Replied 8 September 2017, 2:24 pm EST


    It has been fixed with our latest build of Spread 4(4.0.2024.2005) , I request you to please download the same and test  this issue at your end. You may download the latest build from:

    ftp://ftp.fpoint.com/SpreadWinForms4/spwin4_net20-2024.zip  (for .net 2.0 framework)

    ftp://ftp.fpoint.com/SpreadWinForms4/spwin4_net35-3524.zip  (for .net 3.5 framework)



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels