https://bugs.freedesktop.org/show_bug.cgi?id=71707

          Priority: medium
            Bug ID: 71707
          Assignee: [email protected]
           Summary: FORMATTING: Conditional Formatting is incorrectly
                    linked on copied sheet
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.1.3.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 89371
  --> https://bugs.freedesktop.org/attachment.cgi?id=89371&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to