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
Created attachment 182069 [details] File example
Created attachment 182070 [details] A screenshot
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.
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
*** Bug 151025 has been marked as a duplicate of this bug. ***
There is this bug in 7.4.1 too.
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.
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.
*** Bug 151093 has been marked as a duplicate of this bug. ***
*** Bug 151221 has been marked as a duplicate of this bug. ***
*** Bug 150526 has been marked as a duplicate of this bug. ***
Confirming this bug. I am using Arch Linux and have seen this in all the 7.4 versions of libreoffice-fresh that I have tried, including the one current at the time of writing (7.4.1-3).
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/580115275da91e8a591ecc94e6bf4b62f801cf60 tdf#150664 Initialize input line correctly It will be available in 7.5.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.
Thank you very much for working on this. Is there a chance that this could be backported to 7.4? I don’t know how to find this our myself, sadly. Would be inconvenient to have to skip 7.4 entirely, but this is a big annoyance (so far I have always tested the libreoffice-fresh package and found it so annoying that I went straight back to libreoffice-still).
Also I would be happy to test but don’t know how to install a daily build on Arch Linux. I have done some basic searching and checked the Arch Wiki article on LibreOffice. The download link above only has .deb and .rpm files and I don’t have the capacity to build from sources.
(In reply to sebalis from comment #14) > Thank you very much for working on this. Is there a chance that this could > be backported to 7.4? I don’t know how to find this our myself, sadly. Would > be inconvenient to have to skip 7.4 entirely, but this is a big annoyance > (so far I have always tested the libreoffice-fresh package and found it so > annoying that I went straight back to libreoffice-still). It should be fixed in the 7.4 branch too, hopefully in release 7.4.3: https://gerrit.libreoffice.org/c/core/+/141193 (assuming that no other commits are needed; I haven't tested the fix just yet)
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/36c1be166c991611e4f164e7b7d82f8c81c8ebce tdf#150664 Initialize input line correctly It will be available in 7.4.3. 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.
*** Bug 151559 has been marked as a duplicate of this bug. ***
Related questions: https://ask.libreoffice.org/t/decalage-de-la-ligne-de-saisie/82900 Version: 7.4.1.2 (x64) / LibreOffice Community Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: fr-CH (fr_CH); UI: fr-FR Calc: CL https://ask.libreoffice.org/t/barra-formula-su-calc-troppo-stretta-e-spostata/82966 7.4.1.2 su windows 11
Verified in Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 4d9b83a417bbde8148b67d2ab0abe9f4ae285276 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded Thanks for fixing, Samuel!
*** Bug 151682 has been marked as a duplicate of this bug. ***
*** Bug 151787 has been marked as a duplicate of this bug. ***
(In reply to Commit Notification from comment #17) > Samuel Mehrbrodt committed a patch related to this issue. > It has been pushed to "libreoffice-7-4": > > https://git.libreoffice.org/core/commit/ > 36c1be166c991611e4f164e7b7d82f8c81c8ebce > > tdf#150664 Initialize input line correctly > > It will be available in 7.4.3. > > 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. The bug also exists in: Version: 7.4.4.0.0+ (x64) / LibreOffice Community Build ID: 2e9122f79b2573647a77bdfb2216934a5abda778 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: CL
(In reply to Commit Notification from comment #13) > Samuel Mehrbrodt committed a patch related to this issue. > It has been pushed to "master": > > https://git.libreoffice.org/core/commit/ > 580115275da91e8a591ecc94e6bf4b62f801cf60 > > tdf#150664 Initialize input line correctly > > It will be available in 7.5.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. The bug also existed in: Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3c0be5564afe1b9cc843a49aba88b72af74c43ab CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: zh-CN (zh_CN); UI: en-US Calc: CL threaded please see the screenshot.
Created attachment 183550 [details] screen shot for 7.5.0 The screen shot confirmed the bug also existed in 7.5.0.
(In reply to Jinsong Zhao from comment #25) > Created attachment 183550 [details] > screen shot for 7.5.0 > > The screen shot confirmed the bug also existed in 7.5.0. Do you also see it in safe mode? Help - Restart in safe mode and then Continue in safe mode.
(In reply to Buovjaga from comment #26) > (In reply to Jinsong Zhao from comment #25) > > Created attachment 183550 [details] > > screen shot for 7.5.0 > > > > The screen shot confirmed the bug also existed in 7.5.0. > > Do you also see it in safe mode? Help - Restart in safe mode and then > Continue in safe mode. No. I don't know if there is a safe mode. Now I run it again in safe mode. The bug also exists. I run both the 7.4.4 and 7.5.0. They are the same. Version: 7.4.4.0.0+ (x64) / LibreOffice Community Build ID: 2e9122f79b2573647a77bdfb2216934a5abda778 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: threaded Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3c0be5564afe1b9cc843a49aba88b72af74c43ab CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: threaded
(In reply to Jinsong Zhao from comment #25) > Created attachment 183550 [details] > screen shot for 7.5.0 The screen shot shows that some UI scaling is used (we better have this information in Help|About). Which factor is that? Also it would be good to know how exactly you repro it - exact steps, (one such simplest scenario, even if you believe that it happens in other scenarios, maybe even always). A screencast would be great. It is something specific, because I *can't* repro using Version: 7.4.3.1 (x64) / LibreOffice Community Build ID: 3793858a34d8fef5b92f8fee233f97766f05e281 CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL and also using Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 55cd20e6228a06836285c14ca6726adb1bb4ffcb CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (ru_RU); UI: en-US Calc: CL threaded with UI Scaling 100% and 150%.
(In reply to Mike Kaganski from comment #28) > (In reply to Jinsong Zhao from comment #25) > > Created attachment 183550 [details] > > screen shot for 7.5.0 > > The screen shot shows that some UI scaling is used (we better have this > information in Help|About). Which factor is that? > > Also it would be good to know how exactly you repro it - exact steps, (one > such simplest scenario, even if you believe that it happens in other > scenarios, maybe even always). A screencast would be great. It is something > specific, because I *can't* repro using Version: 7.4.3.1 (x64) / LibreOffice > Community > Build ID: 3793858a34d8fef5b92f8fee233f97766f05e281 > CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: > win > Locale: ru-RU (ru_RU); UI: en-US > Calc: CL > > and also using Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community > Build ID: 55cd20e6228a06836285c14ca6726adb1bb4ffcb > CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: > win > Locale: en-US (ru_RU); UI: en-US > Calc: CL threaded > > with UI Scaling 100% and 150%. Got it. The UI scaling factor is 125% for the screenshot. When I set the UI scaling to 100% and 150%, and then start Calc, the bug disappears. However, scaling 125% is the recommended factor for my laptop.
I have the same issue with 7.4.3.2. I thought in order to clear up any issues with respect to corrupt profiles etc, I downloaded the portable version of libreoffice 7.4.3.2 The same issue happened in that version too. Having looked through the release notes of Libreoffice, the only change I can see relates to the height of the formula bar: https://wiki.documentfoundation.org/ReleaseNotes/7.4#Calc The height of the formula bar is now stored into the document. tdf#99708 (Samuel Mehrbrodt, allotropia) Nothing else to add. Locale: en-GB Module: SpreadsheetDocument OS: Windows 10 Pro X64 Nvidia 3060 Ti
Given the last couple of comments, Eg WeaselThatBites' comment, is this actually fixed yet[asking to save the DL again]. And RE Jinsong Zhao's comment, my windows scaling hasn't changed, is at 100%, and I got the bugged formula bar. Thanks everyone, Jb
Samuel will comment on it in time
*** Bug 152249 has been marked as a duplicate of this bug. ***
Can't see the issue anymore with Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded Also with recent daily build attachment 182069 [details] loads fine. Please provide additional info how to reproduce the info.
(In reply to Samuel Mehrbrodt (allotropia) from comment #34) > Can't see the issue anymore with > > Version: 7.4.3.2 (x64) / LibreOffice Community > Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 > CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: > win > Locale: de-DE (de_DE); UI: de-DE > Calc: threaded > > Also with recent daily build attachment 182069 [details] loads fine. > > Please provide additional info how to reproduce the info. I have tested 7.4.3.2. At a UI scaling factor of 125%, the issue exists. At 100% and 150%, all is ok. Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: CL
Needinfo is dangerous here, so let us not use it
(In reply to Jinsong Zhao from comment #35) > I have tested 7.4.3.2. At a UI scaling factor of 125%, the issue exists. At > 100% and 150%, all is ok. > > Version: 7.4.3.2 (x64) / LibreOffice Community > Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 > CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: > win > Locale: zh-CN (zh_CN); UI: zh-CN > Calc: CL Can you disable Skia and try again? I couldn't reproduce, even after setting scaling to 125%.
(In reply to Samuel Mehrbrodt (allotropia) from comment #37) > (In reply to Jinsong Zhao from comment #35) > > I have tested 7.4.3.2. At a UI scaling factor of 125%, the issue exists. At > > 100% and 150%, all is ok. > > > > Version: 7.4.3.2 (x64) / LibreOffice Community > > Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 > > CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: > > win > > Locale: zh-CN (zh_CN); UI: zh-CN > > Calc: CL > > Can you disable Skia and try again? > I couldn't reproduce, even after setting scaling to 125%. If you look at comment 27, Jinsong tried in Safe mode, which deactivated Skia
(In reply to Samuel Mehrbrodt (allotropia) from comment #37) > (In reply to Jinsong Zhao from comment #35) > > I have tested 7.4.3.2. At a UI scaling factor of 125%, the issue exists. At > > 100% and 150%, all is ok. > > > > Version: 7.4.3.2 (x64) / LibreOffice Community > > Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 > > CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: > > win > > Locale: zh-CN (zh_CN); UI: zh-CN > > Calc: CL > > Can you disable Skia and try again? > I couldn't reproduce, even after setting scaling to 125%. The same at a scaling of 125%. Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: CL
(In reply to Buovjaga from comment #38) > (In reply to Samuel Mehrbrodt (allotropia) from comment #37) > > (In reply to Jinsong Zhao from comment #35) > > > I have tested 7.4.3.2. At a UI scaling factor of 125%, the issue exists. At > > > 100% and 150%, all is ok. > > > > > > Version: 7.4.3.2 (x64) / LibreOffice Community > > > Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 > > > CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: > > > win > > > Locale: zh-CN (zh_CN); UI: zh-CN > > > Calc: CL > > > > Can you disable Skia and try again? > > I couldn't reproduce, even after setting scaling to 125%. > > If you look at comment 27, Jinsong tried in Safe mode, which deactivated Skia I try again in Safe mode, it's the same at a scaling of 125%. Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: threaded
Can anyone else reproduce this? Otherwise I suggest we close this issue and open a new bug for the problem which still exists in some corner case.
(In reply to Samuel Mehrbrodt (allotropia) from comment #41) > Can anyone else reproduce this? > Otherwise I suggest we close this issue and open a new bug for the problem > which still exists in some corner case. weaselthatbites could also repro. weaselthatbites: do you have 125% display scaling?
https://bugs.documentfoundation.org/show_bug.cgi?id=152249 also report this with a UI scaling factor of 125%.
I have 150% scaling. A 50 inch tv. I run resolution at 1920*1080 and then use Windows 10 scaling up to 150%. Before anyone asks the idea of a big screen for me personally, is to watch videos in big size, rather than having my text in super small size (such as running it in 4k). I don't know if the size of the screen makes a difference. Any ideas on how to troubleshoot it, so I can help narrow down what the issue is? I tried process Monitor but could not see anything wrong particularly. I tried switching Skia on and off without any effect. Same thing with anti-aliasing. Is there anything else I could try?
(In reply to weaselthatbites from comment #44) > I have 150% scaling. A 50 inch tv. I run resolution at 1920*1080 and then > use Windows 10 scaling up to 150%. > > Before anyone asks the idea of a big screen for me personally, is to watch > videos in big size, rather than having my text in super small size (such as > running it in 4k). > > I don't know if the size of the screen makes a difference. Any ideas on how > to troubleshoot it, so I can help narrow down what the issue is? Change the scaling temporarily to 100% and test LibreOffice.
I changed it to 100% and the bar looked fine. I then tried 125% and that worked too. It is only 150% that seems to be messed up. I then used the text size adjuster to go 200 and leave it at 125%. This seems to have worked. The bar is no longer problematic for me. Text size is still a bit small, but I can live with this as a work around.
Still an issue. Windows Scaling is default/unchanged 100% on my win10 x64 laptop. Just tried the latest version again, so uninstalled 7.3.6 which is fine and installed newly downloaded 7.4.3.2. So all default ui settings, and no other changes. Just uninstalling 7.3.6, then installing 7.4.3.2. Formula bar too large/offset down a bit under rest of calc components. Screenshots attached shortly.
Created attachment 183870 [details] formula bar still offset under other components
Created attachment 183871 [details] formula bar still an issue in latest 7.4.3.2 x64 version screenshot
Created attachment 183872 [details] formula bar still an issue in latest 7.4.3.2 x64 win10 scaling 100% screenshot of windows scaling showing is default values, 100%, and was not changed at all between uninstalling 7.3.6 and installing 7.4.3.2.
Please let me know if i can get any additional info for you to help diagnose and resolve this issue. Also It happens with new blank sheets and opening an existing sheet made in 7.3.6. Very best luck to you all, Johnb
(In reply to r435g391b823-comp176456@yahoo.com.au from comment #50) > Created attachment 183872 [details] > > screenshot of windows scaling showing is default values, 100%, and was not > changed at all between uninstalling 7.3.6 and installing 7.4.3.2. The screenshots clearly show that at least font of menus is not the default ... maybe some other customizations are at play here?
Created attachment 183873 [details] weird dark coloured menu briefly Also, after installing 7.4.3.2 and restarting the laptop, i opened libreoffice calc from the taskbar type here to search box, and in the new blank sheet, the menus were all weirdly dark coloured. I looked at settings - personalisation - themes. It was set to default. I changed it to white theme, the dark menu colour lasted until i closed libreoffice and reopened. Just letting you all know in case it's related somehow/important.
(In reply to Mike Kaganski from comment #52) > (In reply to r435g391b823-comp176456@yahoo.com.au from comment #50) > > Created attachment 183872 [details] > > > > screenshot of windows scaling showing is default values, 100%, and was not > > changed at all between uninstalling 7.3.6 and installing 7.4.3.2. > > The screenshots clearly show that at least font of menus is not the default > ... maybe some other customizations are at play here? Hi Mike, ah yeah i forgot about that, sorry, i used reg entry scripts to increase menu text size. I use Directory Opus, but it has it's own settings for other text colours, fonts, sizes. But windows ui scaling is default 100%, and Libeoffice 7.3.6 works fine with no ui issues. Thoughts?
*** Bug 152427 has been marked as a duplicate of this bug. ***
On Fedora Linux 37, LO 7.4.3.2, with libreoffice-kf5, I had the same issue of lower part of text cut down in Calc formula bar. Then I tried to play with SAL_FORCEDPI: going down from SAL_FORCEDPI=96, the formula bar got suddenly fixed and nice at SAL_FORCEDPI=92. From this it looks like that Calc takes some dpi value, makes some arithmetic with it, then draws its interface, and some dpi's give a bad result somewhere,
I can confirm this Bug with Windows 10 and an activ custom scaling (116 %). This bug exist at last since libreoffice 7.4, i'm currently on 7.5.0 beta1. A bad workaround is to deactivate scaling (set it to 100%). Maybe this information is going to help to fix this bug.
Created attachment 184364 [details] Windows registry tweak to set menu font to Segoe UI 24, Bold (In reply to r435g391b823-comp176456@yahoo.com.au from comment #54) > i used reg entry scripts to increase menu text size. ... > But windows ui scaling is default 100% Steps to repro using menu size tweak on Windows: 0. Backup your WindowMetrics in registry: open regedit, navigate to HKEY_CURRENT_USER\Control Panel\Desktop\WindowMetrics, and save selected branch using File->Export. 1. Download a REG file from https://www.tenforums.com/tutorials/70839-change-menus-text-size-windows-10-a.html, which makes menu font size reasonably large (or use the attachment here, making it unreasonably large). Check its content (it's a plain text file). 2. Apply it (confirming the UAC). 3. Log off from system and log on (or restart Windows). 4. Open Calc. 5. After seeing the problem, restore using the backup saved in step #0.
Additional consideration for 'repro using menu size tweak on windows' is doing it with Libreoffice 7.4.onwards, and doing it with Libreoffice 7.3.6 (or thereabouts as I'm not sure which version this issue started in). As on my system, I keep going back to 7.3.6 because it doesn't have the bug, but any of the 7.4.x versions I've tried have the bug. No other system changes, and the menu size tweak still in effect for both 7.3.6 and 7.4.x. So it looks like something happened in one of the versions after 7.3.6 that messes the formula bar scaling up and has stayed in subsequent versions... Very best luck in fixing this. Merry Xmas & New Years' cheeries all, Jb
(In reply to r435g391b823-comp176456@yahoo.com.au from comment #59) > 'repro using menu size tweak on windows' is ... 7.4.onwards, ... > I keep going back to 7.3.6 because it doesn't have the bug It was, commit d0cacf09a1105d89bf3df84b18623d790e3aeb82, which was identified in comment 4 already, so indeed the same issue. The *unrelated* question here, though, is why do we use the *menu* font height to calculate heights of formula bar (its input box), as well as for combo boxes (affecting the font controls on the toolbars), and Calc's grid headers. Generally, it seems, we misuse this height in a lot of places throughout the UI. Compare with e.g. Firefox or Chrome, which of course use it in menus, but not in other UI elements. OTOH, MS Word seems to use it everywhere, including the size of their toolbar/ribbon icons, so maybe we are somewhere in between - but inconsistent in any case.
*** Bug 153132 has been marked as a duplicate of this bug. ***
Please test if this is fixed now after the fix in bug 151682.
(In reply to Samuel Mehrbrodt (allotropia) from comment #63) > Please test if this is fixed now after the fix in bug 151682. Please everybody test it https://dev-builds.libreoffice.org/daily/master/current.html
(In reply to Samuel Mehrbrodt (allotropia) from comment #63) > Please test if this is fixed now after the fix in bug 151682. I have tested the latest Calc, I do not observe the bug again. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ec4babad021218b75dfe8534985d7db525edde69 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: CL threaded P.S.: I am at the UI scaling of 125%.
Hi, so Jinsong Zhao kindly confirmed this's fixed in the 7.6.0.0 alpha, any ideas which [hopefully earlier] release will include this fix please, could it be in 7.5.1 which freezes February 6th-12th?? Using https://wiki.documentfoundation.org/ReleasePlan for that info. Many thanks for fixing this, Jb
Or 7.3 EoL should be extended until a newer version for productive use is available where Calc is usable again.
I received an information of 7.6.0.0 alpha when I was testing Ver 7.4.5.1. 7.4.5.1. still has the same trouble with bug 150664. Now, 7.6.0.0 alpha is not available in my computer. I don't know why. Anyway, I expect that new release will be a good present for users.
(In reply to peach from comment #68) > I received an information of 7.6.0.0 alpha when I was testing Ver 7.4.5.1. > > 7.4.5.1. still has the same trouble with bug 150664. > > Now, 7.6.0.0 alpha is not available in my computer. > I don't know why. > > Anyway, I expect that new release will be a good present for users. You can get 7.6 from https://dev-builds.libreoffice.org/daily/master/current.html Just don't use it for normal work.
This bug still exists in version 7.5! Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: 50(Build:3) CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fa-IR (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.5.0~rc3-0ubuntu0.22.04.1~lo1 Calc: threaded
Created attachment 185168 [details] Calc Input Line in Formula Bar is moved down and cropped Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: 50(Build:3) CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fa-IR (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.5.0~rc3-0ubuntu0.22.04.1~lo1 Calc: threaded
(In reply to افشین from comment #70) > This bug still exists in version 7.5! > > Version: 7.5.0.3 (X86_64) / LibreOffice Community > Build ID: 50(Build:3) > CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3 > Locale: fa-IR (en_US.UTF-8); UI: en-US > Ubuntu package version: 1:7.5.0~rc3-0ubuntu0.22.04.1~lo1 > Calc: threaded You tested with the wrong version. You should have tested with 7.6 as requested. The fix for bug 151682 is also in 7.5.1.
The bug still exists in version 7.4.6.2 I'm deeply disappointed.
(In reply to peach from comment #73) > The bug still exists in version 7.4.6.2 > > I'm deeply disappointed. I'm somewhat putoff too mate. A formatting feature that'd make my life immensely easier was added recentlyish, very kindly by the devs, but to a version that has and since has this formula bar bug, that's stopped me updating to a version with the added feature .. anyhoo.. very best wishes to the devs fixing this, i know it's a labour of love! Also how is this bug listed as fixed when people are still notifying with the issue/bug happening? Cheeries all,j
Cleaned up for see also bug 154042 -- notated with target:7.6.0 target:7.5.2 target:7.4.7 So you'll have it at 7.4.7, or upgrade to 7.5.2