Issue 116978 - edit mode: cell included in formula but not color coded
Summary: edit mode: cell included in formula but not color coded
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOO330m20
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-16 00:44 UTC by stallersattel
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
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 stallersattel 2011-02-16 00:44:03 UTC 
Action: Double click on a cell containing a formula. 
Result: The formula will reappear and each cell included in the formula will be 
        color coded.
                                                                                
Unfortunately this does not apply to cells
(1) which reside within a sheet whose sheet name contains space and/or dash 
    (e.g.).

    Workaround: eliminate any spaces and dashes in sheet names of affected 
                sheets
     
(2) which are referenced in a formula followed by "%", e.g. cell C1 contains 
    =B1/A1%.
    For clarification: cell A1 will not be colour coded when C1 is double
    clicked whereas B1 will be color coded.

    Workaround: add a space between cell reference and %: =B1/A1 %
Comment 1 Marcus 2011-02-16 08:18:31 UTC 
I can reproduce the second problem but not the first (OOO330m20 on Solaris Sparc)
Comment 2 Marcus 2011-02-16 08:19:43 UTC 
.
Comment 3 stallersattel 2011-02-16 10:23:51 UTC 
As for the first problem - to be more precise:

The problem appears if a cell reference in the formula is prefixed 
with a sheet name which contains space and/or dash. Any cell referenced 
this way will not be color coded.
Comment 4 oc 2011-02-17 12:48:07 UTC 
Hi Niklas, please have a look
Comment 5 Marcus 2017-05-20 11:11:18 UTC 
Reset assigne to the default "issues@openoffice.apache.org".