Bug 151682 - Calc: Editing area in Formula bar appears cropped
Summary: Calc: Editing area in Formula bar appears cropped
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.2.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Samuel Mehrbrodt (allotropia)
URL:
Whiteboard: target:7.6.0 target:7.5.1
Keywords: bibisectNotNeeded, regression
: 153492 (view as bug list)
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2022-10-21 11:56 UTC by Jordi Guilleumes
Modified: 2023-02-23 09:42 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of the problem in the Edition area (68.28 KB, image/png)
2022-10-21 11:58 UTC, Jordi Guilleumes
Details
Example file from 7.4.3 (8.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-08 13:02 UTC, Gabor Kelemen (allotropia)
Details
The issue in Calc with saved expanded status of the Formula bar (367.26 KB, image/png)
2022-12-08 13:08 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jordi Guilleumes 2022-10-21 11:56:19 UTC
Description:
In the Formula bar, the upper margin of the editioin area is higher than necessary, or the height of the formular bar is small. 
The effect is that the edition area is cropped on the bottom and the content of the cell is very difficult to read.
This seems to happen when using a non standard text scale on Windows configuration (in my case: 120% instead of the standard of 125%!)

Steps to Reproduce:
1.Open LibreOffice Calc
2.Insert any content on a cell
3.That's it

Actual Results:
Dsffly, I cannot provide a capture of the screen

Expected Results:
See the entire Edition area, as with standard text scale


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: ca
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Jordi Guilleumes 2022-10-21 11:58:27 UTC
Created attachment 183189 [details]
Screenshot of the problem in the Edition area
Comment 2 Eike Rathke 2022-10-21 12:09:16 UTC

*** This bug has been marked as a duplicate of bug 150664 ***
Comment 3 Gabor Kelemen (allotropia) 2022-12-08 13:02:37 UTC
Created attachment 184048 [details]
Example file from 7.4.3
Comment 4 Gabor Kelemen (allotropia) 2022-12-08 13:08:02 UTC
Created attachment 184049 [details]
The issue in Calc with saved expanded status of the Formula bar

So it is possible to break this with setting a desktop scaling of 125 or 150% and saving the file with the Formula bar expanded.
Upon reload the Formula bar is rendered a half line off.

Happens in 7.4.3 and current master

Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: c50cf1883af26daebdfc9d796ced3c20c222f43b
CPU threads: 14; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (hu_HU); UI: en-US
Calc: threaded

Let me unduplicate this, so that this case is handled separately from the catch-all bug.
Also this is not exactly the same as other duplicates complained about, and the original screenshot here shows the Formula bar collapsed - but anyways, simpler to repurpose this one :).
Comment 5 Commit Notification 2023-01-27 05:42:35 UTC
Samuel Mehrbrodt committed a patch related to this issue.
It has been pushed to "master":

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

tdf#151682 Fix gap above input bar

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Commit Notification 2023-02-03 02:06:35 UTC
Samuel Mehrbrodt committed a patch related to this issue.
It has been pushed to "libreoffice-7-5":

https://git.libreoffice.org/core/commit/9739a874b64e770728d62713b070f37de4ec8328

tdf#151682 Fix gap above input bar

It will be available in 7.5.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 7 ady 2023-02-13 13:02:00 UTC
*** Bug 153492 has been marked as a duplicate of this bug. ***