https://bugs.freedesktop.org/show_bug.cgi?id=58507
Priority: medium
Bug ID: 58507
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Conditional formatting rules only appear
for selected cells if the range selected fully matches
the range which the rule applies to
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: john.pr...@cantab.net
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.0.0.beta1
Component: Spreadsheet
Product: LibreOffice
Created attachment 71793
--> https://bugs.freedesktop.org/attachment.cgi?id=71793&action=edit
Screenshots from 4.0 beta 1 to explain the confusion
Problem description: when selecting a cell and then selecting CF -> condition
the rule only appears if the entire range that the conditional formatting rule
applies to is selected (otherwise it may lead the user to believe that there
are no conditional formatting rules applied to the selected cell)
Steps to reproduce:
1. open the example from bug 58484, attachment 71764 [details]
2. select cell AN7
3. select: format -> conditional formatting -> condition
Simpler steps to reproduce:
A. create a spreadsheet with a conditional formatting rule applied to A1:A2
B. select cell A1
C. select: format -> conditional formatting -> condition
Current behavior: the list is empty
Expected behavior: the list makes it clear by some means that there is a rule
which applies to the selected cell, but that the range is different (e.g.
yellow triangle at the top and "this cell has conditional formatting applied as
part of a range to other cells click here to view all conditional formatting
rules" - the link would open the 'Manage...' dialogue.
Workaround (for steps 1-3): select the exact range
(T7:W46,Z7:Z46,AD7:AG46,AJ7:AJ46,AN7:AQ46,AT7:AT46) as listed under CF ->
Manage, then select CF -> Condition and the rule is listed (presumably as the
range at the bottom of the dialogue box now matches)
Alternative Workaround: always use CF -> Manage to deal with cells which may
already contain conditional formatting to avoid getting confused
Operating System: Windows XP
Version: 4.0.0.0.beta1
--
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
