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

          Priority: medium
            Bug ID: 60311
          Assignee: [email protected]
           Summary: EDITING: Copy cells with CONDITIONAL FORMATTING
                    formula with wrong references after paste
          Severity: major
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 4.1.0.0.alpha0+ Master
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 74224
  --> https://bugs.freedesktop.org/attachment.cgi?id=74224&action=edit
Screenshot shows wrong row calculation

During my research for "Bug 60306 - EDITING: CONDITIONAL FORMATTING destroyed
after copy-paste cell" with [Version 4.1.0.0.alpha0+ (Build ID:
2823789bec0c029d9714aff0ed65923e23177ef) TinderBox: Win-x86@6, Branch:master,
Time: 2013-01-24_22:52:49] I found something strange with formula in CF cell
when I copy / paste to target:

Steps how to reproduce: 

0. Open both documents from Attachment 74218 for Bug 60306
1. In source.ods select row 65 by click on row heading
2. <control+c> for copy all row
3. In target document click A65
5. <control+v> for paste
   > Row contents will become pasted
6. As in step 5 also paste to rows 64 ... 54 and 66 ... 70 
   Expected: Comparison always to Cell in Column T of SAME row
             (as T65 in row 65)
   Actual: Reference to cell in different line of Column T, see list below and
           Screenshot

Souce:  $Tabelle1.$T65>$Tabelle1.$C$10   (Row 65)
Target: $Tabelle1.$T65>$Tabelle1.$C$10   (Row 65)    
        $Tabelle1.$T64>$Tabelle1.$C$10   (Row 63) !!
        $Tabelle1.$T63>$Tabelle1.$C$10   (Row 61) !!

Row reference is calculated wrongly for row different from Source row.

-- 
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