To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116978
Issue #|116978
Summary|edit mode: cell included in formula but not color code
|d
Component|Spreadsheet
Version|OOO330m20
Platform|PC
URL|
OS/Version|Windows 7
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|stallersattel
------- Additional comments from stallersat...@openoffice.org Wed Feb 16
00:44:03 +0000 2011 -------
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 %
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
