When you open a formula that is centered in a cell and it extends beyond the column width, it is not possible to click the formula text to the left of the cell. It is however possible to click the text to the right of the cell. Steps to reproduce: 0) Create a blank Calc document 1) Enter a long formula text on a cell, f.i. =SUMPRODUCT(C10:C16;D10:D16)-SUMPRODUCT(F11:F15;G11:G15) 2) Do not change its alignment for now... simply double-click the cell and notice that the formula text will align to the left edge of the column where it is located, and all formula text is clickable (this is OK). 3) Now click outside the cell to stop editing the formula. Use the toolbar to center the cell contents 4) Double-click the cell. The formula text will be centered and the formula text that goes beyond the left column edge is not clickable (Not OK). The formula text to the right is clickable as expected. From my testing, it happens in gtk3, kf5 and gen. System info Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:7.5.2~rc2-0ubuntu0.22.10.1~lo1 Calc: threaded
Created attachment 186790 [details] Example file
Repro already with 5.2 and 3.5. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: cfa463cc5446e72a06db5a457bf4d50d4173f31e CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 19 April 2023 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 61b41646c5a93ca24f2c9f143cdb0da2c9258989 CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded