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