https://bugs.freedesktop.org/show_bug.cgi?id=41304
Summary: Editing formula
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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 %
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
