Created attachment 75131 [details] A test spreadsheet to show problems with duplicating conditional formatting If you select a cell and drag with the square box to duplicate the cell, the conditional 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). In the attached 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. This is a real problem when adding rows to an existing spreadsheet where some columns have conditional formatting. The formatting is missing from the new rows after existing rows are duplicated into them. I previously mentioned this as an aside in bug #61101, but it seems to be a separate problem so I made a separate bug report.
[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) Steps how to reproduce: 0. Open sample document from LibO Start Center 1. Check CF with menu 'Format -> Conditional Formatting -> Manage' > For Column U you only find CF in U4 Now try to apply CF to other cells 2. Click U4 > Cell cursor with fill handle around cell U4 3. 'Move cursor to Fill handle (cursor View changes to "+" -> Drag the fill handle to U5 -> release mouse button' > now U4:U5 selected Expected: cell U5 now has Conditional Formatting Actual: No CF in cell U5 (Check with menu 'Format -> Conditional Formatting -> Manage' Can be simply checked with a blank new Calc document (to avoid problems with unknown document conditions): 10. New blank document 11. Menu 'Format -> CF -> CF -> Add -> "Style = Heading if Cell value = 1"' <ok> 12. Type "1" to cell A1 > Style "Heading" as expected 13. Type "2" to cell A1 > Style "Default" as expected 14. Click cell A1, fill to cell A2 using fill handle > "3" Appears in A2 15. Type "1" to A2 Expected: Style "Heading" Actual: Style "Heading" as expected 16. Check CF with menu 'Format -> Conditional Formatting -> Manage' > only find CF in A1 So the problem is that the CF is correctly applied to A2, but incorrectly missing in 'Format -> CF -> Manage' dialog final Test: 21. Type "1" To cells A1, A2 > both shown in style Heading 22. Save -> Close -> Reopen Expected: A1, A2 shown in style Heading Actual: A2 shown in style "Default" So it seems 'CF-Manage' dialog has "guessed" that CF has been applied Dialog 'Format -> CF -> CF' will show the applied CF correctly for A2 Same problem with menu 'Edit Fill', and also a problem for fill row All this works fine with parallel Dev-installation of "Version 4.1.0.0.alpha0+ (Build ID: 2b9394f0c009b385756a0c5d75e3c1cd412f723) TinderBox: Win-x86@6, Branch:master, Pull Time: 2013-02-14_00:13:52" ENGLISH UI / German Locale on German WIN7 Home Premium (64bit) with LODev/4 Masters User Profile I did some research: This one is a DUP of "Bug 57050 - Conditional formatting after AUTOFILL is lost when the file is reopened" *** This bug has been marked as a duplicate of bug 57050 ***
Comment on attachment 75131 [details] A test spreadsheet to show problems with duplicating conditional formatting I obsolete this sample because many additional formatting effects might worry and distract from the essential facts. I recommend to do tests as per Comment 1 @Reporter: Please cite attachments in additional Bugs instead of attaching them at multiple bugs: <https://wiki.documentfoundation.org/QA-FAQ#How_to_use_attached_sample_documents_for_multiple_Bug_Reports>