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

--- Comment #2 from [email protected] ---
Created attachment 75370
  --> https://bugs.freedesktop.org/attachment.cgi?id=75370&action=edit
conditional formatting insert row and copy/paste errors

Confirmed in 4.0.0.3 on Win Vista.

The attachment can be used to test some of the issues:

1) Select Row 1
2) Insert Row
Result is that the formula originally in A1 now in A2 refers to the wrong cell

Similar result if a cell is inserted above A1

3) Copy row 1
4) Paste in row 6 or below
Result is that the formula copied from A1 now refers to the wrong cell

Similar result if any number of rows including row 1 are copied and pasted

Copy and paste of rows not including row 1 (eg rows 2-4) copy the formats
correctly

In most cases, the incorrectly referenced cell is 2n-1 where n is the new row
number
Occasionally it’s the row range in the formula which is incorrect

Test whether or not the formula in column A is working by altering the text in
the adjacent column B

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