Bug 148127 - When selecting parts of a formula referencing cells ranges from another opened window of the same spreadsheet, highlights do not update until the other window is clicked / focused
Summary: When selecting parts of a formula referencing cells ranges from another opene...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Cell-Formula Cell-Reference New-Window-Same-File
  Show dependency treegraph
Reported: 2022-03-22 04:46 UTC by Jeff Fortin Tam
Modified: 2023-09-24 02:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Example file (7.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-01-02 11:32 UTC, Buovjaga

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff Fortin Tam 2022-03-22 04:46:04 UTC
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.
Comment 1 Buovjaga 2023-01-02 11:32:20 UTC
Created attachment 184441 [details]
Example file
Comment 2 Buovjaga 2023-01-02 11:36:44 UTC

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: (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
Comment 3 Kira Tubo 2023-09-24 01:45:34 UTC Comment hidden (obsolete)
Comment 4 Kira Tubo 2023-09-24 02:08:40 UTC
Reproduced on 3.3. Updating version from to Inherited from OOo