https://bugs.freedesktop.org/show_bug.cgi?id=64519
Priority: medium
Bug ID: 64519
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Conditional Formatting dialog does not
allow entering named ranges
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: libreoffice....@andre.colomb.de
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79229
--> https://bugs.freedesktop.org/attachment.cgi?id=79229&action=edit
Screenshot of the conditional formatting dialog not accepting a named range
reference,
Problem description:
When working with conditional formatting, the rules are automatically adjusted
when, for example, additional cells are inserted in an affected range. The user
ends up with several rules for copied cells or altered rules for ranges which
don't include the newly inserted cells.
It would be great if the user were able to use named ranges for conditional
formatting. These rules would not have to be automatically adjusted for changed
cell ranges, but just always refer to the same named range.
However, in the editing dialog for conditional formatting rules, the input
entry for "Range" only accepts cell references, not references to named ranges.
If entering the name of a named range, its background turns red and the
formatting rule is not accepted.
Steps to reproduce:
1. Select some cells in an empty Calc document (e.g. A1:B9)
2. Create a named range by entering 'testrange' into the Name Box.
3. Choose Format - Conditional Formatting - Condition
4. The "Range:" field displays the selected cell range as A1:B9
5. Enter the defined name "testrange" into the field.
Current behavior:
The background of the "Range:" field turns red and the conditional formatting
rule cannot be created.
Expected behavior:
The conditional formatting rule is created for the named range and affects all
cells that are part of the named range. Subsequent changes to the named range
definition do not alter the conditional formatting rule, which constantly
refers to the range name.
Operating System: Windows 7
Version: 4.0.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
