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.). In other words: 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. 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 %
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]", see attached sample document! 1 Problem is that colors will not be shown in document, second problem is that non colored cell references in formula will not show colored frame around the referenced cells.
Created attachment 51755 [details] Sample Document, see Comment 1 @Kohei: Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
"Bug 41915 - named cells not highlighted when editing formulae" seems to show an additional aspect of the problem
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
The same issues could be detected in LOdev 3.5.0 beta2.
*** Bug 47094 has been marked as a duplicate of this bug. ***
Changing Version & Plattform fields based on Bug 47094
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.