Created attachment 75092 [details] A simple spreadsheet to reproduce the problem. When I copy a range of cells where some contain conditional formatting and others do not, only the first range of conditional formatting is pasted. The result *looks* correct, but looking at "Manage" shows that only one range was added, and if the sheet is saved and reopened, most of the formatting disappears. I've attached a simple sheet which shows the problem easily. Just select the range F4:F26, click on copy, then paste it to cell N4. Notice that the highlights seem to have transferred, but if you open conditional formatting Manage, you'll only see one range of N cells, not three. I've been having lots of problems with my spreadsheets, mostly because the bugs in 3.6.3 messed them up royally. Now that I've updated to the current version, I'd reformat them by copying/paste columns, but that doesn't work as reported here, so fixing these sheets is too painful for now. I'm not sure this is the only problem (I've seen some truly baffling behavior with these sheets), but this is the first one I was able to reproduce in a clean sheet.
There is another, related problem I forgot to mention in the first message. If you select a cell and drag with the square box to duplicate it, the formatting appears to be copied, but it is not (as can be determined by looking in the "Manage" box, or by saving and reopening the sheet). On the test spreadsheet, select cell U4, and drag the box to duplicate the cell in the column (down to U12, for example). You'll see that the conditional formatting appears to be applied to all of these cells (and the conditional formatting box will say that it is applied), but "manage" under conditional formatting will not include the new cells in the cell range. So far as I can tell, only copy/paste on a range of identical cells, or applying formatting to a contiguous range of cells, works reliably. None of the other schemes I used to use (in 3.5 flavors) for copying cells with conditional formatting seem to work in 3.6.5.2 (this is still better than 3.6.3, where nothing seemed to work).
Having thought about this second problem some more, I realize that it is a separate problem so I've made a second bug report for it, #61136.
[Reproducible] with "LibreOffice 3.6.5.2 " German UI/ German Locale [Build-ID: 5b93205] {pull date 2013-01-18} on German WIN7 Home Premium (64bit) Works fine with 4.0.0.3. Might be related to / DUP of Bug 57050 or an other one, I will decide that later. WFM (target:4.0.0) for now.