https://bugs.documentfoundation.org/show_bug.cgi?id=106242

            Bug ID: 106242
           Summary: FORMATTING: Conditional formatting wrongly copied (on
                    1st sheet only)
           Product: LibreOffice
           Version: 5.3.1.1 rc
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: stefan_lange...@t-online.de

Created attachment 131545
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131545&action=edit
zip-File with 2 spreadsheets to reproduce resp. demonstrate the error

There is a problem with conditional formatting at copy + paste of more than one
cell on the first or unique sheet of a spreadsheet document:

When a complete row should be copied to an other row and the first cell of the
row to copy is with conditional formatting (= difference to bug 106230), the
conditional formatting of the first cell is copied to all other cells of the
target row. When there were yet other conditional formattings in the row to
copy, they are lost. This is visible via Conditional formatting -> Manage.
See attached file "altix_Nummern_klein_V3_Row copied.ods": row 133 sheet "Altix
I bis III" and especially cell C133!

Reproduce the error:
1. open the file "altix_Nummern_klein_V3.ods" from the attached zip-File
2. go to the first sheet ("Altix IV und V") 
3. insert a row before e.g. row 133
4. copy row 132 and paste it to row 133

Actual result:
- Color of cell C133 is Magenta
- some other cells in row 133 are missformatted (alignment and/or color
Magenta)
- Conditional formatting -> Manage: for all cells xxx133 exists the same format
condition as for A133

Expected result:
- Row 133 should look like row 132
- Conditional formatting -> Manage: condional formatting should exist only for
A133, A134;A5:A132, C133 and C134;C5:C132 (for C133 same expression as for
C134;C5:C132)

Problem was reproduced with with LO 5.3.0 (release), LO 5.3.1 rc1,
Version: 5.4.0.0.alpha0+
Build-ID: 08750abc64a7ad82cac96adeb7a0bcdce7ac704d
CPU-Threads: 2; BS-Version: Windows 6.2; UI-Render: Standard; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2017-02-28_00:02:28
Gebietsschema: de-DE (de_DE); Calc: group

and also with LO 5.2.5 (release) and LO 5.2.6.1 (rc1).

The bug is similar to Bug 106230 - maybe a duplicate. But because the problem
of Bug 106230 is not reproducible with LO 5.2.5 and LO 5.2.6.1, I am not sure.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to