Issue 23893 - Formula highlighting doesn't work when sheet name contains a blank
Summary: Formula highlighting doesn't work when sheet name contains a blank
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 32247 79219 (view as issue list)
Depends on:
Reported: 2003-12-26 17:44 UTC by taverngeek
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

shows failure to highlight sheet 'test 1':a4 (5.47 KB, application/vnd.sun.xml.calc)
2003-12-29 19:02 UTC, taverngeek
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description taverngeek 2003-12-26 17:44:38 UTC
Double clicking on a cell with a formula that references other cells causes the
other cells to be outlined in either red or blue.  But this only works for cells
on the same sheet as the formula.

It should highlight the cells on any sheet within the spreadsheet.

I note that it will currently highlight cells on the current sheet that are out
of view and require scrolling the sheet to see the highlighted cell and that the
cells in another sheet are not currently highlighted even if they are in view
due to being opened in another window.
Comment 1 peter.junge 2003-12-29 11:12:41 UTC
Hi taverngeek,
works for me at least on a Solaris8/CDE exactly as you requested. Also in
another window.
Please check tools->options->spreadsheet->view->display->'show reference in color'

Comment 2 peter.junge 2003-12-29 11:13:01 UTC
Comment 3 taverngeek 2003-12-29 19:02:50 UTC
Created attachment 12173 [details]
shows failure to highlight sheet 'test 1':a4
Comment 4 taverngeek 2003-12-29 19:04:14 UTC
Upon further investigation on why it doesn't work for me in my spreadsheet I
discovered that highlighting doesn't work if the referenced sheet has a
space in the sheet's name.

If you open my attached spreadsheet then clicking on sheet1:a3 will light
up sheet2:a4, but clicking on sheet1:b4 will not light up 'test 1':a4
Comment 5 peter.junge 2003-12-30 06:50:18 UTC
Yes, reproduceble when the sheetname contains a blank.
Comment 6 niklas.nebel 2004-02-02 11:12:21 UTC
Comment 7 ooo 2004-10-12 11:04:24 UTC
*** Issue 32247 has been marked as a duplicate of this issue. ***
Comment 8 ooo 2007-07-09 11:36:26 UTC
*** Issue 79219 has been marked as a duplicate of this issue. ***
Comment 9 huw 2007-11-14 16:09:09 UTC
Also, the highlighting of the actual formula (coloured to match its cell 
highlighting) only works on the part of the sheet name after the last space in 
it. Same for range names etc.
Comment 10 ace_dent 2009-07-03 13:12:37 UTC
Related issues:
Issue 1339 - 'Named cells are not color-coded (highlighted) in cell-edit mode'
Issue 23893 - 'Formula highlighting doesn't work when sheet name contains a blank'

Comment 11 Marcus 2017-05-20 11:13:14 UTC
Reset assigne to the default "".