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
Status: ACCEPTED
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:
URL:
Keywords: oooqa
: 32247 79219 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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'

Peter
Comment 2 peter.junge 2003-12-29 11:13:01 UTC 
WFM
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 
accepting.
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'

Cheers
Andrew
Comment 11 Marcus 2017-05-20 11:13:14 UTC 
Reset assigne to the default "issues@openoffice.apache.org".