If I need to change the order of conditions in conditional formatting i have to rewrite many of them
Steps to reproduce:
1. create two or more conditions in conditional formatting, save
2. try to change their order
not possible (to my knowlege)
Expected (wished) behavior:
drag'n'drop or up/down arrows icon should change the order of conditions
Operating System: Windows 7
Version: 184.108.40.206 release
A very useful option.
*** Bug 74082 has been marked as a duplicate of this bug. ***
(In reply to comment #0)
> Problem description:
> If I need to change the order of conditions in conditional formatting i have
> to rewrite many of them
> Steps to reproduce:
> 1. create two or more conditions in conditional formatting, save
> 2. try to change their order
> 3. ....
> Current behavior:
> not possible (to my knowlege)
> Expected (wished) behavior:
> drag'n'drop or up/down arrows icon should change the order of conditions
> Operating System: Windows 7
> Version: 220.127.116.11 release
a very useful request.
Current workaround (very extensive):
- Adding a new empty condition with EXTRA-button.
- Copying previous conditions one by one to new position.
- Editing the condition to be inserted.
OS: Linux Ubuntu 14.04 i386/32bit
LO-Version: 18.104.22.168 release
This improved Conditional Formatting seems very important to me.
The order of priority different conditions is fixed for the moment.
Having the ability to add a condition to any place or be able to move around its conditions would allow users to work faster and smarter.
Of French to English translation with Google
*** Bug 90060 has been marked as a duplicate of this bug. ***
> Current workaround (very extensive):
> - Adding a new empty condition with EXTRA-button.
> - Copying previous conditions one by one to new position.
> - Editing the condition to be inserted.
This not work correctly, sometimes newly added conditions adds not to end of old conditions, but in middle :(
So I vote for adding interface for re-order condition in libreoffice caclc conditional formatting interface
And example with easy demonstrating the problem from Bug 90060:
If first rule "greater than 5" apply Style "Red color", and second rule "greater than 10" on same cell apply Style "Green color" - all cells less than 10 and less than 5 will have Green color. This can be solved via change rule order, but there are no good way to change it.
*** Bug 90784 has been marked as a duplicate of this bug. ***
Deeply sorry for it but without the possibility to prioritize conditional formatting this feature is almost useless. IMHO, if we want to draw people away from Excel this should be fixed asap. In my case, even with a strong inclination to use Calc whenever possible and even when it sometimes is not as user friendly as Excel, this is a stopper for serious use. Having said this, I am aware of the effort many people are putting into LO and you are doing a great job (huge thanks)but we must sate things as they are...
As mentioned in my duplicate bug report, "As conditional formatting is applied based on the condition number in the sequence, we need 'Move Up' and 'Move Down' buttons next to the 'Add' and 'Delete' buttons so a user doesnt have to remove and re-add an entry to change the sequence ordering."
This is primarily needed in the conditional formatting management dialog (sc/uiconfig/scalc/ui/condformatmanager.ui) and entries in the dialog shouldnt be sorted alphabetically rather than how they were added into a document (bug 91654), but also needed in the conditional formatting dialog (sc/uiconfig/scalc/ui/conditionalformatdialog.ui) so that individual rules can be managed.
Migrating Whiteboard tags to Keywords: ( needsDevEval topicUI)
one more vote for this both inside a specific formatting and the list of ranges.
LO used to sort the main list by range but no longer does making it difficult to locate the range to be edited.
Same as all of you guys.
Fastidious to rearrange the order of conditions.
Despite the fact that Libre office has my favors,
this is a THUMB DOWN for it.
Manfred Blume committed a patch related to this issue.
It has been pushed to "master":
tdf#74074 Ability to rearrange order of conditions
It will be available in 5.4.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Thanks @Manfred, I think a lot of people will appreciate it.
Build ID: 2f7b05988e6853ddac68b614e9d83e05af08bc0f
CPU threads: 4; OS: Windows 6.19; UI render: GL;
TinderBox: Win-x86@42, Branch:master, Time: 2017-04-08_00:27:58
Locale: es-ES (es_ES); Calc: CL
Should not be solved as fixed?
Can it backported to 5.3?
> Should not be solved as fixed?
> Can it backported to 5.3?
The bugfix unfortunately involves UI & translatable string change, which excludes the possibility of backport . Sry about that ...
 unless one has L3 support and some1 also backports related translations for them
(In reply to Katarina Behrens (CIB) from comment #16)
> The bugfix unfortunately involves UI & translatable string change, which
> excludes the possibility of backport . Sry about that ...
>  unless one has L3 support and some1 also backports related translations
> for them
Forgive me for an inadequate request.
I have just updated LO to Version 22.214.171.124 (x64), but in CALCs Conditional Formatting management dialog I can't find a possebility to change the order of the rules. No clickable arrange buttons, no drag & drop an no cursor keys.
Did Manfreds patch make it into the 5.4.x releases?
Created attachment 140862 [details]
Screenshot on 5.4.5
Find attached an screenshot for 5.4.5.
There are the buttons New Delete Up Down
Thanks a lot Miguel!
I expected the buttons within the manage dialog and did not see, that it's possible to add multiple rules within one section.
And as I tested: The list order represents the priorisation of the rules. The topmost matching rule will be used (if condition is matched). May be it would be a good idea to advise the users, that the rules in the list are not processed from top till down, as I first thought.
Nice weekend to all! :-)