Combocell and Formula

Posted by: ivangb on 8 September 2017, 2:30 pm EST

  • Posted 8 September 2017, 2:30 pm EST


    I have a CellType set to a comboCell. This cell accepts Formulas. If I type some value into it or choose from the combo items, all fine. If I enter a Formula into it, again, it works properly. But then, if I enter a Formula into it, exit editing mode, and later go back to this cell and try to enter a value direct, it won't let me do it. As soon as the cell exits editing mode, the Formula goes back to it and it is set to its original value, as if I had pressed Esc. Not even the spread Change event gets fired when there was a Formula before I enter any other value. The only way I found to get rid of the Formula that was there, is to type "=" twice. The first will only show the formula already there, the second will enter editing mode and then I erase this second "=" and enter a value, which will fire Change event and work as it should.

    Any ideas of what could be happening or even a workaround to it?

    Thanks in advance.

  • Replied 8 September 2017, 2:30 pm EST


    Can you send me the sample replicating the issue because I am unable to get it work as explained by you. I would request you to send me a sample across for us to debug it at our end and assist you.


  • Replied 8 September 2017, 2:30 pm EST

    Thank you for your reply.

    I would really like to get a sample together so we could check this, but I had to find a workaround and changed the way I would offer the cell to the end user, so I got rid of the combocell for that particular column and went a different path.

    My spread is bound to a Business Object, through a BusinessBindingSource. As soon as I get some time to spare (yeah, in my dreams) and have the need for the same situation, I will try and write a sample to send to you guys.

    Thanks for the attention, anyway.


Need extra support?

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

Learn More

Forum Channels