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.