Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Formula highlighting doesn't work when sheet name contains a blank | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | taverngeek <taverngeek> | ||||
Component: | ui | Assignee: | AOO issues mailing list <issues> | ||||
Status: | ACCEPTED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | gte.ejecutivo, hgtoo, issues | ||||
Version: | OOo 1.1 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
taverngeek
2003-12-26 17:44:38 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 WFM Created attachment 12173 [details]
shows failure to highlight sheet 'test 1':a4
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 Yes, reproduceble when the sheetname contains a blank. accepting. *** Issue 32247 has been marked as a duplicate of this issue. *** *** Issue 79219 has been marked as a duplicate of this issue. *** 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. 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 Reset assigne to the default "issues@openoffice.apache.org". |