<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Conditional formatting: selecting a cell range with the mouse gets you every cell individually, but not the range" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117332#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Conditional formatting: selecting a cell range with the mouse gets you every cell individually, but not the range" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117332">bug 117332</a> from <a class="email" href="mailto:tbauersfeld@web.de" title="Torsten <tbauersfeld@web.de>"> Torsten</a> <pre>Today I have checked all LibreOffice versions on all Systems. Linux LibreOffice 64 6.0.5.2 Windows 7 64 Libre Office 6.1.3.2 OSX Libre Office 6.1.3.2 Same Bug New try of explain: 1. put in B10 any kind of text for conditional formating 2. put in C10 1, C11 2 ... C16 6 3. select conditional formating 3. select formula is 4. put in sum(C10:C16)>10 5. select a format for B10 6. press ok This works If you select the cells C10-C16 with your mouse you will get not the range for the formula like in any other calculation program you get: $Tabelle1.$C$10$Tabelle1.$C$10$Tabelle1.$C$10:$C$11$Tabelle1.$C$10:$C$12$Tabelle1.$C$10:$C$13$Tabelle1.$C$10:$C$14$Tabelle1.$C$10:$C$15$Tabelle1.$C$10:$C$16$Tabelle1.$C$10:$C$17$Tabelle1.$C$10:$C$18$Tabelle1.$C$10:$C$17$Tabelle1.$C$10:$C$16 I expected $Tabelle1.$C$10:$C$16</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>