IntelliSense icon indicating copy to clipboard operation
IntelliSense copied to clipboard

Inaccurate mouse click tracking inside in-cell formulas

Open govert opened this issue 6 years ago • 3 comments

When mouse clicking into the in-cell formula we somehow fall one mouse click behind, with the formula prefix and display matching one mouse click earlier. The formula bar edit box does not have this problem.

govert avatar Apr 27 '18 10:04 govert

Maybe it's somehow related to the problem the author of DotNetRefEdit (https://github.com/Ron-Ldn/DotNetRefEdit) tried to solve? "Actually, the first click will activate the window and then Excel will discard the message." I don't mean it's the exactly the same issue, but maybe in this case Excel eats one of the window messages too?

hell-racer avatar Apr 27 '18 12:04 hell-racer

Excel seems to process the mouse message correctly, but the API call I use to get the formula state and caret location returns the wrong information in this case. For the formula edit box the information is correct after a mouse click, so it looks like a small Excel bug. I can imagine some workarounds - e.g. detecting the mouse and sending quick right-left keyboard movement or something like this. I'm leaving it for another day, though.

govert avatar Apr 29 '18 15:04 govert

I've extended the edit state update delay in version 1.0.9, which might help this a bit.

govert avatar Jun 24 '18 19:06 govert