<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - conditional formatting not preserved with copy paste operations" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109280#c15">Comment # 15</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - conditional formatting not preserved with copy paste operations" href="https://bugs.documentfoundation.org/show_bug.cgi?id=109280">bug 109280</a> from <a class="email" href="mailto:villeroy@t-online.de" title="Andreas Säger <villeroy@t-online.de>"> Andreas Säger</a> <pre>Yes, LO broke the conditional formatting. It behaves consistently but with old limitations in AOO. Instead of applying the same c.f. 43 times to 43 rows you may try this: Click C2 and call the c.f. editor. At the bottom of that dialog expand the range from C2 to C2:C44. Expand the c.f. in D2 to D2:D44. Call the c.f. manager and delete all the c.f. that refers to a single cell. For easier consistent list keeping, I recommend to install my Python macro <a href="https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2350">https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2350</a> And to be honest: Maintaining clinical data in spreadsheets is beyond any definition of quality managment. nobody would bother if I would do that at home (which I don't); doing so in an institution is scandalous.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>