Why the column disappear when I double click the column sider?

Posted by: jason-pan-live-com on 8 September 2017, 1:41 pm EST

  • Posted 8 September 2017, 1:41 pm EST

    Why the column disappear when I double click the column sider?

     

    Code as below:

    ------- 

     FPSpread1.ActiveSheet.ColumnCount = 6

    FPSpread1.ActiveSheet.RowCount = 0 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 0, "Label1") 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 1, "Label1") 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 2, "Label1") 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 3, "Label1") 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 4, "Label1") 

    FPSpread1.ActiveSheet.SetColumnLabel(0, 5, "Label1") 

    FPSpread1.ActiveSheet.SetColumnWidth(0, 140)

    FPSpread1.ActiveSheet.SetColumnWidth(1, 150)

    FPSpread1.ActiveSheet.SetColumnWidth(2, 130)

    FPSpread1.ActiveSheet.SetColumnWidth(3, 144)

    FPSpread1.ActiveSheet.SetColumnWidth(4, 155)

    FPSpread1.ActiveSheet.SetColumnWidth(5, 166)

     

    --------------

     

  • Replied 8 September 2017, 1:41 pm EST

    I am using "Spead for .NET 3.0J Windows Forms" version.
  • Replied 8 September 2017, 1:41 pm EST

    I do not have that version to test with but I am not seeing that behavior with the version I do have.  See if there is an update to the version you have.  Double-clicking on the row or column edge resizes the row or column to fit the
    widest content of that row or column (preferred width).  But this should not be making the column disappear.  If it is then I would say it is a bug.
  • Replied 8 September 2017, 1:41 pm EST

    I can reproduce this bug when the spread has only header without any data row. Anyway I will try a new version.
  • Replied 8 September 2017, 1:41 pm EST

    Hello,


    I tested this with the latest maintenance release and it was keeping the column width the correct size. Even with no rows, the column width does not go to 0.

Need extra support?

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

Learn More

Forum Channels