Bug 150664 - Formula bar in Calc is moved to down
Summary: Formula bar in Calc is moved to down
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.0 alpha1+
Hardware: All All
: high minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 150526 151025 151093 151221 (view as bug list)
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2022-08-29 10:26 UTC by Roman Kuznetsov
Modified: 2022-09-30 10:55 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:
Regression By: Samuel Mehrbrodt


Attachments
File example (4.59 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-08-29 10:27 UTC, Roman Kuznetsov
Details
A screenshot (10.55 KB, image/png)
2022-08-29 10:43 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2022-08-29 10:26:38 UTC
Description:
Formula bar in Calc is moved to down

Steps to Reproduce:
1. Open file from attach
2. Look at the Formula bar (see screenshot in attach)


Actual Results:
Formula bar in Calc is moved to down

Expected Results:
Formula bar is on its standard place in UI


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: f3b5cb5a17a451c9e7d9b47b5e8854c5e126801f
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

But no repro in 7.3 => regression
Comment 1 Roman Kuznetsov 2022-08-29 10:27:01 UTC
Created attachment 182069 [details]
File example
Comment 2 Roman Kuznetsov 2022-08-29 10:43:36 UTC
Created attachment 182070 [details]
A screenshot
Comment 3 stragu 2022-08-29 16:38:39 UTC
Confirmed in:

Version: 7.4.0.3 / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and:

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 24087697d5cf78aac346d4dcea0596373e15a95c
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Typing something in a cell or clicking inside the formula field makes it go back to its normal position.
Comment 4 Roman Kuznetsov 2022-08-29 18:44:54 UTC
I bisected this one in win64-7.4 bisect repo and got

SHA d0cacf09a1105d89bf3df84b18623d790e3aeb82

https://gerrit.libreoffice.org/c/core/+/133499

https://git.libreoffice.org/core/commit/d0cacf09a1105d89bf3df84b18623d790e3aeb82

Added to CC: Samuel Mehrbrodt

Samuel, please look at it. Thanks
Comment 5 Ming Hua 2022-09-17 11:35:33 UTC
*** Bug 151025 has been marked as a duplicate of this bug. ***
Comment 6 افشین 2022-09-17 12:26:13 UTC
There is this bug in 7.4.1 too.
Comment 7 Eike Rathke 2022-09-17 16:55:35 UTC
From bug 99708 comment 8:
When loading a document the (one line) Input Line (aka Formula Bar) height appears too small by a few pixels, but in fact is shifted down by that amount and cut at the bottom, until clicked into then it gets positioned and as tall as it should.
Same for F2 edit cell.
Comment 8 r435g391b823-comp176456@yahoo.com.au 2022-09-18 04:34:03 UTC
Hi, I have this bug in latest release 7.4.1 too, as seen in Roman's screenshot, however unlike Eike in comment 7, nothing I do makes the input line change position back into alignment or become its proper single-line height. Entering formula in cells, clicking on the formula input line and typing, or using the mouse-drag option [found by hovering the mouse between the formula bar and cell column headers]. The input line is either obscured or 2+line height and still out of vertical alignment.

The Formula Bar Input Line textbox remains a few pixels lower than it should be, making it largely unreadable unless you increase the formula bar height. This's a really weird thing to break in a new release.. good luck, and thanks in advance for fixing this you fantastic Dev People.
Comment 9 Mike Kaganski 2022-09-21 05:28:11 UTC
*** Bug 151093 has been marked as a duplicate of this bug. ***
Comment 10 Timur 2022-09-29 07:59:18 UTC
*** Bug 151221 has been marked as a duplicate of this bug. ***
Comment 11 Timur 2022-09-29 08:25:29 UTC
*** Bug 150526 has been marked as a duplicate of this bug. ***