[Libreoffice-bugs] [Bug 91003] conditional formatting with function does not work properly
https://bugs.documentfoundation.org/show_bug.cgi?id=91003 --- Comment #4 from m.a.riosv --- Don't worry. What you can do before reporting, is ask for help in the forum: http://ask.libreoffice.org/en/questions/ or in the mailing list: http://nabble.documentfoundation.org/Users-f1639498.html -- 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
[Libreoffice-bugs] [Bug 91003] conditional formatting with function does not work properly
https://bugs.documentfoundation.org/show_bug.cgi?id=91003 --- Comment #3 from Peter --- Thank you for your lightning fast response. Yes, you are absolutely right. Sorry for bothering you. But maybe it makes sense to add an example to the help. -- 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
[Libreoffice-bugs] [Bug 91003] conditional formatting with function does not work properly
https://bugs.documentfoundation.org/show_bug.cgi?id=91003 m.a.riosv changed: What|Removed |Added CC||mari...@miguelangel.mobi --- Comment #2 from m.a.riosv --- Created attachment 115250 --> https://bugs.documentfoundation.org/attachment.cgi?id=115250&action=edit Sample file modified. Hi Peter, thanks for reporting. Use absolute/relative references in CF formulas it's very important. When you use a range in the CF formulas are adapted to every cell in the range similar as if you were copying them. In this case using absolute references in the CF formula preserves the average range for comparison with every cell value. So using: AVERAGE($B$7:$B$12) instead AVERAGE(B7:B12) makes CF work fine. -- 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
[Libreoffice-bugs] [Bug 91003] conditional formatting with function does not work properly
https://bugs.documentfoundation.org/show_bug.cgi?id=91003 Markus Mohrhard changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Markus Mohrhard --- The case with a formula does not work as you think. The formula is evaluated and checked if it returns true or false. Not if the current cell can be evaluated against the current cell. You can of course use a relative reference to the current cell in the formula which gives you the result that you want. Have a look at https://support.office.com/en-au/article/Use-a-formula-to-apply-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f and other documentation for conditional formatting with formulas. -- 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
[Libreoffice-bugs] [Bug 91003] conditional formatting with function does not work properly
https://bugs.documentfoundation.org/show_bug.cgi?id=91003 Peter changed: What|Removed |Added Hardware|Other |x86-64 (AMD64) OS|All |Linux (All) -- 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