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]
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: 18.104.22.168.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 22.214.171.124 to Inherited from OOo