| Summary: | FORMATTING: Conditional Formatting is incorrectly linked on copied sheet | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | oudeis69 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | CLOSED DUPLICATE | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.1.3.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=61946 | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | simple calc document showing the erroneous behaviour. | ||
Hi oudeis69, thanks for reporting. Are you sure, there are not both sheets selected when inserting the column? I can not reproduce the issue if only Sheet1 is selected. The two sheets weren't selected. How can I be so sure? Easy: the (visible) contents of row C in sheet2 is *not* moved... My explanation (and description) of the bug was not clear enough... The problem is with the conditional formatting only when using, e.g.: "Formula is" $C1="x" My wordings were not "correct" in the bug submission... |
Created attachment 89371 [details] simple calc document showing the erroneous behaviour. Problem description: The conditional formatting (formula type) of source sheet is copied to the destination sheet, but the contents of the conditional formatting formula still refers to the source sheet. Steps to reproduce: 1. create a simple conditional formatting on Sheet1.A1: =$C1="x" 2. copy Sheet1 as Sheet2 -> conditional formatting on Sheet2.A1: =$C1="x" 3. insert a column B in Sheet1 4. conditional formatting on Sheet2.A1 is now WRONG: =$D1="x" Current behavior: The copied sheet conditional formatting formulas refer to the wrong sheet Expected behavior: The copied sheet conditional formatting formulas must refer to the copied sheet and not to the source shett. Operating System: Ubuntu Version: 4.1.3.2 release