[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

Markus Mohrhard  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED
   Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail.
   |desktop.org |com

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

--- Comment #5 from p_kongs...@op.pl ---
Bug still present in  5.3.0.3

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

p_kongs...@op.pl changed:

   What|Removed |Added

 CC||markswins...@gmail.com

--- Comment #4 from p_kongs...@op.pl ---
*** Bug 104245 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu
Version|unspecified |5.2.3.3 release

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

 Blocks||87351


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
-- 
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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

--- Comment #3 from p_kongs...@op.pl ---
Bug still present in Version: 5.2.4.2

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

A (Andy)  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||stgohi-lob...@yahoo.de
 Ever confirmed|0   |1

--- Comment #2 from A (Andy)  ---
Reproducible with LO 5.2.3.3 (Win 8.1).

Small note: Before using the brush in step 3 I had to make sure that the
condition in step 2 is $sheet1.$B1 instead $sheet1.$B$1.

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

[Libreoffice-bugs] [Bug 104026] Conditional formatting is not updated when deleting a row

[bugzilla-daemon]

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

--- Comment #1 from p_kongs...@op.pl ---
The same issue happens if you add a row. As long as value in column A and B on
the inserted row is empty it shows no color, but if you type 1 in the cell a on
the row and the same value in B you will have a background color in A. This is
an error.

When checking the Format/Conditional Formatting/Manage you see in the inserted
colums 'Conditional Formats'/Range the value A4:A5 (inserted row 5) while in
'First Condition' 'Cell value is!=$sheet1.$B4. This is wrong.

When deleting a row, the value in 'Cell value is!=$Sheet1.$#REF!. This is also
wrong.

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