Apache OpenOffice (AOO) Bugzilla – Issue 115242
balloon help covers input line when editing formula
Last modified: 2010-11-01 17:42:51 UTC
When editing a formula on the input line, the helpful popup does not always appear Below the input line. To duplicate, have a complex formula entered in a cell, something like: =$H12*SIN((I12-F12)/180*PI()) Move the mouse pointer/cursor over the center of the formula, click in -F12 or highlight -F12 as if to change the contents. If the mouse cursor is left on the line or above it, a yellow box appears below the input line that says SIN( > number ) This is fine and good. But if the mouse cursor is moved down, or drifts below the input bar, the help box appears directly over the input line, making it impossible to see the contents being edited. Also when moving the text cursor, typing <- the left arrow on the keyboard, the help box location changes from below, to left and covering, or sometimes only half covering. The way to duplicate this is to move the cursor left 20 spaces, then right 20 spaces (to get your finger warmed up), watching where the help box moves to.... then the key is for the cursor to move Left of the mouse cursor. It only happens when the mouse pointer is directly over where the help box would go. The area between the input line and the column grid, and also the top half of the column letter grid. When editing directly in the spreadsheet grid, moving the mouse around the Cell being edited also results in the same behavior. It looks like the help box is evading the mouse. I do not agree with that behavior. The help box should never cover the input line, or the text cursor. I've been frustrated by this bug for what? a couple years? hitting escape and trying again, or having to re-edit the formula... If I had only known the solution was to move the mouse! At least I can finally report it including the trigger.
A nice description. It makes me reproduce the bug easily in OOo3.2. Fortunately the bug has been fixed for the next version. You can try release candidate OOo3.3.0 already and see whether it works for you too. http://download.openoffice.org/next/ *** This issue has been marked as a duplicate of 105472 ***
closing, duplicate
Release Candidates can be found here: http://download.openoffice.org/all_rc.html
Confirmed fixed in OO 3.3 RC2 THANK YOU