Apache OpenOffice (AOO) Bugzilla – Issue 63604
text cut in formula bar when using large UI fonts
Last modified: 2017-05-20 10:22:43 UTC
Anything entered into the formula bar drops down a half-line when you try to edit, thus making it very difficult to read. 1. Enter a formula into the formula bar. 2. Now place the cursor somewhere in the formula (to change a cell reference, for instance). 3. As soon as you attempt to edit the formula the whole thing drops down half a line, so the bottom half disappears out the bottom of the window. I have noticed on longer formulae, sometimes parts of the formula drop even lower. 4. Once you press enter to accept the edit, move to a different cell, and then move back to the original cell, the formula will be restored to the center of the window, but will drop down again if you attempt another edit.
I forgot to mention that I have noticed this defect since vs. 2.0. Thinking that I may have a corrupted install, since I normally instal new versions on top of the older ones, I did a complete uninstall (except for my profile) and then re-installed vs. 2.0.2 from scratch. Unfortunately, this did not correct the problem. Bob
Tested it with WinXP oodev160. Everything looks ok. formula used for testing was =A2+B2+C2+D2+E2+F2+G2+F2+ E2+D2+C2+B2+A2+C2 +C8+D2+E2+F2+D6+G2+A2 +B2+ C2+D2+E2+F2+G2+ F2+F14+E2+D2+C2+B2+A2+C2+D2+ E2+F2+G2+A2+B2+C2+D2+E2+F2+G2+F2+E2+D2+C2+B2+A2+C2+D2+E2+F2+G2+A2+B2+C2+D2+E2+F2+G2+F2+E2+D2+C2+B2+A2+C2+D2+E2+F2+G2 Attach a file for further testing...
Created attachment 35434 [details] A simple spreadsheet with problems in the formula bar
Sorry, could not reproduce. Please describe step by step how to get this problems. Thanks Frank
Hi Frank, The step by step is given in my first post. It doesn't mattter if the formula is long or short, except on longer ones the first part (the part before the spot where you place the cursor to make the edit) seems to drop even lower, so all you can see is the tops of the characters. Just to confirm, I am running vs. 2.0.2 on a Win2k machine, and the problem occurs in every spreadsheet I open. I am beginning to wonder if I have a buggy instalation, since no one else seems to have this problem. I have uninstalled, and then reinstalled, but this didn't help. The only carryover from one to the other is my profile information. Would it be likely that something in my options would cause this? How about Windows settings? I have my screen fonts set to just slightly larger than normal to make it a little easier on the eyes on my 19" monitor. I am at a loss as to what to do next. Thanks for your help. Bob
I think I have found the problem, or at least part of it. I went to Windows Control Panel>Display>Appearance>Item>Selected Items where the font size is set to 12. If I lower the font size to 8 the problem goes away. However, this font size is too small, so the next question might be, "Is there a way to adjust window sizes in OOo to accomodate whatever font size is chosen for the system?" There seems to be some sort of incompatiblity between the font size and the windows provided by OOo. As soon as the font is set to 10 or larger, the problem comes back. If you are not seeing the problem, try going into Control Panel and setting the font size larger to see what happens. Bob
confirmed with m180 on WindowsXP and Linux (KDE) the problem is easy to reproduce, if you use (very) large System fonts. The formula bar displays the formulas correctly but if you enter the edit mode it will be moved down by some pixels. (You may use any formula, but need to change some characters of the formula). this does not happen with the formula bar in writer. set es to cc for accessability consideration
ES->andreschnabel: see following attachements. Is that what you mean? In this case, Writer and Calc show the same problem.
Created attachment 38540 [details] Calc
Created attachment 38541 [details] Writer
andreaschnabel->es: Yes, that's what I mean. So your screens show the same problem for writer and calc. But on my systems (Win XP , Linux / KDE OOo m180) only Calc has the problem. (Maybe it's better to not care about my system)
Hi Thomas, seems to be a problem with the Edit engine. So it's your construction site. Please have a look at this one. Frank
TL->PL: Please have a look. Thanks!
The object at hand ist SwInputWindow::DataChanged in sw/source/ui/ribbar/inputwin.cxx.
As for Calc it is in file sc\source\ui\app\inputwin.cxx
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Related to Issue 110475?
This issue started with vs 2.0.2 and is still present in vs 3.1 on Ubuntu Linux
fixed in CWS vcl113
please verify in CWS vcl113
Not fixed in Writer (see issue 113242) but fixed in Calc.
Verified