Cannot edit cell which spans columns when first column is hidden.

Posted by: kylehuff on 8 September 2017, 2:19 pm EST

  • Posted 8 September 2017, 2:19 pm EST

    Spread for Windows Forms 4 for 3.5 framework

    I have a text cell which spans columns.  Sometimes, the first column is hidden.  When this is the case, the cell displays properly, and the formula bar also displays properly.  However, double-clicking does not invoke the editor and the formula bar refuses to change the value of the cell.

    How to fix?  As a temporary hack, I have a sidekick column that is almost hidden, but not quite (cell width 1) that is used as the first column.  If the width is set to 0, the same problem occurs.

  • Replied 8 September 2017, 2:19 pm EST

    Hello,

    We are unable to replicate the issue at our end with Spread version 4.0.3515.2008. Can you please post a sample replicating the issue for us to debug at our end?

    Thanks.

  • Replied 8 September 2017, 2:19 pm EST

    namespace WindowsFormsApplication1
    {
        public partial class Form1 : Form
        {
            public Form1()
            {
                InitializeComponent();
            }

            private void loadMainForm(object sender, EventArgs e)
            {
                fpSpread1_Sheet1.Cells[2,2].ColumnSpan = 3;
                fpSpread1_Sheet1.Cells[2, 2].Text = "I am uneditable.";

                fpSpread1_Sheet1.Columns[2].Width = 0;
               // or  fpSpread1_Sheet1.Columns[2].Visible = false;

            }
        }
    }

    Presto,  you cannot edit the text cell that appears to be located at D3, but which is really C3.

    Edit: it would appear that in 3515 this problem only comes up if Visible is false.  Width == 0 is OK.

  • Replied 8 September 2017, 2:19 pm EST

    Hello,

    We are able to replicate the issue stated by you and have reported it as bug number #99915992 in Spread 4.0.3515.2008. It will be fixed in the future maintenance release of Spread.

    Thanks.

Need extra support?

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

Learn More

Forum Channels