1. Open a spreadsheet where a formular references a column in some other sheet of the spreadsheet document 2. Open a new window of that same document (wit hthe "View > New window" action) and focus that other sheet, put that window on your secondary screen or tiled 3. Select/edit the formula in the formula bar, and select the portion that references some cells range Result: until you click the other window where the cell range is referenced, the colored/syntax highlight around that range is not updated (whether in terms of position or being displayed). If you go back to the 1st window, select a different part of the formula referencing another range shown by the 2nd window, the colored highlight will still be around the first range you selected, and won't update to the 2nd range until you click the second window.
Created attachment 184441 [details] Example file
Reproduced. When dealing with a ref in the same sheet and only one window, it shows the highlight upon entering edit mode, but I don't know how to display it after doing something. Arch Linux 64-bit, X11 Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: cbf30153a5c776e6d1ee26f2f83c8f77503eceb9 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Jumbo Built on 2 January 2023
*** Bug 113902 has been marked as a duplicate of this bug. ***
Reproduced on 3.3. Updating version from 7.2.5.2 to Inherited from OOo